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

      • How to Structure Data in Zoho Creator Applications

        Data structure is undoubtedly one of the most critical pillars in application development within Zoho Creator. Well-structured projects scale easily, enable more robust automations, and drastically reduce rework. Poorly modeled applications, on the other

      • Is it possible to retrieve function (Deluge) code from Zoho CRM externally?

        Hi Everyone, Is it possible to fetch or retrieve the Deluge function code from Zoho CRM using an external method (API or any other approach)? I would like to know if there is any way to access or extract the function script outside of Zoho CRM, or if

      • Zoho CRM Integration Form + Custom Fields

        Hi! I've created an Integration Form from Zoho CRM's Vendors Module, but I can choose a few standard fields and no custom fields I've created in Zoho CRM. There is a plan to add this feature soon? Thanks in advance.

      • Como estruturar dados em aplicações Zoho Creator

        A estrutura de dados é um dos pilares mais críticos no desenvolvimento de aplicações no Zoho Creator. Projetos bem estruturados escalam com facilidade, permitem automações mais robustas e reduzem drasticamente retrabalho. Já aplicações mal modeladas rapidamente

      • Creditos API

        Queria saber se alguém poderia me ajudar a resolver um problema na compra e utilização de créditos de mensagens API do WhatsApp. ja tentei todos o tutoriais porem não consegui realizar a compre, pois ao clicar no botão de comprar créditos aparece a mensagem

      • Using Zoho Forms vs Zoho Survey

        Hello - I'm looking for advice on whether to use Zoho Survey or Zoho Forms for our small non-profit. We have a Zoho One subscription, so have access to both. The main use case at the moment is application forms for our professional development programs.

      • Custom CSS for Zoho CRM Team Bookings embeded widget

        Hello, we are adding Zoho CRM Team Bookings (crm.zoho.com) in our public website. We know that we can change Theme Color, Font Color and Background Color: Zoho CRM Booking Styling But is it possible to change other CSS attributes e.g. Font Family, like

      • Dashboard target enhancements

        Often individuals in IT are creating dashboards for their sales team. The ability to create a single dashboard that can be used by multiple people is key. A components for a dashboard have the ability to filter by logged in user which is great. However

      • Improved RingCentral Integration

        We’d like to request an enhancement to the current RingCentral integration with Zoho. RingCentral now automatically generates call transcripts and AI-based call summaries (AI Notes) for each call, which are extremely helpful for support and sales teams.

      • How to add "All Open AND Overdue" back to the Home Page Task Component?

        Hi everyone, I’m looking for a way to restore the Tasks component dropdown list on the Zoho CRM Home Page. Since the recent update to the Task area in my Home Page Classic View, the dropdown options (e.g., My Next 7 Days + Overdue) are too restrictive

      • Enable integration of CRM CPQ functionality for ZohoOne customers using Zoho Finance application

        Hi there. I can't believe I'm needing to launch this idea as I would have thought this was a little obvious. Following a number of conversations with the technical team it's become evident that the CPQ functionality within CRM cannot integrate with Zoho

      • Client Script event on any field of a Detail page

        Hi everyone! I'd like to trigger a Client Script when a user modifies a field - any field - from the Account Details page, how can I do this? I don't want to trigger it on a specific field, but on all of them. Thanks in advance!

      • Is there a way to update all the start and end dates of tasks of a project after a calendar change?

        Hi! Here's my situation. I've built a complete project planning. All its tasks have start dates and due dates. After completing the planning, I've realized that the project calendar was not the right one. So I changed the project calendar. I now have

      • Client Script: Any plans to add support for multi-select field with onChange

        Client Script is fantastic and the documentation lists multiselect form fields as unsupported. Just wondering if there are any plans to make this a supported field. https://www.zoho.com/crm/developer/docs/client-script/client-script-events.html 2. Field

      • Set Field Mandatory by Client Script ZOHO CRM

        #Tips of the day We can set the field as mandatory by the client script var field_obj = ZDK.Page.getField('Custom_Field1'); field_obj.setMandatory(true); Custom_Field1 = Field API Name Apart from is if you have required any kind of Zoho work please do

      • Setting GC session variable programatically in a website

        Hi! Is there a way now to programatically set session variables from a website for a Guided Conversations? The current available methods are dependent on react-native.

      • 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 Certified Workshops in Berlin | 20. - 21. April

        Liebe Mitglieder der deutschen Zoho-Community! Wir freuen uns, Ihnen mitteilen zu können, dass unsere Zoho Certified Workshops am 20. und 21. April nach Deutschland zurückkehren! 📍Wo finden die Workshops statt? Die zertifizierten Workshops finden im

      • Zoho Payroll Expansion Plans

        Dear Zoho Team, I truly appreciate the continuous innovation and improvements you bring to your suite of products. However, I—and I’m sure many others—would love some clarity on your Zoho Payroll expansion roadmap. Currently, it’s only available in the

      • CRM x WorkDrive: File storage for new CRM signups is now powered by WorkDrive

        Availability Editions: All DCs: All Release plan: Released for new signups in all DCs. It will be enabled for existing users in a phased manner in the upcoming months. Help documentation: Documents in Zoho CRM Manage folders in Documents tab Manage files

      • Bulk upload images and specifications to products

        Hi, Many users have asked this over the years and I am also asking the same. Is there any way in which we can bulk upload product (variant) images and product specifications. The current way to upload/select image for every variant is too cumbersome.

      • sync two zoho crm

        Hello everyone. Is it possible to sync 2 zoho crm? what would be the easiest way? I am thinking of Flow. I have a Custom Module that I would like to share with my client. We both use zoho crm. Regards.

      • Is there a way to show contact emails in the Account?

        I know I can see the emails I have sent and received on a Contact detail view, but I want to be able to see all the emails that have been sent and received between all an Accounts Contacts on the Account Detail view. That way when I see the Account detail

      • Export Invoices to XML file

        Namaste! ZOHO suite of Apps is awesome and we as Partner, would like to use and implement the app´s from the Financial suite like ZOHO Invoice, but, in Portugal, we can only use certified Invoice Software and for this reason, we need to develop/customize on top of ZOHO Invoice to create an XML file with specific information and after this, go to the government and certified the software. As soon as we have for example, ZOHO CRM integrated with ZOHO Invoice up and running, our business opportunities

      • Usar o Inventory ou módulo customizado no CRM para Gestão de Estoque ?

        Minha maior dor hoje em usar o zoho é a gestão do meu estoque. Sou uma empresa de varejo e essa gestão é fundamental pra mim. Obviamente preciso que esse estoque seja visível no CRM, Inicialmente fiz através de módulos personalizados no próprio Zoho CRM,

      • How do I setup the performance review module?

        I am pretty adept when it comes to learning software and I've set up quite a few Zoho Apps over the past 3 years.   But for the life of me, I can not figure out Zoho People performance reviews. I've figured out the "Organization" & LMS Modules, but the

      • CRM x WorkDrive: We're rolling out the WorkDrive-powered file storage experience for existing users

        Release plan: Gradual rollout to customers without file storage add-ons, in this order: 1. Standalone CRM 2. CRM Plus and Zoho One DCs: All | Editions: All Available now for: - Standalone CRM accounts in Free and Standard editions without file storage

      • Recurring Addons

        Hi, I know you can set the pricing interval for addons to weekly, monthly and yearly & set it for one off or recurring, which these are fine as a base addon item. It really would be helpful if when creating a subscription when you add on the addon item

      • Cancellation Fees

        Hi, It really would be good if Billing could take subscription management further with cancellations & being able to apply or set a cancellation fee for a plan that is either fixed or prorated. It is not uncommon in subscriptions for cancellation fees

      • All new Address Field in Zoho CRM: maintain structured and accurate address inputs

        Availability Update: 29 September 2025: It's currently available for all new sign-ups and for existing Zoho CRM orgs which are in the Professional edition exclusively for IN DC users. 2 March 2026: Available to users in all DCs except US and EU DC. 24

      • Zoho Writer Frequently not loading

        I've reported this as a problem already but I can't log into my email right now or get onto the main site so you're going to hear about it again here: at least once a week, Zoho Writer will just refuse to load entirely. The main page will load and load

      • Bulk Associate Tasks/Task Lists to Milestones (Similar to Issues)

        Hello Zoho Projects Team, We hope you are doing well. We would like to request an enhancement regarding Milestone management for Tasks in Zoho Projects. Current Behavior: In the Issues module, it is possible to select multiple issues and easily associate

      • Unable to produce monthly P&L reports for previous years

        My company just migrated to Books this year. We have 5+ years financial data and need to generate a monthly P&L for 2019 and a monthly P&L YTD for 2020. The latter is easy, but I'm VERY surprised to learn that default reports in Zoho Books cannot create

      • Allow agents to enable or disable notifications from certain departments

        Agents who are part of multiple departments receive notifications frequently from across the departments. They may not be actively involved in performing every action in all departments. For example, an agent could be a part of both the sales and support

      • WorkDrive API returning empty response even after placing file in Team Folder

        Hi everyone, I am trying to fetch a file from Zoho WorkDrive using a Deluge standalone function in Zoho People. The API call executes successfully using a configured connection, but the response is coming back empty. I have verified the following: The

      • Address Typeahead Extension for Zoho Books

        I installed the Address Typeahead extension for zoho books but when I went to configure it, it said that that version was deprecated. Is there a newer version somewhere?

      • Transaction Rules & Customer Payments

        So I have a situation as follows. We have many clients who are all invoiced on the 1st of each month on a recurring invoice for 1 of 10 plans. This means that almost all payment dates are the same (some people pay late) and that a lot of the amounts are

      • Can I Integrate ADP Payroll with Zoho Books?

        Hi, I am hoping that I can integrate ADP Payroll with Zoho Books so that I do not need to manually input the payroll journal entries. Is this possible? If so, how do I do that?

      • Zoho Books | Product updates | February 2026

        Hello users, We’ve rolled out new features and enhancements in Zoho Books. From Advanced Reporting Tags to the ability to mark projects as completed, explore the latest updates designed to improve your bookkeeping experience. Introducing Advanced Reporting

      • Darshan Hiranandani : How many participants can join a Zoho Meeting at once?

        Hi everyone, I'm Darshan Hiranandani, trying to find out the maximum number of participants that can join a Zoho Meeting at once. Has anyone here used Zoho Meeting for larger groups and can share their experience or knowledge about the participant limit?

      • Next Page