New in CRM: Dynamic filters for lookup fields

New in CRM: Dynamic filters for lookup fields

Alert
Last modified on Oct 28, 2024:
  • This feature was initially available only through Early Access upon request. It is now available to all users across all data centers, except for the IN DC.
  • Users in the IN DC can temporarily request access using this form until the full roll-out is complete for the IN DC.
  • Resources: Help documentation
Dear customers,

Early last year, we gave you filter options in lookup fields. The lookup filter has been highly successful in simplifying data entry. This feature allows you to select valid records from a lookup field, making it easier to associate the accurate records.

Today, we're thrilled to share our latest additions to lookup filters: introducing dynamic filter criteria.


Picture this scenario where a sales manager is finalizing a complex deal and needs to involve a subject matter expert (SME) for extra support. Using the current lookup filter tool, they can narrow down the options to active SMEs, streamlining the process and saving time.

However, it would be more efficient if the available SMEs were listed based on their service expertise or technical handling required for the deal. This is where traditional lookup filters fall short.

Enter dynamic filters for lookup fields! 
  • Dynamic filters enhance the lookup functionality by adapting in real-time to the data you're working with. Once configured, dynamic lookup filters change the lookup results based on the field values in the current module. This means the filters compare fields in the lookup module with those in the current module.
So, using our example, you can create a dynamic lookup filter to assign SMEs or Service Experts to deals, where the lookup search will display results only when the Service Expertise matches the Service Requiremets of the deal.



  • Additionally, for lookups in a subform, users can filter records by doing field-to-field comparisons with fields in both the layout and the subform itself.
Consider another scenario where a sales team associates a vendor in the Vendor Details subform within the Deals module. Using dynamic filter functionality, vendors can be displayed based on the industry type of the customer for whom the deal is being created. This ensures that the lookup search is precisely tailored to the customer's industry type, enhancing relevance and minimizing erroneous vendor associations.


Key Highlights

  • Tailored data views: Dynamic filters offer a more targeted approach to data association, avoiding information overload.
  • Enhanced relevance: By automatically adjusting to the current record’s context, dynamic filters save time and minimize data entry errors.
InfoAlert
Availability:
  • Lookup filter is supported for the following field type: Lookup and user lookup fields.
  • The option will be available in the Enterprise and Ultimate editions of Zoho CRM.
That's all for the enhancements in this installment, folks! Let us know of your thoughts and feedback in the comments below.


Thanks,
Nizamuddin



        • Recent Topics

        • Any insights about API/v2? Having problem for a while.

          I don't know why it is throwing a 404 error, my report name is correct. Has someone had this issue and how you fix it?

        • Custom Related List Inside Zoho Books

          Hello, We can create the Related list inside the zoho books by the deluge code, I am sharing the reference code Please have a look may be it will help you. //..........Get Org Details organizationID = organization.get("organization_id"); Recordid = cm_g_a_data.get("module_record_id");

        • Edit QR code with redirect to form

          Guten morgen, wir haben ein Formular Reklamation_erstellen. Dort soll ein QR Code erstellt werden, der im Lieferschein angezeigt wird. Beim Scannen auf dem soll das jeweilige Formular zum BEARBEITEN geöffnet werden. Leider bekomme ich es nur so hin, dass

        • Getting all the ingredients together for baking an app

          Good day everyone. After reading a lot of the help docs and watching videos, I now started on my app. To prevent hours and hours wasted on going down the wrong track, I would like some clarification on the following. But first some background: I have

        • Conditional Layouts On Multi Select Field

          How we can use Conditional Layouts On Multi Select Field field? Please help.

        • Help Needed with Configuring ZC Microservice

          I'm attempting to create a simple microservice, but am running into problems with scope and auth. Using Custom API Builder, here's my setup: 1. Method: GET 2. Auth: OAuth2 3. User Scope: All users 4. Response: Standard 5. Function: A function that returns

        • Creator Simplified #10: Predefine Form Field Values and Make Them Read-Only for Users

          Hey Creators, Ready for this week's tip in the Creator Simplified series? Today, we will explore how to have read only fields in a form. Use Case: Assume a scenario where the default value for a Department field needs to be English Literature, but you

        • Zoho Books | Product updates | November 2025

          Hello users, We’ve rolled out new features and enhancements in Zoho Books. From translating email notification templates to the new transaction locking restrictions, explore the updates designed to enhance your bookkeeping experience. Making Tax Digital

        • Direct link to Record Summary

          Hi everyone, In one of my reports, I have built a Record Summary template to display the details of one record. I would like to be able to link directly to this Record Summary once I submit a new record, without having to go to the list of records first and click on View. Is there a possibility to do so ?  Should I use the URL by passing some parameters ? Thank you very much for your help ! Guillaume

        • To Assign a genrated pdf to a file upload field using delug

          content = "<html><body>HTML Content on page One <div style='page-break-after:always'></div> HTML Content on page Two </body></html>"; file = zoho.file.convertToPDF(content); file.setFileName("Name of the file"); <variableName> = <FormLinkName>[ID == input.ID];

        • Zoho Mail : Email Outgoing Blocked

          I suddenly received the following message yesterday. I cannot send any mail. Please resolve as soon as possible, I cannot work without sending email. Dear User, We regret to inform you that your email outgoing has been blocked and you will not be able

        • Creator and Tables

          Good day. I am trying to create my first application. I have imported my data into Tables and am creating my app in Creator. I do not see my tables and cannot see how to write forms data to a table. Even the Workflow just uses the form. In one of the

        • Calendar week view: Today + 6

          Is there anyway to have the calendar change dynamically based on the date? Due to the amount of events, we only display a week at a time, but towards the end of the week, we can no longer see ahead to next week (without changing it manually every time).

        • customer Name and address details

          i created one application there is no customer details in that . how to add customer details and

        • Recalculate every row in the subform

          Hello, Can anyone help me with a script, please? I have an issue. Sometimes it happens, that in a multi row subform one of the rows show an incorrect row total value. Not really understand how it can happen, if I have a 20 row subform, 19 rows show correct

        • Creating Repeat Forms that remove redundancies

          I wanted to understand if you can make multi-layer forms that reduce the need for users to input information in again and again. We want a form that our suppliers fill out per ingredient they sell, and the end result should have the Ingredient (Section

        • What is the difference between the free plan and the mail lite plan?

          What is the difference between the free plan and the mail lite plan? How many emails can I send per day?

        • Unblock email

          Hi The outgoing mail from a client of me is blocked. I already made tickets and tickets are send to the EU desk but nobody is responding. The problem is already 4 days! There is absolutely no help from the support. I am really not satisfied at all! Can

        • Domain verification failure

          Hello Zoho Support, I purchased my domain directly through Zoho Mail, but the domain verification keeps failing with the message “TXT verification failed.” I’ve already waited and retried several times, but it still won’t verify. Could you please manually

        • Unable to send message;Reason:554 5.1.8 Email Outgoing Blocked.

          My email account is unable to send emails, and I urgently need to use it. How can I resolve this?If there is anything we have done wrong, please let us know in advance so we can actively cooperate to improve. User ID: 850482493

        • URGENT: Email stopped workin - can't access admin panel

          For some reason email sending stopped working. When I try to send an email it fails with "Unable to send message;Reason:451 4.7.1 Temporary system error" I can receive email just fine I see in my notifications some errors about the MX records, however

        • Can I associate an invoice to a Project after the fact?

          We have generated an invoice but would like to assoicate it to a Zoho Project after the fact.  Is there any way to accomplish that? Thanks, Scott

        • Emails I send as a cc or bcc NEVER GO THROUGH TO THA RECEIVER !!

          every time i send a cc or bcc copy of an email to anyone when I’m using my zohomail.com email - no one ever gets the cc of bcc copy if the email: why???? And i triple check that the email addresses are correct; then i get back an email message (EVERYTIME)

        • Cannot see correct DNS config for mail after moving domain to another provider

          I have moved my domain from one provider to another and after that zoho mail stopped working (expected). Problem is, zoho mail admin panel still shows (10 hours after move) that all records are correct while I haven't changed anything in my domain DNS

        • Add Support for Authenticator App MFA in Zoho Desk Help Center

          Hello Zoho Desk Team, We hope you are doing well. We would like to request an enhancement related to security for the Zoho Desk Help Center (customer portal). Currently, the Help Center supports MFA for portal users via SAML, JWT, SMS authentication,

        • Zoho Desk - Custom Module Related List Columns on Tickets

          I have a custom module in Zoho Desk called Asana Tasks, each task has a lookup to a Ticket. On the Ticket I want to see the columns of the Asana Tasks in the related list . Is there a way to do this? Right now it just has the name of the record and I

        • What is your opinion of the new UI?

          Hi Everyone, I would like to see what everyone thinks of the new Zoho One Dashboard. I don't get it, but perhaps I'm missing something. What are your thoughts?

        • How to unlink a SAML user from the existing Zoho Desk user (domain change case)

          Hi everyone, I’m trying to understand how to handle a situation where a customer changes their company domain. In our setup, users authenticate via SAML, so when the domain changes, the SAML system treats them as a new user. However, in Zoho Desk, I’d

        • Price Managment

          I have been in discussions with Zoho for some time and not getting what I need. Maybe someone can help explain the logic behind this for me as I fail to understand. When creating an item, you input a sales rate and purchase rate. These rates are just

        • Related to zoho survey

          Hi team. I want to know something regarding zoho survey question builder. I have two questions each of dropdown (One answer) - question type. In the first question, there are 16 answer choices and in the second question, there are 3 answer choices. For

        • Creator HTML page refresh

          Hi, I have added around 5 different html snippets in single creator page. I understand, I can refresh the entire page from page script using Navigational URLs https://help.zoho.com/portal/en/kb/creator/developer-guide/others/url-patterns/articles/navigational-urls

        • 60 Days Into Zoho - Tiktok Branding Startup -7 Questions?!

          Wsp Everybody I co-own a TikTok Branding / Consulting Startup & have been using Zoho for the past 60 days - Am now looking to make our overall operations & processes more Efficient & Effective! Curious to know how others are using the platform & what's

        • Text Message

          When trying to sent a text message, it says its an error i should contact a zoho agent

        • Zoho POS is now available for Canadian retailers

          Hey everyone, We're excited to introduce the all-new Canadian edition of Zoho POS, which helps retail businesses simplify and manage their end-to-end business operations. Start by signing up and exploring the 15-day free trial. Sign up now How does Zoho

        • Zoho CRM - Option to create Follow-Up Task

          When completing a Zoho CRM Task, it would be very helpful if there was an option to "Complete and Create Follow-Up Task" in the pop-up which appears. It could clone the task you are closing and then show it on the screen in edit mode, all the user would

        • Payroll In Canada

          Hi, When can we expect to have payroll in Canada with books 

        • Mass update to change or shift all project dates and keep project structure + shift all sub-tasks dates with main tasks

          Most users would expect that if they change the start date of their project then that will be reflected inside the actual project and any project structure would be retained.  Additionally if a task list with associated sub-tasks is moved, most users would expect that those sub-tasks would also be moved along with their parent task.  This is not the case. For a total Project shift of dates: * the start and end date from > "Edit Project" page can have a radio button added to "shift all project tasks

        • Closing Accounting Periods - Invoice/Posting dates

          Hi, I have seen in another thread but I'm unsure on how the 'transaction locking' works with regards to new and old transactions. When producing monthly accounts if I close December 24 accounts on 8th Jan 25 will transaction locking prevent me from posting

        • In-person ZUG Meetups for Real Estate Professionals - US Q1 2026

          The Real Estate Zoho User Group is going on a multi-city, in-person meetup tour across the US, and we’d love to see you there! These meetups are a great opportunity to: Connect with fellow real estate professionals using Zoho Share challenges and discover

        • Calls not being logged

          Hi, my outgoing calls are not picking up on zoho

        • Next Page