Filter leads by multi select lookup field

We have modules `Leads` and `Marketing Events` and they are connected via a Multi Select Lookup. All is well on that front.

`Marketing Events` have a `code` field that is commonly used internally, it is much shorter/easier to use and is unique to the event (whereas the `Name` is not). These events repeat yearly, so each has a new code, but same event name.

Sample event fields:

`Name: Halloween`

`Code: 2024-Halloween`

Note: We use the `Name` to display externally via api, so we cannot change the name to be the code.

Problem:
If we try to filter `Lead` by `Marketing Event`, the `filter Marketing Event is` list has 10 `Halloween` events in the picklist and they are indistinguishable.

Ideal solution:

`Lead` filter by `Marketing_Event.code is 2024-Halloween` in the user interface (expressed as pseudocode)

Am I missing an easy way to filter Leads my by multi select lookup relationship module field?

Access your files securely from anywhere

Zoho Developer Community

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

Topic Participants
Kevin
Pheranda Nongpiur

Sticky Posts
Gain 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 transparency
Identify and prioritize profitable deals: Zoho CRM Forecasts help users focus on revenue-driving opportunities
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—some will take time, and others may never close. This varying momentum directly impacts the organization’s
Context 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
Investigate your losses using VoC's root-cause analysis
Dear Customers, We hope you're well! Loss and customer churn are inevitable in any business, even for historically successful ones. While it's never pleasant to see customers leave, it's crucial for businesses to identify the triggers behind these losses
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