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 Vertical, you can configure a Lookup filter to look for existing fields in Zoho Vertical that match the response of a form field under Lookup Mapping
NotesNoteLookup Mapping section is available only when you have added the Lookup Field in Zoho Vertical.
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 Vertical.
  2. Click Configure Lookup Filter.
  3. In the pop-up, define your Search Criteria. For example, Account Name (Zoho Vertical 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 Vertical 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 Vertical 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 Vertical
    3. If  none of the records  match: When none of the records in Zoho Vertical  match the Search Criteria, you can choose to:
      1. Not fill the lookup field
      2. Log an error without adding any record to Zoho Vertical
  1. Click Done.
    Configuring search criteria
  2. To make any changes to the configuration in the lookup filter, click View/Edit Lookup Configuration .
    Lookup field configuration

NotesNote : You can map a maximum of 3 lookup fields.


        Create. Review. Publish.

        Write, edit, collaborate on, and publish documents to different content management platforms.

        Get Started Now


          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 FormsEnterpriseOnline Data Collection Tool
                                Embeddable FormsBankingBegin 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 onboardingForms for Small Business
                                No Code FormsConstructionRSVP tool for holidays
                                Free FormsTravelFeatures for Order Forms
                                Prefill FormsNon-Profit

                                Intake FormsLegal
                                Mobile App
                                Form DesignerHR
                                Mobile Forms
                                Card FormsFoodOffline Forms
                                Assign FormsPhotographyMobile Forms Features
                                Translate FormsReal EstateKiosk in Mobile Forms
                                Electronic Forms
                                Drag & drop form builder

                                Notification Emails for FormsAlternativesSecurity & Compliance
                                Holiday FormsGoogle Forms alternative GDPR
                                Form to PDFJotform alternativeHIPAA Forms
                                Email FormsFormstack alternativeEncrypted Forms

                                Wufoo alternativeSecure Forms

                                TypeformWCAG


                                    All-in-one knowledge management and training platform for your employees and customers.

                                              Create. Review. Publish.

                                              Write, edit, collaborate on, and publish documents to different content management platforms.

                                              Get Started Now




                                                                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 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 Demo

                                                                                                          Get a personalized demo or POC

                                                                                                          REGISTER NOW


                                                                                                            Design. Discuss. Deliver.

                                                                                                            Create visually engaging stories with Zoho Show.

                                                                                                            Get Started Now








                                                                                                                                • Related Articles

                                                                                                                                • 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: ...
                                                                                                                                • 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 ...
                                                                                                                                • Search Filters

                                                                                                                                  Default Search Filters By default, the All Entries section lists all the form responses. To filter the entries, click the All Entries dropdown to switch between different entry views: All Entries: Lists all submitted form responses. Use the ...
                                                                                                                                • 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 ...
                                                                                                                                • 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. ...
                                                                                                                                  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