Understand Lookup Field | Zoho Creator Help

Understand Lookup Field

Understand Lookup Field

The lookup field enables you to create a relationship between forms. Using this relationship you will be able to lookup data from another form in the same application or from a form in a different application in your Zoho Creator account. This mapping of data is done using the record ID. Each record that you add using your forms will generate a record ID, which serves as a backend reference to accomplish data sync. When you are filling a form, the lookup field will show the list of values or records that have been added in the related form. And when you choose a value and submit the current form, a mapping is established between both the forms and this mapping of data is done using the record ID.

Let's assume you are a law firm and you have a Legal Case Management application to run your business. The app has modules to store and view data on your lawyers, clients, cases that your firm is engaged in, case details, case histories, hearing details, payment details, and more.

The three important modules of this app would be:

  • a Lawyer form to capture all details of all the lawyers associated with your firm
  • a Client form for your client details
  • a Case Details form to capture details about the lawyer or lawyers handling the case, the client, and information on the case like documents related to the case, the payments made, and more

This Case Details form includes lawyer and client information which has already been captured in the Lawyer and Client forms. Instead of adding two new fields for Lawyer and Client you can add a lookup field in the Case Details form, through which you will be able to access the data in the other two forms and reuse them here, thus avoiding redundancy of data and fields.


Advantages of Using a Lookup Field

Lookup field helps you with:

  • Reducing the number of forms you create in your application.
    • For instance, you have a Staff Register for your educational institution. Let's say you want to capture attendance of your staff department-wise.You might create a form for each department with details of the staff for them to register their attendance individually, which might lead to you creating multiple forms (say you have 15 departments, you will create 15 forms). Instead you can create a separate Department form to capture all the 15 departments, and a Staff form to capture the list of Staff. Then you can create a Attendance register where you can lookup the Department and Staff, values using lookup field. You can create a common attendance register for all staff and at the same time categorize them based on departments, thus reducing the number of forms.
  • Data modeling.
    • Using the lookup field you will be able to establish relationships between your forms. This allows your forms and its data to interact with each other, enabling you to build a structured and unified data storage. This unification provides a track to link data and to create a process that is simpler and manageable.
  • Refer related data in another form.
    • You will be able to fetch the data by syncing the data stored in another form with the form at hand.

Lookup Field Traits

When you add the lookup field to your form, you need to do the following. Learn  how to add a lookup field

  1. Define the  Relation : Here you select the form that you want to establish a relationship with
    • You can create a new relationship or a unidirectional relationship, or
    • You can use an existing relationship, to create a bidirectional relationship.  Learn more
  2. Set the  Display Type : This defines the way in which the looked-up data will be displayed when your users access this lookup field, and the numbers of values your users will be allowed to select — one or many.
    • Dropdown : The looked-up data will be displayed in a dropdown, and your users will be able to select one value
    • Radio Button : The looked-up data will be displayed as radio buttons, and your users will be able to select one value
    • Multi Select : The looked-up data will be displayed in a drop-down menu, and your users will be able to multiple values
    • Checkbox : The looked-up data will be displayed as checkboxes, and your users will be able to multiple values

Customize Lookup's Display Fields

You can customize the manner in which the related form's records are displayed by your lookup field. You can have the lookup field display the data stored in one field of the related form, or from multiple fields. When you select multiple fields, you can define if any separator is to appear between the field values.  Learn how

The lookup field can display data from the following  types of field : name, address, email, phone, single line, number, percent, currency, decimal, auto number, radio, drop down, date, date-time, formula, users, ID, added user, modified user, added time, and modified time.

Note :  You can add only upto four display fields for your lookup field.

Allow New Entries Through the Lookup Field

There can be instances where the data (in the related form) that a user wants to look up, is not present in it. Instead of making the user access the related form, then add the required data, and then look it up from your form, you can enable them to add records to the related forms via the lookup field itself.  Learn how to enable this

After enabling the  Allow new entries  property of the lookup field, below is what a user will experience upon accessing your form:

  1. The  Add New Entry  option will be displayed by the lookup field as the last choice
  2. Clicking or tapping it will open the related form in a pop-up window, where you can enter and submit the required data
  3. The entered data will be added to the related form, and will also be selected in the lookup field

Set Value While Adding New Entries in the Lookup Field

As mentioned above, in a lookup field's Field Properties pane, you have the option to allow adding new entries to the looked-up form that pops up. If this is enabled, you can also allow auto-population of field values. That is, values entered by you in the current form (holding the lookup field) get preset in the looked-up form.  These populated values can be edited if needed before form submission. This saves you one step of replicating the information that you might have added in the current form before creating an entry in the lookup field.

To achieve this auto-population, you have to map the fields in the looked-up form where the data has to be replicated to the fields in the current form from which the data will be secured.
This configuration needs to be done from the edit mode of the application. Learn more 
Note: The following fields are not supported for auto-population: URL, Image, SubForm, Signature, File upload, Audio, Video, Auto Number, Formula, Section, Add Notes, Prediction, Keyword Extraction, Sentiment Analysis, OCR, Object Detection.

Let's assume you have configured the necessary field mapping for a lookup field in the edit mode of an application Employee Management. Now, say you've entered the following information in the live mode of a form Add Team:
In this form, Team Members is a lookup field. When you click +Add New in this field, the looked-up form Add Employee pops up. Upon loading, this looked-up form will have auto-populated field values from the matching fields in your current form. You can choose to edit the prefilled values or fill in other fields if needed before form submission. After submission, the record is added to the Add Employee form and is selected as a choice in the lookup field of the current Add Team form.

Filter the Records that the Lookup Field Displays

By default, the lookup field displays all the records present in the looked-up form. However, you can apply a filter based on data in the looked-up form. Learn how

The filter you set will be applied every time your users access the lookup field, both while adding and editing a record.

Other Field Properties


    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







                                                                                            You are currently viewing the help articles of Sprints 1.0. If you are a user of 2.0, please refer here.

                                                                                            You are currently viewing the help articles of Sprints 2.0. If you are a user of 1.0, please refer here.



                                                                                                  • Related Articles

                                                                                                  • Understand Lookup Field Properties

                                                                                                    This page is applicable to all report types except pivot chart and pivot table. Lookup field displays field values that are fetched from a field in a related form. This relationship is created when the field is introduced into the form on which the ...
                                                                                                  • Auto populate a field based on the selection from a lookup dropdown

                                                                                                    Requirement   When a value is chosen from a lookup dropdown, related values are populated in the other fields of the same form. Use Case   An order management app contains a form to store order details. When the admin chooses the customer name from ...
                                                                                                  • Configure bidirectional lookup field

                                                                                                    To configure bidirectional lookup: Navigate to the form builder. Drag and drop the lookup field. The Lookup field window appears. Select the Form from which you need to fetch data. Select the Field . Click the toggle button to Enable bidirectional ...
                                                                                                  • Advanced search in a lookup field

                                                                                                    When the Lookup field has large number of records then finding a particular record becomes cumbersome. Moreover, the basic search will display only 5000 results and manually scrolling down through these results to find the required record is tedious. ...
                                                                                                  • Understand checkbox field

                                                                                                    Understand checkbox fieldThe checkbox field enables your users to select one or more values from a predefined set of choices that are displayed as checkboxes. When to use this field?You may consider the following pointers to determine when to use a ...
                                                                                                    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