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.




 


    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