Field Lookup Handler

Field Lookup Handler

Overview

The field lookup handler can be used to fetch values for field options from external services in real-time. The two main instances are as follows:
  1. The field may require updated options from external services in real-time. In such cases, the data can be fetched using the field lookup handler instead of overloading the menu click handler or form change handler.
  2. The field may have more than 3000 options which is higher than the allowed limit. Therefore, instead of loading all the options in a single call, the developer can lookup/search the options in external services based on the query given by the user in real-time 

How to enable the field lookup handler?

Set the value of the lookup attribute in the required field object as true. And set a value for the triggerLength attribute to define the number of input characters after which the field lookup handler should be triggered.

When is the field lookup handler executed?

The field lookup handler is executed when the user starts typing the search string in the field. The menu developer can also set a minimum limit to the query string. This ensures the field lookup hander is triggered only when the user enters the required number of characters in the input field. 

Implementation of field lookup handler

The information will be passed through the following parameters to the field lookup handler.
 
form
Input collected from the user
user
Details of the user executing the menu.
entity
Details of the entity in which the menu is being used.
target
Field details which have been searched for more options
network
Details of the network in which the menu is being executed.
 
 
Attributes of Field Lookup Handler's response
 
Attribute
Property
Description
options
JSONArray
Maximum Size - 1000
The new array of options that has to be added to that field.
info
String (250)
The message that has to be displayed when the handler could not fetch the results matching the user input.
lookup
Available choices:  true/false
Default value:  True
When the required results have been fetched, the lookup property of the field can be changed to avoid further unnecessary lookups.
Table 1
 
The code shows how to update the options in a multiSelect field and disable the further lookups. 

{ "lookup":false,

"options":[

{

"id":"4000000009065",

"label":"Zoho Payments"

},

{

"id":"4000000009079",

"label":"Zoho Projects"

}

] }

The code given below is to display an information/blank state message when the handler could not fetch the results matching the user input:

{

      "info":"Please try again after some time." }
Result:




The field lookup handler will not be executed in the following cases:
  1. The field object's lookup value is set to be true, but the field lookup handler is not implemented.
  2. The field lookup handler is implemented, but the field object's lookup value is set to be false.




 



        Create. Review. Publish.

        Write, edit, collaborate on, and publish documents to different content management platforms.

        Get Started Now


          Access your files securely from anywhere

            Zoho CRM Training Programs

            Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

            Zoho CRM Training
              Redefine the way you work
              with Zoho Workplace

                Zoho DataPrep Personalized Demo

                If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

                Zoho CRM Training

                  Create, share, and deliver

                  beautiful slides from anywhere.

                  Get Started Now


                    Zoho Sign now offers specialized one-on-one training for both administrators and developers.

                    BOOK A SESSION







                                Quick LinksWorkflow AutomationData Collection
                                Web FormsEnterpriseOnline Data Collection Tool
                                Embeddable FormsBankingBegin Data Collection
                                Interactive FormsWorkplaceData Collection App
                                CRM FormsCustomer ServiceAccessible Forms
                                Digital FormsMarketingForms for Small Business
                                HTML FormsEducationForms for Enterprise
                                Contact FormsE-commerceForms for any business
                                Lead Generation FormsHealthcareForms for Startups
                                Wordpress FormsCustomer onboardingForms for Small Business
                                No Code FormsConstructionRSVP tool for holidays
                                Free FormsTravelFeatures for Order Forms
                                Prefill FormsNon-Profit

                                Intake FormsLegal
                                Mobile App
                                Form DesignerHR
                                Mobile Forms
                                Card FormsFoodOffline Forms
                                Assign FormsPhotographyMobile Forms Features
                                Translate FormsReal EstateKiosk in Mobile Forms
                                Electronic Forms
                                Drag & drop form builder

                                Notification Emails for FormsAlternativesSecurity & Compliance
                                Holiday FormsGoogle Forms alternative GDPR
                                Form to PDFJotform alternativeHIPAA Forms
                                Email FormsFormstack alternativeEncrypted Forms

                                Wufoo alternativeSecure Forms

                                TypeformWCAG

                                  Zoho FSM Video Tutorials


                                        All-in-one knowledge management and training platform for your employees and customers.

                                                  Create. Review. Publish.

                                                  Write, edit, collaborate on, and publish documents to different content management platforms.

                                                  Get Started Now




                                                                    You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                                                        Manage your brands on social media


                                                                          • Desk Community Learning Series


                                                                          • Digest


                                                                          • Functions


                                                                          • Meetups


                                                                          • Kbase


                                                                          • Resources


                                                                          • Glossary


                                                                          • Desk Marketplace


                                                                          • MVP Corner


                                                                          • Word of the Day


                                                                          • Ask the Experts


                                                                            Zoho Sheet Resources

                                                                             

                                                                                Zoho Forms Resources


                                                                                  Secure your business
                                                                                  communication with Zoho Mail


                                                                                  Mail on the move with
                                                                                  Zoho Mail mobile application

                                                                                    Stay on top of your schedule
                                                                                    at all times


                                                                                    Carry your calendar with you
                                                                                    Anytime, anywhere




                                                                                          Zoho Sign Resources

                                                                                            Sign, Paperless!

                                                                                            Sign and send business documents on the go!

                                                                                            Get Started Now




                                                                                                    Zoho TeamInbox Resources





                                                                                                              Zoho DataPrep Demo

                                                                                                              Get a personalized demo or POC

                                                                                                              REGISTER NOW


                                                                                                                Design. Discuss. Deliver.

                                                                                                                Create visually engaging stories with Zoho Show.

                                                                                                                Get Started Now








                                                                                                                                    • Related Articles

                                                                                                                                    • Menu Click Handler

                                                                                                                                      Overview The menu click handler will be triggered whenever the user selects the custom menu option from the dropdown. It can be used to perform a simple one-step action such as sharing a post link to a particular user on Cliq, or  open a form to ...
                                                                                                                                    • Form Change Handler

                                                                                                                                      Overview The form change handler can be used when the fields in the form dialog box should dynamically change values based on the user input. It can be also used to validate the user input and display an error message in case the input doesn't match ...
                                                                                                                                    • Form Submit Handler

                                                                                                                                      Overview The form submit handler is triggered when the user clicks the submit button in the form. This handler is used to validate the input data entered by the user and perform the custom menu's intended action. Implementation of Form Submit Handler ...
                                                                                                                                    • Share a Connect post in Cliq channel or in direct message

                                                                                                                                      Let us consider a custom menu to share the link of a connect post either in a channel or to individual users as a direct message. Handlers used Menu click handler Form change handler Form submit handler Breaking down the workflow of this 'Share in ...
                                                                                                                                    • Custom Menu - an overview

                                                                                                                                      Overview Custom Menu in Zoho Connect lets you add customized menus to entities such as status, tasks, events, in addition to the default menus—Follow, Print, Bookmark, and Copy post URL that are already available. They can be shared with a set of ...
                                                                                                                                      Wherever you are is as good as
                                                                                                                                      your workplace

                                                                                                                                        Resources

                                                                                                                                        Videos

                                                                                                                                        Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                                                        eBooks

                                                                                                                                        Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                                                        Webinars

                                                                                                                                        Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                                                        CRM Tips

                                                                                                                                        Make the most of Zoho CRM with these useful tips.



                                                                                                                                          Zoho Show Resources