Eighth Insight - Oversee module relationships with Lookups

Eighth Insight - Oversee module relationships with Lookups

The Wheels of Ticketing - Desk Stories

Oversee module relationships with Lookups


‌Learning about lookups

A lookup field provides a powerful way to display and utilize data from another module directly within a field of your current module. This functionality establishes a seamless connection between different data sources, enabling users to access and work with related information effortlessly. Rather than duplicating data, which leads to inconsistencies and increased data management complexity, a lookup field acts as a bridge that consolidates information.

A lookup field enables users to retrieve and display data from a specific module based on an established relationship between two records. The data from the associated record is displayed within the lookup field, making it easy to view and use related information. Lookup fields are generally editable and show information retrieved from the associated record.
Quote
Lookup fields help display related information, filter data based on related fields, and manage complex relationships between different modules.
IdeaIn a ticketing system, the Contact ID field in the "Tickets" module is a lookup field that retrieves contact information from the "Contacts" module. 

Linking modules

To create connections between two custom modules, it's essential to incorporate lookup fields. These fields are added to module layouts to establish relationships across different modules, whether they are standard-standard, custom-standard, or purely custom. For example, an "Assets" custom module can connect to another custom module or a standard module, such as "Contacts."

This connection allows users to link relevant records (such as contacts) with their respective items (like assets), making it easier to access and view information from either module. Adding a lookup field establishes a direct relationship, which enables users to perform actions such as linking, viewing, unlinking, or generating new tickets without needing to navigate away from the current module.

The importance of linking two modules through a lookup field lies in its ability to enhance information flow and improve data accessibility. By forming distinct relationships between various data points (such as assets and contacts), Zoho Desk facilitates more effective tracking, management, and resolution of customer inquiries and operational tasks. 
Info
Users with the "Manage Layouts and Fields" permission or those in a support administrator role can connect custom or standard modules by adding a lookup field to the module's layout (Standard layout for custom modules) through an easy drag-and-drop interface. 

How it works in practice

There was a small but mighty help desk company called "Fix Tickets." The team at Fix Tickets was dedicated to resolving customer issues promptly and efficiently. One day, they decided to improve their ticketing system with a new feature: lookup fields.


On Monday morning, a customer named Amy reached out with a problem. Her internet was down, and she submitted a ticket through the help desk portal to request assistance. As her ticket entered the system, a lookup field allowed the help desk staff to view relevant information from the Accounts module instantly, the Contracts module, as well as any past tickets. 

Using lookup fields eliminated the need for manual search, and a support agent quickly realized that Amy's account required verification. Meanwhile, Gunther received an email update regarding the status of the customer's ticket. They sent Amy an email update with instructions to verify her account and restore her connection. The entire process was seamless, all thanks to the lookup field functionality, which allowed Fix Tickets to access information quickly and enhance customer satisfaction.


As the week progressed, more tickets came in, and the team continued to rely on the lookup fields. They noticed a significant increase in their efficiency and a decrease in the time spent per ticket. Soon, customer satisfaction scores began to increase as positive reviews poured in from happy customers like Amy.

Uses of Lookup Fields

Data integrity

Lookup fields ensure that data entered into Zoho Desk is valid and consistent. By referencing existing data, such as user accounts or product information, you minimize the chances of errors and maintain the overall integrity of the database.

Consistency across records

Lookup fields ensure that the same values are used consistently across different records. This benefits teams by reducing duplication, enhancing the quality of data available in tickets, and providing team members with more insight into relevant information by linking records across modules.

Improved user experience

By allowing users to select from predefined options, lookup fields make data entry faster and easier. This reduces the time spent typing and searching for information, providing a more efficient ticket submission process.

Improved reporting and analytics

Lookup fields facilitate more accurate and meaningful reporting. By linking tickets to specific accounts, departments, or products, you can generate insights that help improve service delivery and customer satisfaction.

Streamlined workflow automation

Lookup fields can be utilized in workflow rules to automate ticket assignments and efficiently escalate issues. For instance, if a ticket pertains to a specific product, it can automatically be routed to the relevant product team.

Better relationship management

By associating tickets with customers or contacts through lookup fields, support teams can easily view related interactions and history. This context enables agents to provide more personalized and informed responses.

Simplified data management

Lookup fields enable organisations to manage relationships and processes involving various entities, such as users, products, and departments. Changes to the data automatically reflect wherever it’s invoked by a lookup field to ensure that all users are working with the most current and relevant information.

Faster issue resolution

Providing agents with quick access to related data through lookup fields speeds up the resolution process. Whether it’s identifying the correct department to solve a problem or accessing customer history to investigate an account issue, lookup fields enhance data quality, user experience, and operational efficiency.

Takeaway

Lookup fields can help your organization leverage its data to enhance all aspects of customer service, including routing and managing tickets, resolving customer inquiries, and reporting and analysis. This approach equips users with insights into exactly when and where they need them, which empowers them to make well-informed decisions and deliver effective service.

 

Please stay tuned for more Desk Feature stories.

 

Cheers,

 

Kavya Rao

The Zoho Desk Team


    • Recent Topics

    • Undelivered Mail uncategorized-bounce errors when sending invoices

      Recently we have been getting Undelivered Mail bounce notification when sending invoices. Reason: uncategorized-bounce Some go through no problem some bounce back. We recently sent 10 invoices, 6 received bounce notifications. After reaching out to the

    • Can I import MSG files into Microsoft 365 without Outlook?

      Yes, absolutely. You do not need Outlook installed to import MSG files into Microsoft 365. Aryson MSG file Converter is a dedicated tool that eliminates the Outlook dependency entirely, making the migration process simple and efficient for all users.

    • Feature Request - A Way To Search Item Groups

      Hi Inventory Team, I can't find any way to filter or search by fields of Item Groups. It would be great to see that functionality added. I have a use case where a single product might come from 5 or more suppliers and each supplier's item is an Item in

    • Zoho Books/Inventory - Update Marketplace Sales Order via API

      Hi everyone, Does anyone know if there is a way to update Sales Orders created from a marketplace intigration (Shopify in this case) via API? I'm trying to cover a scenario where an order is changed on the Shopify end and the changes must be reflected

    • Ticket id issues

      When I reply a ticket from desktop, it doesn't have ticket id in the subject and it's great. When I reply a ticket from Zoho desk mobile, Zoho adds ticket id in the subject and I don't want that. Please help in this matter.

    • Advanced email configuration - agent's name vs. department name

      We currently have all four Advanced Configuration options turned ON at the Global-level (Channels > Email > Advanced Configuration) - including the "Show Agent name in Ticket replies and outgoing emails" option. We also had that same option turned ON

    • Add Bounced as an Email Action / Notification for Bounced Emails

      This is one of the hard requirements for the clients we're servicing. They want to get an internal email notification whenever the email they sent to their contacts have bounced, so that they can look into it and update the email address. Currently, the

    • Files Uploaded to Zoho WorkDrive Not Being Indexed by Search Engines

      Hello, I have noticed that the files I upload to Zoho WorkDrive are not being indexed by search engines, including Google. I’d like to understand why this might be happening and what steps I can take to resolve it. Here are the details of my issue: File

    • not able to convert pdf to jpg and other forms and vice versa.

      i want to change my pdf to jpg, word, etc and some times jpg to pdf. i don't know how to do in this.

    • What’s New in Zoho Analytics - March 2026

      Hello Users! In this month's update, we bring improvements across integrations, security, reporting, and analytics capabilities to help you work with your data more efficiently and with greater control. Explore what’s new and see how these enhancements

    • Zoho People > Performance Management > Appraisal cycle

      Hello All I am using this 2 users to test out how it work on Performance Management User 1 - Reportee User 2 - Reporting Manager : Li Ting Haley User 1 : Self Appraisal Error How do i fix this error?

    • SalesIQ Tip for Admins: Guide Operators in Real-time Without Interrupting the Chat

      Consider this. You're a supervisor and you're looking through the active conversations. An associate is mid-chat with a high-value prospect. The prospect asks something unexpected, maybe about a tailor-made subscription plan or a bulk discount that’s

    • Early Access: Check Printing in Zoho Books

      Hello Everyone,   Are you constantly writing checks to pay your vendors?   We've got a great news to share with you! You can now pay your vendors by writing and printing a check directly from Zoho Books. The feature is ready and we'll be rolling it out to our customers in phases.  It is available in the  US Edition of Zoho Books and also in the Global edition, where the country is selected as USA and the currency is USD.   Here’s a summary of what’s possible:   1. Write and print a check. 2. Make

    • Connecting Zoho Inventory to ShipStation

      we are looking for someone to help connect via API shipStation with Zoho inventory. Any ideas? Thanks. Uri

    • Syncing zoho books into zoho crm

      I was wondering how I can use zoho books in crm as I have been using them separately and would like to sync the two. Is this possible and if so, how? Thanks

    • Zoho no support response.

      Problem is Zoho support seems to be just a concept. Just completing my trial, am ready to purchae 3 user subscriptions pending answer to a question, submitted two suport request during my trial that weren't responded to. Gave up trying the 888 line. Hard to imagine my production data in hosting environment with no support response.

    • Updating transaction number series for fiscal year 2026-2027 in Zoho POS

      A fiscal year or financial year is a 12-month period that businesses follow to manage and track their financial activities such as expenses, revenue, and taxes. This doesn't need to match the calendar year (JAN-DEC) and varies based on region, and tax

    • Lack of Looping and Carry-Forward Functionality in Zoho Survey

      Zoho Survey currently does not support looping or carry-forward functionality, meaning it is not possible to dynamically generate follow-up questions based on each option selected in a previous question or to pipe selected responses (such as {Looping

    • Forecast in Zoho CRM Just Got Smarter with an upgraded Zia Intelligence

      Hello Everyone, We are here with an interesting enhancement to Forecasts in Zoho CRM — Enhanced Zia Insights for your sales Forecast. Imagine a regional sales manager reviewing their team’s performance using forecasts in Zoho CRM. Instead of switching

    • Update TDS and TCS rates for Income Tax Act, 2025 (effective April 1, 2026)

      Hello everyone, The Income-tax Rules, 2026 (G.S.R. 198(E), dated March 20, 2026) have been notified, marking a significant structural shift in India’s direct tax framework. From April 1, 2026, the Income Tax Act, 2025 replaces the Income Tax Act, 1961.

    • Service line items

      Hello Latha, Could you please let me know the maximum number of service line items that can be added to a single work order? Thanks, Chethiya.

    • Automation Series: Auto-assign Resources as Task Owners

      In Zoho Projects, task ownership can be set automatically during task creation, allowing resources to be assigned based on the task name. Resources are work equipment or tools added to the portal to monitor their usage across projects. They can be assigned

    • Subform edits don't appear in parent record timeline?

      Is it possible to have subform edits (like add row/delete row) appear in the Timeline for parent records? A user can edit a record, only edit the subform, and it doesn't appear in the timeline. Is there a workaround or way that we can show when a user

    • AI secretary

      In our company, Claude is the secretary and creates inquiries and schedules from Gmail. You no longer have to enter them yourself. The secret is that we created an MCP server that connects to CRM. https://x.com/Mac_nishio/status/1917954562566328694

    • 5 small changes to Recruit that make a big difference

      Sometimes, the biggest improvements aren’t new features, they’re small changes that make everyday actions feel smoother. Over the past few weeks, we’ve made a few such updates across Zoho Recruit. They’re subtle, but together, they remove friction from

    • Project Management Bulletin: March, 2026

      We are passionate about equipping our users with efficient solutions that help them run their businesses successfully. Our collective efforts over the past 2 years have culminated in the launch of Sprints 3.0— built with reliable features, impactful integrations,

    • New security enhancements for portal users: MFA and password management

      Hello everyone, We are excited to announce three major security enhancements that are now available to portal users in Zoho CRM: Organization-wide multi-authentication for portal users - Admins can enforce multi-factor authentication across the entire

    • [Free Webinar] Learning Table Series 2026 – Customer agreement & contract management using Zoho Creator

      Hello everyone, We’re excited to announce the next session in Learning Table Series 2026, where we will continue with our purpose-driven approach—focusing on how Zoho Creator’s features help solve real-world business challenges. Each session in this series

    • Zoho Payroll's USA and KSA editions are available in Zoho One!

      Greetings! We’re excited to share that Zoho Payroll, currently available only in India and the UAE, is now introducing the KSA (Kingdom of Saudi Arabia) edition and the USA (United States of America) edition, and these editions are now available in Zoho

    • Looking for Guidance on Building a Zoho Website

      I'm exploring the possibility of building a custom website with specific features using Zoho as an alternative platform. My goal is to create something similar to https://gtasandresapk.com , with the same kind of functionality and user experience. I'd

    • Multilingual website feature

      Would be a great feature to have. I saw that this feature was available for backstage. I think it could be done for zoho sites too.

    • [Webinar] Modernize your sales engine with agentic analytics

      Traditional sales decision-making methods aren't cut out for modern businesses. Leveraging AI in sales helps businesses actively respond to the changing dynamics of the market. Agentic AI is letting sales teams across industries make better decisions

    • Built-in Date Functions in Zoho Analytics Query Tables

      I have a doubt about whether Zoho Analytics Query Tables provide built-in functions for start date, end date, and the current month

    • Zoho Commerce in multiple languages

      When will you be able to offer Zoho Commerce in more languages? We sell in multiple markets and want to be able to offer a local version of our webshop. What does the roadmap look like?

    • Nimble enhancements to WhatsApp for Business integration in Zoho CRM: Enjoy context and clarity in business messaging

      Dear Customers, We hope you're well! WhatsApp for business is a renowned business messaging platform that takes your business closer to your customers; it gives your business the power of personalized outreach. Using the WhatsApp for Business integration

    • Connectivity issues with Google Calendar and third-party integrations

      Description: We are currently experiencing a critical failure with Zoho CRM third-party connections. This issue is heavily affecting our primary workflow. Symptoms: Sync Failure: Existing Zoho CRM to Google Calendar connections have been failing for approximately

    • Dynamic image in form works in the app but not on the customer portal.

      img = frm_Fichas[ID == input.Nombre].Foto; imgno = Nophoto[ID2 = 1].Image; if(len(img) > 1) { img = img.replaceAll("/sharedBy/appLinkName/",zoho.appuri); img = img.replaceAll("viewLinkName","Fichas_de_personal_public"); img = img.replaceAll("fieldName","Foto");

    • Incorrect Functioning of Time Logs API (Version 3)

      We need to fetch the list of time logs for each task for our company internal usage. We are trying to achieve it by using the next endpoint: https://projects.zoho.com/api-docs#bulk-time-logs#get-all-project-time-logs Firstly, in the documentation the

    • How can I export all Deluge code across the application?

      I’m working on a application with multiple forms, reports, and HTML views, where Deluge scripts are used across workflows, field actions, and custom functions. Is there a way to export all Deluge scripts into a single file for easier search?

    • First Name in Mail

      While sending a mail/message to the user, I want only the first name to be displayed—for example: “Hi John” instead of the full name using "Hi ${Name_Field}"

    • Next Page