Configuring the Lookup Filter

Configuring the Lookup Filter

While adding a new record, adding a related list to an existing record, and updating a record in Zoho CRM, you can configure a Lookup filter to look for existing fields in Zoho CRM that match the response of a form field under Lookup Mapping
Note: Lookup Mapping section is available only when you have added the Lookup Field in Zoho CRM.
To lookup for a field that matches with a form field response,
  1. In the Lookup Mapping section, click Add Fields  and choose the Lookup field added in Zoho CRM.
  2. Click Configure Lookup Filter.
  3. In the pop-up, define your Search Criteria. For example, Account Name (Zoho CRM field) equals Account (Zoho Forms field).
  4. To add more than one criteria, click the   icon.

  5. After defining the criteria, you can select an action based on the results under Perform the action:
    1. If  only one record  matches: If only one record in Zoho CRM matches the Search Criteria, the lookup field will be filled with that record. 
    2. If  more than one records  match: When multiple records in Zoho CRM match the Search Criteria, you can choose to:
      1. Not fill the lookup field with any record
      2. Fill the lookup field with the first matched record
      3. Log an error without adding any record to Zoho CRM
    3. If  none of the records  match: When none of the records in Zoho CRM  match the Search Criteria, you can choose to:
      1. Not fill the lookup field
      2. Log an error without adding any record to Zoho CRM
  1. Click Done.

    search criteria
  2. To make any changes to the configuration in the lookup filter, click View/Edit Lookup Configuration .

    Lookup field configuration
Note : You can map a maximum of 3 lookup fields.

    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

                                                                                                      • Filtering the Rules

                                                                                                        If you have multiple rules configured in your form and wish to find specific rules that are configured using a form field, you can use the filter option. To do so, Click the filter icon in the top- right corner of the Rules summary. Select a form ...
                                                                                                      • Configuring Process Completion Email

                                                                                                        Under Approvals > Process Completion Email, you can configure email templates to trigger email notifications when the final approval status of an entry is approved/denied. You can configure the Process Completion Email under the following sections: ...
                                                                                                      • Configuring a Webhook

                                                                                                        In simple terms, a webhook is a way for one system or application to send real-time data to another system or application as soon as an event occurs. A webhook is basically a notification that is sent to a destination (URL) when an event occurs. With ...
                                                                                                      • Filter Entries by Form Language in All Entries / Reports

                                                                                                        Filter by Language You can filter and view the form entries based on the form language. To do this, Go to the All Entries / Report section of your form. Click the dropdown. You will see the list of all the languages the form has been translated to. ...
                                                                                                      • Search Filters

                                                                                                        Default Search Filters By default, the All Entries section lists all the form responses. To apply filters, click the All Entries dropdown as shown. You can filter entries based on the time they were submitted. You can also view the Partially Saved ...
                                                                                                        Wherever you are is as good as
                                                                                                        your workplace



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


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


                                                                                                          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