Advanced Search in a Lookup Field

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. The Advanced search option will enable you use the advanced search mechanism and zero down on the required records or field values in the lookup fields.

Note:
  1. The advanced search is available only for lookup fields with the display type set as dropdown or multi-select.
  2. If the lookup display field is either a user field or date-time field, then the basic search will disabled. And by default, the advanced search will be enabled.
  3. If there are more than 500,000 records in the lookup field, the the basic search will be disabled. And by default, the advanced search will be enabled.

Enable advanced search a lookup field

  1. Open the form builder.
  2. Select the required lookup field.
  3. Navigate to the Field Properties -> Choices section on the right.
  4. Check the checkbox next to Advanced Field Search option.

  1. Access the application.
  2. Navigate to the required lookup field.
  3. Click on the Advanced search button.

  4. The Advanced Field Search popup will appear.

  5. In the left pane of the popup, the lookup field(s) will be listed. Choose the required search operator and enter the appropriate search keywords.
    Note: The Is option will be default search operator.

  6. Click Search.
  7. The list of relevant search results will be displayed on the popup.

  8. Choose the required record and click Done.


  1. Understand Lookup field
  2. Configure bidirectional lookup
  3. Relationships between forms
  4. Unidirectional and bidirectional relationships

    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

                                                                                                      • Advanced search in a lookup field

                                                                                                        Advanced search in a lookup fieldWhen 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 ...
                                                                                                      • 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 ...
                                                                                                      • Create a search functionality to dynamically filter a report

                                                                                                        Requirement Create a search functionality for users to find specific records based on their search queries. Use Case An order management app is used by a business to store its customer details, and by billing agents to order products. There are three ...
                                                                                                      • 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 ...
                                                                                                      • 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 ...
                                                                                                        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