Introducing Lookup filter in Zoho CRM

Dear All,

We're thrilled to talk about our much awaited enhancement to lookup fields—Lookup filter. Let'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 come in to 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 are 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 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 criteria: Business active is selected.

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

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

Besides 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 multi-select lookup field type.
The option will be available for Enterprise and Ultimate editions of Zoho CRM.

That's all about the enhancements. Find out more about lookup filters in our help doc.

Thanks!

P.S. These enhancements are currently available for all users in all DCs.

New to Zoho LandingPage?

Access Zoho LandingPage

Zoho LandingPage Resources

New to Zoho Survey?

Access Zoho Survey

Latest Feature Updates

Explore our Pricing & Plans

Zoho Survey Resources

Android Mobile Surveys

Insurvey Blogs

Insight Blogs

Tips & Tricks

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

New to Bigin?

Signup Now

Access Bigin

Latest Feature Updates

Zoho Desk Resources

Desk Community Learning Series
Digest
Functions
Meetups
Kbase
Resources
Glossary
Desk Marketplace
MVP Corner
Word of the Day

Tout forum

France ZUGs

Zoho SalesIQ Resources

Sticky Posts
Enrich your CRM data and keep them updated
You spend a lot of your time and efforts in generating quality leads for your business. While generating leads is a challenge in itself, the real deal begins when sales reps try to nurture these leads and convert them as customers. So how equipped is your sales team with information about your leads matters a lot. For example, you might be using webforms to generate leads and collect customer information from your website. The lesser your webform fields are, the more your sign-ups right? From optimizing
Zoho CRM Digest - February 2024
We're thrilled to bring you the February digest, packed with exciting product updates and engaging discussions from the Zoho CRM Community. Keep reading to stay in the loop! Product Updates: Zia Enhancements Be it Tasks, Calls, or Meetings, Zia's activity
Canvas templates can now be shared with different CRM organizations
----------------------------------------Moderated on 14th February, 2023------------------------------------------- Dear all, This feature is now open for all users in all DCs. To learn more about importing and exporting canvas templates, read our help
Introducing Zia Presentation in Zoho CRM
----------------------------------------Moderation 2.0, Date: 22nd March' 24----------------------------------------- The Zia Presentation feature is now available for organizations in both Enterprise and Ultimate editions with 20+ user licenses in the
Blueprint enhancements - Parallel and multiple transitions, and more
Last modified on Sep 4, 2023: All Zoho CRM users can now access these enhancements. Initially, these features were available only on an early access basis and by request. However, as of August 2, 2023, they have been made available to all users in all