Now filter your records by multi-select pick list values from a dropdown with additional operators

Now filter your records by multi-select pick list values from a dropdown with additional operators

Hi everyone, 

Here's an update to help you elevate your filtering experience. You can now say goodbye to the cumbersome string values in filtering places for your multi-select picklist fields and say hello to a dropdown interface.

It is now possible for you to filter your data with precision and accuracy with the convenience of displaying values in a dropdown just like in single picklist fields. For instance, when you filter your leads using the IS operator for a single picklist field, its values appear in a dropdown. However, in the case of multi-select picklist fields, the values needed to be manually entered and then they would appear in a string.This would prove to be quite challenging owing to the lack of awareness of all the values that existed in the system. It is to simplify that process that you can now view your multi-select picklist values in a dropdown and choose your option/s from it. 



Here's a GIF to help you understand the update better.


Introduction of new operators

Now that you have understood this feature update, let's move into the next update - the introduction of new operators, namely:

  • Includes All

  • Includes Any

  • Excludes All

  • Excludes Any

Note. You can select only 5 values for each multi-select picklist dropdown with the said operators. 

Includes All and Includes Any


Includes All

One of the multi-select picklist fields that the Zylker Travels has included in its leads form is Assistance Requirements.

The options it offers are:

  • Complete Package

  • Hotel Bookings

  • Travel Guides

  • Transportation

  • Flight Booking

  • Food Provision on Treks

A sales rep handling domestic customers wants to filter out leads who have selected Hotel Bookings, Travel Guides, and Transportation.

Robert Hamilton, Steven Whidden, and Larry Halstead are prospects who have opted for all three options. Therefore, while filtering out leads, when the rep selects the operator 'includes all', choosing all values, the said leads appear.

Includes Any

When the rep tries to filter out leads who have opted for any one of the options, the system throws up the names of eight records who meet the criteria.



Excludes All and Excludes Any


Excludes All

The rep wants to filter out leads who have not selected all of the following values from the activities provided:

  • Experience Fine Dining

  • Wineries and Vineyards

Following the same strategy (using the Excludes All operator) as has been mentioned above, the system throws the names of 10 records who meet the criteria. 



Excludes Any 

The rep now wants to filter out leads who have not opted for either of the said options. 



Note.

  • If a user opts for five multi-select picklist fields while filtering records with the new operators, they forfeit the ability to select any more multi-select picklist fields utilizing the same operators. The user can still opt for more multi-select picklist fields, but with different operators (not Include/Exclude).

  • In a custom view and smart filters together, only 5 multi-select picklist fields with the new operators can be used. For example, if a user utilizes four multi-select picklist fields in a custom view using the new operators, they can choose only one multi-select picklist field in smart filters using the new operators.


Here's a table to help you understand the behavior of some important operators:



Note.

The updates - both dropdown as well as additional operators - will be available for Custom Views, Smart Filters, Reports, Portals, Analytics and GDPR. Eventually, it will be added to other areas of CRM as well.

This feature is being released in a phased manner.

That's all for the announcement. Please share your feedback in the comments below. 

    Nederlandse Hulpbronnen


      • Recent Topics

      • Why can't I see images uploaded by other users in the Library for Campaigns

        We are several users of zoho Campaign. I have uploaded visuals of our company, but my team members can't see them.
      • zoho sheet stuck

        I Need help. ZOHO sheets stuck on the loading screen. I've already deleted the system cache and cookies of my browser (google chrome) but it's still not opening. 
      • Turn off Knowlege Base Follow options and Follower lists

        Is there a way to hide or turn off the option in the Knowledge Base for users to follow specific departments/categories/sections/articles? If not, is there a way to turn off the public list of followers for each of those things? Otherwise, customer names
      • Future Orders - Due Date

        Hi In my role, I can receive tickets where the work required is requested months in advance. Using a Future Orders option, which I believe was setup under the On Hold status type, hides the Due Date, in all views/ticket etc. Whilst I understand the reasoning
      • Tip of the Week #78 – Cut response time with multichannel shared inboxes

        If you’ve ever felt your team juggling between multiple email accounts, social pages, and chat apps just to reply to customers, you’re not alone. Managing conversations in multiple channels can quickly turn messy. Important messages across inboxes, replies
      • Need a way to run a client script longet than 10 seconds

        By The Grace of G-D. Hi, Currently, Client Scripts are Timing out at 10 seconds. We have complex logics that needs more time. Can you add a feature request to increase the timeout?
      • FSM - Associating a Contact with Service Addresses

        Hi FSM team, I've come across an FSM limitation I wanted to share for improvement. I'm currently configuring FSM for a client who provides heating system install and maintenance services. The are often sub contracted by building management companies to
      • Exciting Updates to the Kiosk Studio Feature in Zoho CRM!

        Hello Everyone, We are here again with a series of new enhancements to Kiosk Studio, designed to elevate your experience and bring even greater efficiency to your business processes. These updates build upon our ongoing commitment to making Kiosk a powerful
      • FSM Improvement Idea - Show an Import button when there is no data

        I am setting up FSM for a client and I noticed that there is no option to import data, see screenshot below. Even when you click Create Contact there is only an option to Import from Zoho Invoice. It is only after you add at lease 1 record that the Import
      • Duplicate customers being created in Desk

        Hi I've trying to work out why I've getting duplicated customers being created in my desk. I have an external booking system that generates an email when I get a customer booking a job. A booking email gets sent to Desk where I manage the booking and
      • Unable to Send Different Email Templates for Different Documents in Zoho Sign

        Hello Zoho Community, I am facing a limitation with Zoho Sign regarding email notifications sent to customers when a document is sent for signing. Currently, whenever I send any template/document for signing, the email notification that goes to the customer
      • Timeline Tracking Support for records updates via module import and bulk write api

        Note: This update is currently available in Early Access and will soon be rolled out across all data centers (DCs) and for all editions of Zoho CRM. The update will be available to all users within your organization, regardless of their profiles or roles.
      • How to change position button transtition of Blueprint?

        Hi Everyone, Look at my screenshoot, it is possible move the reject button to the right? I couldn't find that setting in the blueprint. Thank you.
      • Record history and ticket interaction tab in contacts and accounts

        Hello everyone! We have improved the History tab to help users trace updates in the interaction activity logs of the Contacts and Accounts detail pages in the Customer Module. This enhancement make it easier to get clear details about who made each update,
      • UI Improvement - Ability to Collapse Flow

        The UI for Flow is generally pretty good. However, when multiple decision trees are used, the layout can get pretty convoluted and hard-to-follow (see one of my Flows below): In these cases, even the auto-arrange fails to make this something that a normal
      • Tasks Statuses

        Hi, The task status "Completed" is a final status which closes the task. We need to have a status "Cancelled". However, when the status is set to "Cancelled", the task prompt still has a blue button to Close Task. When the customer clicks that and closes
      • Add Lookup Field in Tasks Module

        Hello, I have a need to add a Lookup field in addition to the ones that are already there in the Tasks module. I've seen this thread and so understand that the reason lookup fields may not be part of it is that there are already links to the tables (
      • Create New Tasks Layout in CRM

        I am able to do this in Leads, Contacts, Meetings, Calls - every other module, but cannot create a new layout in tasks. I have the appropriate access but it's simply not appearing as an option. Only "Standard" option shows. Please help!
      • Whatsapp Connection Status still "Pending" after migration

        Hello, I migrated my WhatsApp API to Zoho from another provider a day ago. So far the connection status is still “Pending”. There is a problem? How long does it usually take?
      • Meet Canvas' Grid component: Your easiest way to build responsive record templates

        Visual design can be exciting—until you're knee-deep in the details. Whether it's aligning text boxes to prevent overlaps, fixing negative space, or simply making sure the right data stands out, just ironing out inconsistencies takes a lot of moving parts.
      • Multi file upload

        Hi, I just wonder if one could upload multiple files in one shot, say between one and three files, without adding multiple File Upload fields? Thanks, Alalbany
      • Using IMAP configuration for shared email inboxes

        Our customer service team utilizes shared email boxes to allow multiple people to view and handle incoming customer requests. For example, the customer sends an email to info@xxxx.com and multiple people can view it and handle the request. How can I configure
      • Auto-Invite Users to Portals in Zoho CRM based on Conditions

        Hello Everyone, You can now automate portal invitations in Zoho CRM with the new Auto-Invite users feature in Portal management. No more manually enabling portal access one by one. With this enhancement, you can automatically send invites for users to
      • Zoho CRM for Everyone's NextGen UI Gets an Upgrade

        Hello Everyone We've made improvements to Zoho CRM for Everyone's Nextgen UI. These changes are the result of valuable feedback from you where we’ve focused on improving usability, providing wider screen space, and making navigation smoother so everything
      • Auto-sync field of lookup value

        This feature has been requested many times in the discussion Field of Lookup Announcement and this post aims to track it separately. At the moment the value of a 'field of lookup' is a snapshot but once the parent lookup field is updated the values diverge.
      • Zoho Recruit Subscription

        Hello Zoho Recruit Team, Good day! I would like to inquire about your recruitment subscription plans and would also like to verify the current subscription our company is enrolled in under Zoho Recruit. Thank you, and I look forward to your response.
      • Keyboard shortcut M key

        I'm trying to customize my keyboard shortcuts and assign the "m" key. But it says the key is already assigned. I've looked through all my shortcuts and can't see any assigned "m". When I select an email and press the M key, nothing happens. What is the
      • Is it possible to create a meeting in Zoho Crm which automatically creates a Google Meet link?

        We are using Google's own "Zoho CRM for Google" integration and also Zoho's "Google Apps Sync" tools, but none of them provide us with the ability to create a meeting in Zoho CRM that then adds a Google Meet link into the meeting. Is this something that
      • Ensure Consistent Service Delivery with Comprehensive Job Sheets

        We are elated to announce that one of the most requested features is now live: Job Sheets. They are customizable, reusable forms that serve as a checklist for the services that technicians need to carry out and as a tool for data collection. While on
      • Automatic Portal invite

        We have numerous customers we move through a blueprint in deals, when they get to a certain point we need to give them portal access, how can this be done through deluge or a workflow? Latest Update (December 2025): The option to automate portal invitations
      • Marketer's Space: Why mobile optimization deserves a place in your email strategy

        Hello Marketers, Welcome back to Marketer's Space! Today, we'll talk about the importance of creating mobile-friendly email designs. While mobile phones were once used only to make phone calls, today they're used for almost everything, including texting,
      • Enhancements in Canvas

        Dear All, Greetings! Canvas lets you design the record details page to suit your brand or business preferences. We are glad to introduce the following enhancements to uplift your design experience. Reusable Components Style Presets Let's go! Reusable
      • Introducing Dark Mode / Light Mode : A New Look For Your CRM

        Hello Users, We are excited to announce a highly anticipated feature - the launch of Day, Night and Auto Mode implementation in Zoho CRM's NextGen user interface! This feature is designed to provide a visually appealing and comfortable experience for
      • ABN with Legal Entity Name

        Hi, How can I execute this? The ABN number is entered in Accounts Module and ideally, it should display or suggest the correct Legal Entity Name based on the ABN lookup. ex. Account Name: JPG Resources ABN Number: 65 067 761 871 Legal Entity Name: (auto
      • Presenting ABM for Zoho CRM: Expand and retain your customers with precision

        Picture this scenario: You're a growing SaaS company ready to launch a powerful business suite, and are looking to gain traction and momentum. But as a business with a tight budget, you know acquiring new customers is slow, expensive, and often delivers
      • Has CSS Changed for Common Elements?

        I noticed today that the standard title headings on my Forms and Reports display smaller in size than before. Google Dev Tools (attached), seems to confirm my suspicion. Something appears to be overriding the 1.375rem to 1.125rem. The font size on the
      • Text snippet

        There is a nice feature in Zoho Desk called Text Snippet. It allows you to insert a bit of text anywhere in a reply that you are typing. That would be nice to have that option in Zoho CRM as well when we compose an email. Moderation Update: We agree that
      • Zoho Cliq not working on airplanes

        Hi, My team and I have been having this constant issue of cliq not working when connected to an airplane's wifi. Is there a reason for this? We have tried on different Airlines and it doesn't work on any of them. We need assistance here since we are constantly
      • Prepopulating Fields

        Hello, I have a form (Assets) with 2 lookup fields: Client (from Clients) Site (from Client Sites) I modified the code (highlighted in red below), so the Site dropdown shows the list of sites related to the Client. must have Client_Site ( type = picklist
      • What is the difference between Zoho Campaigns and marketing hub?

        Zoho Campaigns is a permission-based email marketing tool for sending marketing emails and mass emails. Marketing Automation is a multichannel marketing automation tool that caters to organizations looking for tools to engage their users across multiple
      • Next Page