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.




 


    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









                                            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

                                                  Zoho Desk Resources

                                                  • Desk Community Learning Series


                                                  • Digest


                                                  • Functions


                                                  • Meetups


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner


                                                  • Word of the Day


                                                    Zoho Marketing Automation

                                                      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 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 ...
                                                                                                              • Custom Menu - an overview

                                                                                                                Feature Availability 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 ...
                                                                                                              • User Sync in Zoho Connect

                                                                                                                Feature Availability Overview Most organizations use enterprise directory systems (such as Active Directory or LDAP) to maintain employee, group, and application information. For larger organizations, it can be difficult to manually add and manage ...
                                                                                                                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