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

                                                                                                              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