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.

    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





                          Quick LinksWorkflow AutomationData Collection
                          Web FormsEnterpriseBegin Data Collection
                          Interactive FormsWorkplaceData Collection App
                          CRM FormsCustomer ServiceAccessible Forms
                          Digital FormsMarketingForms for Small Business
                          HTML FormsEducationForms for Enterprise
                          Contact FormsE-commerceForms for any business
                          Lead Generation FormsHealthcareForms for Startups
                          Wordpress FormsCustomer onboardingOrder Forms for Small Business
                          No Code FormsConstructionRSVP tool for holidays
                          Free FormsTravel
                          Prefill FormsNon-Profit

                          Intake FormsLegal
                          Mobile App
                          Form DesignerHR
                          Mobile Forms
                          Card FormsFoodOffline Forms
                          Assign FormsPhotography
                          Mobile Forms Features
                          Translate FormsReal EstateKiosk in Mobile Forms
                          Electronic Forms

                          Notification Emails for FormsAlternativesSecurity & Compliance
                          Holiday FormsGoogle Forms alternative GDPR
                          Form to PDFJotform alternativeHIPAA Forms
                          Email Forms
                          Encrypted Forms
                          Embeddable Forms
                          Secure Forms
                          Drag & drop form builder
                          WCAG



                                            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


                                                  • Desk Community Learning Series


                                                  • Digest


                                                  • Functions


                                                  • Meetups


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner


                                                  • Word of the Day


                                                  • Ask the Experts


                                                    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: Submitted Time: Options include Today, Yesterday, Last 7 days, and ...
                                                                                                                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