Cross module filtering is now supported in CRM | Zoho CRM

Cross module filtering is now supported in CRM | Zoho CRM

Editions: All
DCs: All
Release plan: This enhancement is being released in phases. It is now available in AU, JP, and CN DCs.
Help resource: Advanced filters
InfoThe Cross-module filtering enhancement is now available to all CRM accounts in the following data centres: AU, CN, JP, SA, CA, and EU. Please note that this enhancement is still being opened in phases for accounts in the US and IN data centres.
Alert
Update: 28th November 2024:
The Cross-module filtering enhancement is now available to all the CRM accounts in the US DC. We will be opening to all accounts in the IN DC in a couple of days.
Info
Update: 9th December 2024:
The Cross-module filtering enhancement is now open to all the accounts in all the regions. Thank you.

Hello everyone,

In Zoho CRM, you can quickly find records in each module using advanced filters.
  • You can use the fields in that particular module to filter its records. For example, you could filter leads by industry, identify contacts by title, and find deals by amount. After filtering, you can perform actions on the filtered records.
  • As you know, records are not limited to their fields. They are also related to other modules and include subforms to track line items. For example, a contact is linked to deals (another module), and a sales order contains product line items (in a subform).
However, filtering records in a module using its subforms or other modules was not possible until now. For example, you couldn't find:
  • Contacts With Deals above a particular amount
  • Contacts without any open Deal created this quarter
  • Sales orders with a specific product in its subform's line items
  • Sales orders with a specific quantity of a product in its subform's line items, and so on.
To handle such use cases, you can now filter by related modules and filter by subforms. Both options are available within advanced filters.

Filter by Related Modules (Standard and Custom)

You can now filter records in a module based on related modules. For example, you can filter contacts with deals. To help you narrow down your results further, you can add fields from the related module in the criteria.



Continuing with our example, you can find contacts that:
  • Have deals
  • Have deals in a specific stage
  • Have deals in a specific stage, with the last activity occurring in the previous month
  • Do not have deals
  • Do not have deals in a specific stage
  • Do not have deals in a specific stage where the last activity occurred in the previous month, and so on.

Filter by Subforms

A subform lets you associate multiple line items to a single record. For example, a sales order record will have a subform called Ordered Items. This will list the products, quantity of each product, and other details related to that sales order.

You can now filter by the presence (or absence) of line items. In addition, you can add criteria using the fields of the subform to find exactly the records you need.


For example, you can filter sales orders that
  • Have ordered items
  • Have ordered items with a specific product
  • Have ordered items with a specific quantity of a specific product
  • Do not have ordered items
  • Do not have ordered items with a specific product
  • Do not have ordered items with a specific quantity of a specific product, and so on
By combining and selecting from these options, you can quickly filter records in a module and perform necessary actions.

Notes
Note: This enhancement lets you filter records in a module using fields from its child modules (related modules). For example, filtering contacts based on deals' fields.

We're working on adding the ability to filter a module's records based on fields from its parent modules (lookup modules). This will let you do things like filtering contacts based on their account's fields. We'll make an announcement once this is available for release.
AlertLimits
A maximum of 3 subforms or related modules can be selected.
A maximum of 5 fields can be selected for each subform or related module

Please share your feedback in the comments section below!



        • Recent Topics

        • Version history for Zoho CRM Functions

          Hi Zoho Support, I am wondering, there is no topics been posted for requesting the Zoho CRM Custom Functions Version history. It would be great to have mandatorily needed feature in Zoho CRM custom functions. Is there any work going on for this feature.

        • Zoho CRM's V8 APIs are here!

          Hello everyone!!! We hope you are all doing well. Announcing Zoho CRM's V8 APIs! Packed with powerful new features to supercharge your developer experience. Let us take a look at what's new in V8 APIs: Get Related Records Count of a Record API: Ever wondered

        • Bookmark order

          Hi all, We have a very big document/template that requires manual editing after doing a mail merge. To make this easier, I thought I would add bookmarks to navigate to the areas that will require editing. I thought these would be in order that they appear

        • Train Zia answer bot on only part of Knowledge Base?

          We are trialing Zia answer bot and hope to use it on the knowledge base to help our users find the information they are looking for. I have found how to train Zia on the entirety of our knowledge base. But is there a way to train it on only certain categories

        • How do I associate an expense to multiple projects?

          How do I associate itemized expenses to multiple projects, like assigning each line to the respective project

        • Show Zoho Books Retainer Invoice in Zoho CRM

          Hi Support, How can I get Retainer Invoices created in Zoho Books to show in Zoho CRM? If a sales person needs to collect an upfront deposit, they should be able to see that the retainer invoice has been created and paid. Thanks, Ashley

        • Creator portal user do not accept user password upon creation

          I placed a request at Zoho and they are working on it, but I try here too in case somebody has already the answer: Today, sudently, my customers that tried to join the portal were not abble to enter a valid password, even if the password had all the necessery

        • Shopify sales orders creating a new account in Zoho

          Hi all, I am having a slight issue with the shopify integration. Whenever a customer purchases from the store, shopify automatically creates a sales order in inventory. The issue is that it creates a new account for the customer's name instead of attaching

        • Its 2022, can our customers log into CRM on their mobiles? Zoho Response: Maybe Later

          I am a long time Zoho CRM user. I have just started using the client portal feature. On the plus side I have found it very fast and very easy (for someone used to the CRM config) to set up a subset of module views that make a potentially extremely useful

        • Multiple Zoho Attendees in a Customer meeting

          We are having constraints with having to log duplicate meetings when we have 2 Zoho users attending a customer meeting. What are the options to resolve this? You can add participants, but you cannot report on them. What can be done to avoid creating so

        • Allow 2 logos for Branding, one for Light Mode and one for Dark Mode?

          Our logo has a lot of black text on it. If we leave the background transparent, per recommendation of Zoho, when a user is viewing a file and turns on dark mode, our logo is not really visible and looks really weird. It would be really great if we could

        • ZOHO Desk-Enable Ticket Notification sound

          Hi, I answer the helpdesk tickets for Sevenstar. How can I enable the Ticket Notification sound when I receive a new ticket?

        • CRM Campaign -> Create Campaign ->Zoho Campaign. Add to Sender Address dropdown options (2024/08/01)

          I'm trying to add different Sender Address and Reply-to Address options to a new campaign created through Zoho CRM. There is one sender and reply-to address available and it is not the account I'm logged in with. The dropdown options do not match what

        • Create new ticket when another specific ticket is closed

          Hi. How can I create a ticket when another specific ticket is closed? So I have a ticket with subject 'Create agreement' connected to the contact of a customer. As soon as I close this ticket, I want that a new ticket is created (connected to the same

        • How can a Zoho Desk Admin access restricted files?

          How can a Zoho Desk Admin access restricted files from Zoho Desk that are not displayed to agents on tickets due to file type restrictions?

        • Why is my Lookup field not being set through Desk's API?

          Hello, I'm having trouble setting a custom field when creating a Ticket in Zoho Desk. The endpoint I'm consulting is "https://desk.zoho.com/api/v1/tickets" and even though my payload has the right format, with a "cf" key dedicated to all custom fields,

        • Ticket template - Send email to multiple contacts

          Is it possible to set up a ticket template with multiple contacts selected to receive an email, rather than just one contact as the default? We use Zoho Desk to send an email report to a group of contacts every day, and have to manually add each email

        • 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

        • Feature Request – Support for Stripe Direct Debit for Canadian Customers in Zoho Books

          I’d like to request support for Stripe Direct Debit as a payment option for Canadian customers within Zoho Books. Currently, while Stripe credit card payments are supported for Canadian businesses, there is no option to enable Direct Debit (ACH/EFT) through

        • Client Script also planned for Zoho Desk?

          Hello there, I modified something in Zoho CRM the other day and was amazed at the possibilities offered by the "Client Script" feature in conjunction with the ZDK. You can lock any fields on the screen, edit them, you can react to various events (field

        • Zoho desk domain mapping not working

          Hi, I have followed this knowledge base support from your zoho site: https://help.zoho.com/portal/kb/articles/support-customers-from-your-own-domain-domain-host-mapping . First created a sub-domain(support.website.com), then went to zone editor to point "support.website.com" to cname desk.cs.zohohost.com . But it won't work out. What did I lack? Please I need it very much. Please see images below of the result: Please see below images of what I did: 1.)  2.) 3.) Hope to hear from you soon.

        • Zoho Analytics pulling data from Zoho Sheets and Zoho Forms

          It would be smart to have Analytics import data from Zoho Sheets or Forms. 

        • Feature Request – Support for Saskatchewan PST Self-Assessment in Zoho Books

          I’d like to suggest a feature enhancement for Zoho Books regarding Saskatchewan PST (SK PST) self-assessment. Currently, when filing the SK PST return using Zoho Books’ return generator, there is a field labelled “Consumption Tax”, which is intended for

        • Exporting Presentations with Embedded Integrations

          I am embedding Zoho Analytics charts and tables - how can I export the presentations so that the embedded images show ? At the moment it just shows broken images . *note* I do not need the exports to have the live data or links - just a snapshot of what

        • Bug in Total Hour Calculation in Regularization for past dates

          There is a bug in Zoho People Regularization For example today is the date is 10 if I choose a previous Date like 9 and add the Check in and Check out time The total hours aren't calculated properly, in the example the check in time is 10:40 AM check

        • Embedding Zoho Analytics - is the data always 'live' ?

          When embedding "live" Zoho Analytics data into a template with the intention of creating a monthly presentation - how are the embedded filters saved ? When a filter is applied to a presentation from a template is it then fixed for sharing or will it always

        • Customer/item(s) bought view

          Hello In Inventory/Customers/Transactions tab, how do I see what it is the customer actually ordered/bought without having to open each SO? Our customers buy a number of items thoughout the year. I've look at each transactions drop down, and no-where

        • Zoho Flow Doesn't Detect Desk Ticket Custom Field Change

          I have a Flow that is configured to be triggered when a custom field on a ticket changes. I also have a Schedule in Desk that runs a script that changes the custom field. When I change the custom field manually in the Desk interface, the Flow runs as

        • Weekly Tips: Track Email Engagement with Read Receipts in Zoho Mail

          While email is a convenient and widely used way to communicate, it doesn't offer the immediate feedback you get from face-to-face conversations or phone calls. When we send an email, there is no way to know for sure if the recipient has acknowledged its

        • Reusable Variables

          I’d like to know if there’s a way to store variables in Zoho Analytics that I can use in metrics or calculations. For example, I have a Currencies table that stores the value of different currencies over time. I’d like to use the value of the US dollar

        • The Invoice Status in Zoho Finance is misleading

          We have many overdue invoices, but when we try to filter it by Status Overdue in the Zoho Finance Module it shows it as none This is also creating a problem when I need to Create a Chart or KPI for overdue Invoices If I open the Invoice I can see the

        • If Problema Formula

          Ceil(Datecomp(${Seguimiento de Venta.Fecha de la proxima visita},Now())/1440) Tengo porblema al plantear el If Quiero que si el valor es dega

        • Multi-Select lookup field has reached its maximum??

          Hi there, I want to create a multi-select lookup field in a module but I can't select the model I want the relationship to be with from the list. From the help page on this I see that you can only create a max of 2 relationships per module? Is that true?

        • Customer Portal Zoho Desk | Sort ticket list

          Hello, If you view the ticket list inside the desk portal (https://xyc.zohodesk.eu/portal/de/myarea?departmentId=xyz) all tickets are displayed depending on the filters: department "my tickets" / "team tickets" status group/type channel My questions:

        • HTML Code + Writer Documents

          Hello, I am in the process of writing a couple of documents in Writer. Both document will have 2 versions each. One version being a freebee that perspective clients can download from my website. The other version will be a paid version, and additional

        • This mobile number has been marked spam. Please contact support.

          Hi Support, Can you tell me why number was marked as spam. I have having difficult to add my number as you keep requesting i must use it. My number is +63....163 Or is Zoho company excluding Philippines from their services?

        • Audit Log: Detailed View and Export for Better Tracking

          Audit log tracks all the events or actions performed by the users and displays them in a sequential order. By default, all users who have admin access can view the audit log. We have added new features to the audit log that will enhance the user experience

        • Display All Admin Roles in Zoho One Admin Panel

          Hi Zoho One Team, I hope you're doing well. Currently, in the Zoho One Admin Panel, we can see Org Admins and Service Admins assigned to specific applications. However, admins assigned at the organization level for various Zoho apps (such as Mail, Cliq,

        • Enable users to create and edit presentations in your web app using Zoho Office Integrator

          Hi users, Did you know that your users can create, edit, and collaborate on presentations from within your web app? With Zoho Office Integrator's embeddable presentation editor, you can easily add these capabilities. Here are the highlights: Create presentations:

        • Forced Logouts - Daily and More Frequent

          In the last month or so, I've been getting "power logged out" of all of my Zoho apps at least daily, sometimes more frequently. This happens in the same browser session on the same computer, and I need to re-login to each app separately after this happens.

        • Next Page