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.
Access your files securely from anywhere
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
Nizamuddin Sohel SK
Cameron
Hugh Marshall
Thiago
Maadhari M
Sticky Posts
Focus Group Webinar - Streamline Record Creation with Wizards
Hi there, With all the time your users spend on record creation, do you feel like they have the most seamless experience while doing it? For different types of records or those with a LOT of fields, do your users spend time navigating to enter data repeatedly?Notes and Attachments visibility can now be restricted based on profiles
Dear All, We hope you're well! We are here with a quick update about Notes and Attachments profile permissions. In the past, a record's Notes and Attachments were visible by default to all users with record access. However, as notes and attachments canIdentify and prioritize profitable deals: Zoho CRM Forecasts help users focus on revenue-driving opportunities
Post moderated on: 7th November: Release update: This feature is now available for users in all DCs. Dear Customers, We hope you're well! At any given time, a sales rep handles multiple deals, each progressing at its own pace. But not all deals will succeed—someGain control over record sharing with portal users through our new enhancement: criteria-based data exposure
Dear Customers, We hope you're well! Portals is a self-service avenue through which your clients can access and manage their direct and related data in Zoho CRM. This empowers them to be more independent and enables them to experience a sense of transparencyContext and convenience just got better with Zia's email intelligence
Dear Customers, We hope you're well! We are in 2024, and email as a tool is only getting more powerful each day. While it enables seamless daily correspondences, we are here with a set of abilities that will enhance your user experience and save several
New to Zoho TeamInbox?
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 Campaigns Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー