Kaizen 225 - Making Query-based Custom Related Lists Actionable with Lookups and Links

Kaizen 225 - Making Query-based Custom Related Lists Actionable with Lookups and Links


Hello everyone!
Welcome back to another post in the Kaizen series!

This week, we will discuss an exciting enhancement in Queries in Zoho CRM.

In Kaizen #190, we discussed how Queries bridge gaps where native related lists fall short and power custom related lists to present relevant and contextual information right alongside the CRM records. With Queries in related lists, you can dynamically fetch data from other modules, external services, or custom integrations, at runtime!

To take it up a notch, you can now use Queries and make custom related lists actionable with lookups and links!
This is super helpful when a record needs context across multiple related modules and the user experience must still remain intuitive and navigable.

This Kaizen explains a practical use case built using a Module-type Query, and explains how the serializer’s lookup and href support turns a static list into an actionable workspace.

Use case

Fetch Deals related to a Contact that are actively in negotiation or proposal stages, with account context preserved.

Business problem

Zoho CRM’s native related lists already provide a strong baseline experience.
For example, in the Deals related list on a Contact record, both Deal Name and Account Name are rendered as clickable lookups, but they show all related records, apply minimal filtering, and offer limited control over actions and presentation.

However, with Queries, you can precisely control which records appear, decide how navigation should work, introduce contextual actions alongside native navigation.

So, here's the requirement we will try to solve today.
From a Contact record, I want to see
  1. Only active Deals whose Stage is Proposal/Price Quote or Review/Negotiation.
  2. With Deal navigation preserved
  3. With intentional account-level actions, not just navigation

In short, I want the query to show me the Deals in these stages that this Contact is currently involved with and let me quickly research the associated Account externally.

Why a Module-type query?

This scenario requires
  1. Filtering Deals by Stage
  2. Selecting a focused set of fields
  3. Embedding the result as a related list on Contacts

Query configuration

Follow the steps in the help document to create a module-type query.
The following image offers a glimpse of the query.

Serializer - where the difference happens

The serializer is not used to recreate native behavior, but to redefine intent of displaying the Deal as an explicit lookup and the Account as a contextual action.
Here is the serializer code used in this example.
return result.map(record => ({
...record,
Deal_Name: {
id: record.id,
name: record.Deal_Name,
module: "Deals"
},
"Account_Name.Account_Name": {
id: record.id,
name: record["Account_Name.Account_Name"],
module: "Accounts"
},
Link: {
label: "Search Account on Google",
}
}));

Follow the steps in this Kaizen post to create a custom related list and associate it with a query.

The output


You can see that the related list Deals in Proposal and Negotiation has clickable Deal and Account lookups, and a link to search by the Account Name on Google, while the default Deals related list includes all Deals associated with this contact.

This approach is especially useful when you need filtered or curated views, introduce non-CRM actions, reduce click depth, and want the UI to guide user behavior subtly without peeling them away from the interface they are used to.

The design rule is to

  1. Use lookups when the destination is inside CRM
  2. Use href when the action is external or exploratory. Eg: open external systems, launch contextual research, pass params to external tools, etc.

Summary

By combining module-type queries for precise data selection, serializer lookups for native navigation, and serializer links for contextual actions, you can create related lists that are purpose-built, not generic.

That distinction is what makes Queries and serializers a powerful extension point in Zoho CRM.


We hope you found this post useful. Let us know your thoughts in comments or at support@zohocrm.com.
See you next week!

Cheers!

===============================================================================




      Zoho Campaigns Resources


        • Desk Community Learning Series


        • Digest


        • Functions


        • Meetups


        • Kbase


        • Resources


        • Glossary


        • Desk Marketplace


        • MVP Corner


        • Word of the Day


        • Ask the Experts


          • Sticky Posts

          • Kaizen #198: Using Client Script for Custom Validation in Blueprint

            Nearing 200th Kaizen Post – 1 More to the Big Two-Oh-Oh! Do you have any questions, suggestions, or topics you would like us to cover in future posts? Your insights and suggestions help us shape future content and make this series better for everyone.
          • Kaizen #226: Using ZRC in Client Script

            Hello everyone! Welcome to another week of Kaizen. In today's post, lets see what is ZRC (Zoho Request Client) and how we can use ZRC methods in Client Script to get inputs from a Salesperson and update the Lead status with a single button click. In this
          • Kaizen #222 - Client Script Support for Notes Related List

            Hello everyone! Welcome to another week of Kaizen. The final Kaizen post of the year 2025 is here! With the new Client Script support for the Notes Related List, you can validate, enrich, and manage notes across modules. In this post, we’ll explore how
          • Kaizen #217 - Actions APIs : Tasks

            Welcome to another week of Kaizen! In last week's post we discussed Email Notifications APIs which act as the link between your Workflow automations and you. We have discussed how Zylker Cloud Services uses Email Notifications API in their custom dashboard.
          • Kaizen #216 - Actions APIs : Email Notifications

            Welcome to another week of Kaizen! For the last three weeks, we have been discussing Zylker's workflows. We successfully updated a dormant workflow, built a new one from the ground up and more. But our work is not finished—these automated processes are

          Zoho CRM Plus Resources

            Zoho Books Resources


              Zoho Subscriptions Resources

                Zoho Projects Resources


                  Zoho Sprints Resources


                    Zoho Orchestly Resources


                      Zoho Creator Resources


                        Zoho WorkDrive Resources



                          Zoho CRM Resources

                          • CRM Community Learning Series

                            CRM Community Learning Series


                          • Tips

                            Tips

                          • Functions

                            Functions

                          • Meetups

                            Meetups

                          • Kbase

                            Kbase

                          • Resources

                            Resources

                          • Digest

                            Digest

                          • CRM Marketplace

                            CRM Marketplace

                          • MVP Corner

                            MVP Corner




                            Zoho Writer Writer

                            Get Started. Write Away!

                            Writer is a powerful online word processor, designed for collaborative work.

                              Zoho CRM コンテンツ




                                ご検討中の方

                                  • Recent Topics

                                  • Zoho Commerce - How To Change Blog Published Date and Author

                                    Hi Commerce Team, I'm discussing a project with a client who wants to move from Woo Commerce / Wordpress to Zoho Commerce. They have around 620 blog posts which will need to be migrated. I am now aware of the blog import feature and I have run some tests.
                                  • Does zoho inventory need Enterprise or Premium subsrciption to make Widgets.

                                    We have Zoho One Enterprise and yet we can't create widgets on inventory.
                                  • ZMA shows as already connected to Zoho CRM, but integration not working

                                    When I try to connect ZMA with Zoho CRM, it shows as already connected, but the integration doesn’t seem to be working. I’ve attached the screen recording for reference.
                                  • Automatic Email Alerts for Errors in Zoho Creator Logs

                                    Hello, We would like to request a feature enhancement in Zoho Creator regarding error notifications. Currently, Zoho Creator allows users to view logs and errors for each application by navigating to Zoho Creator > Operations > Logs. However, there is
                                  • Workflow Rule - Field Updates: Ability to use Placeholders

                                    It will be great if you can use placeholder tags to update fields. For example if we want to update a custom field with the client name we can use ${CONTACT.CONTACT_FIRSTNAME}${CONTACT.CONTACT_LASTNAME}, etc
                                  • Password Assessment Reports for all users

                                    I'm the super admin and looking at the reporting available for Zoho Vault. I can see that there is a Password Assessment report available showing the passwords/weak and security score by user. However I'm confused at the 'report generated on' value. Monitor
                                  • Can't change form's original name in URL

                                    Hi all, I have been duplicating + editing forms for jobs regarding the same department to maintain formatting + styling. The issue I've not run into is because I've duplicated it from an existing form, the URL doesn't seem to want to update with the new
                                  • Setting certian items to be pickup only

                                    How do we have some items that are pickup only? I have several items in my item's list that I do not ship. But they need to be on the website to be sold, and picked up in store. Need to be able to do this as one of these products is a major seller for
                                  • Using gift vouchers

                                    We would like to be able to offer a limited number of gift vouchers, of varying values, to our customers, and are looking for the best way to do this. We have looked at Coupons and Gift Certificates, but neither seem to fit the bill perfectly. Coupons:
                                  • Automatically updating field(s) of lookup module

                                    I have a lookup field, which also pulls through the Status field from the linked record. When the lookup is first done, the Status is pulled through - this works perfectly. If that Status is later updated, the lookup field does not update as well. As
                                  • Zoho Commerce and Third-party shipping (MachShip) API integration

                                    We are implementing a third-party shipping (MachShip) API integration for our Zoho Commerce store and have made significant progress. However, we need guidance on a specific technical challenge. Current Challenge: We need to get the customer input to
                                  • Adding custom "lookup" fields in Zoho Customization

                                    How can I add a second “lookup” field in Zoho? I’m trying to create another lookup that pulls from my Contacts, but the option doesn’t appear in the module customization sidebar. In many cases, a single work order involves multiple contacts. Ideally,
                                  • Can you import projects into Zoho Projects yet?

                                    I see some very old posts asking about importing project records into Zoho Projects. But I can't find anything up to date about the topic. Has this functionality been added? Importing tasks is helpful. But we do have a project where importing projects
                                  • Zoho Inventory. Preventing Negative Stock in Sales Orders – Best Practices?

                                    Dear Zoho Inventory Community, We’re a small business using Zoho Inventory with a team of sales managers. Unfortunately, some employees occasionally overlook stock levels during order processing, leading to negative inventory issues. Is there a way to
                                  • Automation #10 - Auto Assign Ticket based on Keywords

                                    This is a monthly series designed to help you get the best out of Desk. We take our cue from what's being discussed or asked about the most in our community. Then we find the right use cases that specifically highlight solutions, ideas and tips on optimizing
                                  • Automate attendance tracking with Zoho Cliq Developer Platform

                                    I wish remote work were permanently mandated so we could join work calls from a movie theatre or even while skydiving! But wait, it's time to wake up! The alarm has snoozed twice, and your team has already logged on for the day. Keeping tabs on attendance
                                  • Reusable Custom Functions Across Department Workflows

                                    Dear Zoho Desk Team, We appreciate the powerful workflow automation capabilities in Zoho Desk, particularly the ability to create and use custom functions within workflows. However, we have encountered a limitation that impacts efficiency and maintainability.
                                  • Don't Allow Customer to Edit Values After Submitting Ticket

                                    After a customer submits a ticket through the customer portal, they can go into the ticket and see some of the values from the questions they answered in the sidebar. Currently, a customer can edit these values even after they submitted them. This makes no sense. We ask very specific questions that we don't want customers to later change! Please disable the ability for customers to edit the values to their submission questions in the portal. Screenshot attached.
                                  • Analytics <-> Invoice Connection DELETED by Zoho

                                    Hi All, I am reaching out today because of a big issue we have at the moment with Zoho Analytics and Zoho Invoice. Our organization relies on Zoho Analytics for most of our reporting (operationnal teams). A few days ago we observed a sync issue with the
                                  • text length in list report mobile/tablet

                                    Is there a way to make the full text of a text field appear in the list report on mobile and tablet? With custom layouts, the text is always truncated after a certain number of characters.
                                  • Automation #4 - Auto Delete Tickets based on Rules

                                    This is a monthly series in which we pick some common use cases that have been either discussed or most asked about in our community and explain how they can be achieved using one of the automation capabilities in Zoho Desk. Unwanted tickets spamming
                                  • Zoho Community Digest — Enero 2026

                                    ¡Hola, comunidad! 🌟 Aquí os traemos las novedades más interesantes de Zoho durante este mes de enero, incluyendo actualizaciones de productos, integraciones y un recordatorio sobre los workshops certificados que vuelven a España. 🎓 Eventos y Comunidad
                                  • Automation #3 - Auto-sync email attachments to tickets

                                    This is a monthly series where we pick some common use cases that have been either discussed or most asked about in our community and explain how they can be achieved using one of the automation capabilities in Zoho Desk. Most of our customers use email
                                  • Automation #11 - Auto Update Custom Fields with Values from Emails

                                    This is a monthly series designed to help you get the best out of Desk. We take our cue from what's being discussed or asked about the most in our community. Then we find the right use cases that specifically highlight solutions, ideas and tips to optimize
                                  • Automation #13 - Auto assign tickets based on agent shift time

                                    This is a monthly series designed to help you get the best out of Desk. We take our cue from what's being discussed or asked about the most in our community. Then we find the right use cases that specifically highlight solutions, ideas and tips to optimize
                                  • Automation #14: Capture Jira Issue Key/ID in a Ticket Custom Field

                                    Hello Everyone! This month's edition brings you a custom function to consolidate your records associated with Jira integration. Jira integration enables support engineers and R&D units to collaborate seamlessly on feature development, product improvement,
                                  • Automation #16: Automate Ticket Reopening on Scheduled Timestamp

                                    Hello Everyone! This edition uncovers the option to schedule reopening a ticket automatically. Zylker Finance tracks insurance policyholder activities through Zoho Desk. For policyholders who pay monthly premiums, tickets are closed upon payment completion.
                                  • Automation#19:Auto-Close Tickets Upon Task Completion

                                    Hello Everyone! We’re excited to bring you another custom function this week. In this edition, we’ll show you how to automatically close tickets when all associated tasks are marked as completed. Let’s see how ZylkaPure, a leading water filter company,
                                  • Automation #15: Automatically Adding Static Secondary Contacts

                                    Rockel is a top-tier client of Zylker traders. Marcus handles communications with Rockel and would like to add Terence, the CTO of Zylker traders to the email conversations. In this case, the emails coming from user address rockel.com should have Terence
                                  • Improved UX design for Projects CRM integration

                                    The current integration embeds the entier projects inteface into the CRM this is confusing and allows users to get lost. For example as a user i navigate to an account and go down to the related projects list and want to get information about a specific
                                  • Link Purchase Order to Deal

                                    Zoho Books directly syncs with contacts, vendors and products in Zoho CRM including field mapping. Is there any way to associate vendor purchase orders with deals, so that we can calculate our profit margin for each deal with connected sales invoices
                                  • Transformer vos stocks en décisions intelligentes avec Zoho Inventory et Zoho Analytics

                                    Zoho Inventory permet de suivre facilement les niveaux de stock et d’anticiper les restockages. Pour de nombreuses entreprises, cela suffit à gérer les opérations au quotidien. Mais à mesure que l’activité se développe, cette clarté peut commencer à montrer
                                  • Security Enhancements | Migrate to the Updated Policies

                                    Hello everyone, Zoho Directory's security policies have been updated and reorganized into three new policies with features that enhance the overall organization security. These policies provide a stronger and more secure sign-in methods and improve the
                                  • Bring Zoho Shifts Capabilities into Zoho People Shift Module

                                    Hello Zoho People Product Team, After a deep review of the Zoho People Shift module and a direct comparison with Zoho Shifts, we would like to raise a feature request and serious concern regarding the current state of shift management in Zoho People.
                                  • Facturation électronique 2026 - obligation dès le 1er septembre 2026

                                    Bonjour, Je me permets de réagir à divers posts publiés ici et là concernant le projet de E-Invoicing, dans le cadre de la facturation électronique prévue très prochainement. Dans le cadre du passage à la facturation électronique pour les entreprises,
                                  • Quick Create needs Client Script support

                                    As per the title. We need client scripts to apply at a Quick Create level. We enforce logic on the form to ensure data quality, automate field values, etc. However, all this is lost when a user attempts a "Quick Create". It is disappointing because, from
                                  • How to block a WhatsApp user for sending spam

                                    Is there a way to block those whatsapp users that just come to play and annoy our service, they also spam us. We have a waba service with sales iq
                                  • Inquiry regarding auto-save behavior for Zoho Sign Embedded Sending

                                    Dear Zoho Support Team, I am currently integrating Zoho Sign's Embedded Sending functionality using iframes on my website. I would like to know if there is a way to ensure that the document state (including any added fields) is automatically saved as
                                  • Introducing Connected Records to bring business context to every aspect of your work in Zoho CRM for Everyone

                                    Hello Everyone, We are excited to unveil phase one of a powerful enhancement to CRM for Everyone - Connected Records, available only in CRM's Nextgen UI. With CRM for Everyone, businesses can onboard all customer-facing teams onto the CRM platform to
                                  • Automation#17: Auto-Create Tasks in Zoho Projects Upon Ticket Creation in Zoho Desk

                                    Hello Everyone, This edition delivers the solution to automatically create a task in Zoho Projects when a ticket is created in Zoho Desk. Zylker Resorts uses Zoho Desk for bookings and handling guest requests. Zylker resorts outsources cab bookings to
                                  • Next Page