Lookup filter in Zoho CRM

Lookup filter in Zoho CRM

Last modified on 13/04/2023: Lookup filter is now available for all Zoho CRM users in all DCs. Note that it was an early access feature available only upon request. As of March 24, 2023, it is rolled out for al Zoho CRM accounts. Find out more about Lookup filters in our help doc.

Hello All, 

We're thrilled to talk about our much-awaited enhancement to lookup fields—Lookup filterLet's get into the details!

As you all know, lookup fields help you associate data from one module to another. You can lookup a record from module B and associate it with a record in module A. However, there could be scenarios, where you want only specific records to display while looking up. This is where the lookup filter comes into play.

Lookup filter
A lookup filter is a new property introduced to the lookup field. It enables you to define criteria, such that only the eligible records from the lookup module are listed during the lookup activity.
This paves the way to simplify record association and ensure only eligible and correct information from the database is associated.

How does it work?
As discussed earlier, a lookup filter is a new property added to the lookup field.
All you have to do is to head to the lookup field's property in the layout editor, enable the Filter lookup records checkbox, and define the criteria.

Let's look at an example!

Let's say you want only active accounts to be displayed for a lookup field present in the deal module. You can create a filter criterion: "Business active" is "selected."

Now, during deal creation, when the sales rep looks up for accounts, only the active ones are displayed and associated.

This way, the sales rep need not rummage through an exhaustive list of records to select the active accounts.

In addition to this, you can also choose to validate the filter criteria during record edit. Let's say, for an existing deal, if you'd like to validate this criteria, you enable validation and after every record edit, the filter will be validated and the record will be saved only if it fits the criteria.

Points to be noted:
  • Lookup filter is supported for the following field type: Lookup and user lookup fields.
  • Currently, the filter is not available for the multi-select lookup field type.
  • The option will be available for Enterprise and Ultimate editions of Zoho CRM.
That's about today's announcement!

Thanks and have a good one!

P.S.: Lookup filter is available only in the web version of Zoho CRM. We will notify you when it becomes available for mobile devices.

Note (Added on 10/03/2023): Lookup filter is now available for both mobile and web application of Zoho CRM.

                            Zoho Desk Resources

                            • Desk Community Learning Series

                            • Digest

                            • Functions

                            • Meetups

                            • Kbase

                            • Resources

                            • Glossary

                            • Desk Marketplace

                            • MVP Corner

                            • Word of the Day

                                Zoho Marketing Automation
                                        • Sticky Posts

                                        • [Early Access] Voice of the Customer (VoC) for Zoho CRM

                                          Happy new year, everyone! We have an exciting addition to our suite of features and would like to introduce you to VoC (Voice of the Customer) for Zoho CRM, powered by Zia. 2023 is definitely the best time to be a customer with rapid innovations and advancements
                                        • Adding calls as a channel in Voice of the Customer

                                          Dear All, We hope you're well! It's been almost a year since we opened Zoho CRM's Voice of the Customer solution up for early access. We are grateful for the reception and support you have been showing us with regards to its adoption and feedback. Since

                                        Manage your brands on social media

                                                Zoho TeamInbox Resources

                                                  Zoho DataPrep Resources

                                                    Zoho CRM Plus Resources

                                                      Zoho Books Resources

                                                        Zoho Subscriptions Resources

                                                          Zoho Projects Resources

                                                            Zoho Sprints Resources

                                                              Qntrl Resources

                                                                Zoho Creator Resources

                                                                  Zoho WorkDrive Resources

                                                                    Zoho Campaigns Resources

                                                                      Zoho CRM Resources

                                                                      • CRM Community Learning Series

                                                                        CRM Community Learning Series

                                                                      • Tips


                                                                      • Functions


                                                                      • Meetups


                                                                      • Kbase


                                                                      • Resources


                                                                      • Digest


                                                                      • CRM Marketplace

                                                                        CRM Marketplace

                                                                      • MVP Corner

                                                                        MVP Corner



                                                                          Design. Discuss. Deliver.

                                                                          Create visually engaging stories with Zoho Show.

                                                                          Get Started Now