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.
Lookup fields help display related information, filter data based on related fields, and manage complex relationships between different modules.
In 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.
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
Also read:
Access your files securely from anywhere
New to Zoho Recruit?
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
Kavya Rao Addepalli
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
Nederlandse Hulpbronnen
ご検討中の方
Recent Topics
Problem of Import Client Users From CRM and or Expense
I am premium plan user on Projects. I have about 500 customers on Expense and CRM that integrated with each other. According to at below link, I am trying to import clients from CRM, system not allowed to select any customer. If I import from Expense,Unable to see free plan option
Hello Zoho Support Team, I hope you are doing well. I am trying to sign up for Zoho Mail, but I am unable to see the option for the free plan. Could you please guide me on how I can access or activate the free plan? Thank you for your assistance.unblock my zoho mail account. outlines@zoho.com
please unblock my zoho mail account, outlines@zoho.comdomain not verified error
Hi when i try to upload a video from zoho creator widget to zoho work drive iam getting domain not verified error.I don't know what to do .In zoho api console this is my home page url https://creatorapp.zoho.com/ and this is my redirect url:www.google.com.Iamequest to Disassociate Bigin from Zoho One and Migrate to Standalone (Upgrade to Bigin Premier – 3 Seats, Annual)
Dear Zoho One Support Team, I’m writing to request your assistance to disassociate (remove) the Bigin application from our Zoho One organization while preserving all existing Bigin data. After the disconnection is successfully completed, we intend toSMTP email sending problem
Hello, I've sent emails before, but you haven't responded. Please respond. My work is being disrupted. I can't send emails via SMTP. Initially, there were no problems, but now I'm constantly receiving 550 bounce errors. I can't use the service I paidbilling
hi, I am being billed $12/year, and I can't remember why. My User ID is 691273115 Thanks for your help, --Kitty PearlHow to add receipts
How to add receiptsUnable to enable tax checkboxes
Hi Zoho Commerce Support, I'm writing to report an issue I'm having with the tax settings in my Zoho Commerce store. I've created several tax rates under Settings > Taxes, but all of them appear with the checkbox disabled. When I try to enable a checkbox,Does Zoho Learn integrate with Zoho Connect,People,Workdrive,Project,Desk?
Can we propose Zoho LEarn as a centralised Knowledge Portal tool that can get synched with the other Zoho products and serve as a central Knowledge repository?Zoho Commerce - Enable Company Name and Tax Number collection for B2B orders in Global Edition
Please enable Company Name and Tax Details option on checkout settings in Zoho Commerce Global Edition. It is still important to collect Company Name and Tax Number for B2B sales in many countries. My business is based in Ireland (in the EU) and I haveZohoSign and ZohoBooks Integration/Workflow
Hello All, We utilize ZohoSign for signatures on tax eFiles. We utilize Dynamic KBA. Additionally, we use ZohoBooks for invoicing for these services. Is there a way to accomplish the following: Send a copy of the Tax Return, Invoice and eFiles in oneManage monthly tasks with projectsf
Hi All I run a finance and operations team where we need both teams to complete monthly tasks to ensure we hit our deadlines. Can Zoho projects be used for this. There many finance focused tools but we have Zoho one so want to explore Thanks WillZoho Suite is very slow
Since today Zoho is incredibly slow over all applications! What's going on?How can I track which zoho users are actively using Zoho CRM
I have several licenses of Zoho CRM. We now need to add a new user. I could purchase a new license, but before I do, I would like to see if any of our existing users are not actively using the license assigned to them. How can I determine the activityIs anyone else having trouble saving a custom image in their email signature, or is it just me?
When I try to save the image I get an error that says "Operation Failed" I opened a support ticket two weeks ago and received a response that it would be debugged, but it still isn’t workingCombine and hide invoice lines
In quickbooks we are able to create a invoice line that combines and hides invoices lines below. eg. Brochure design $1000 (total of lines below, the client can see this line) Graphic Design $600 (hidden but entered to reporting andOption to Disable Knowledge Base Section in Feedback Widget Popup Hello Zoho Desk Team
Hello Zoho Desk Team, How are you? We are actively using Zoho Desk and would like to make more use of the Feedback Widget. One of the ways we implement it is through the popup option. At the moment, the popup always displays the Knowledge Base section,The Social Wall: August 2025
Hello everyone, As summer ends, Zoho Social is gearing up for some exciting, bigger updates lined up for the months ahead. While those are in the works, we rolled out a few handy feature updates in August to keep your social media management running smoothly.Transaction Locking with the dynamic date
Is it possible to dynamically update dates on transaction locking. We want to lock transaction x days from todayZoho Devops
We have a Zoho one account which we have integrated with an SAS educational product, sold on a subscription model, using webhooks and API calls. We make some use of custom fields and cross module lookups and relationships. We utilize CRM, Books and billingFuel up your sales with the Zoho SalesIQ + Bigin integration
Hi everyone! We’re happy to bring you the all-new Zoho SalesIQ + Bigin integration. With this, every prospect from your website instantly becomes a contact in Bigin, complete with transcripts and follow-up tasks, so you never lose a lead again. Let'sIntroducing AI-powered Assessments & Zoho's native LLM, Zia
We’ve shipped a cleaner, faster way to create assessments in Zoho Recruit. 🚀 Instead of manually building question banks or copying old templates, you can now generate ready-to-use assessments in just a few clicks, all tailored to the role you’re hiringAbility to Reset Visitor Fields During an Active Chat Flow
Hello Zoho SalesIQ Team, We hope you are doing well. We would like to propose a feature enhancement to Zoho SalesIQ regarding the management of visitor fields within Zobot flows. Use Case: Our bot asks the visitor to provide information about a 3rd personExternal ID in Zoho CRM
Hello everyone! We know that Zoho CRM allows you to integrate third-party apps and manipulate data through APIs. While you integrate a third-party application, you may want to store the third-party reference IDs in Zoho CRM's records. To meet this needSome emails are not being delivered
I have this problem where some of my mail just seems to disappear. When I send it, it appears as sent with no mention of any problem, but my recipient never gets it, not even in the Spam folder. Same for receiving, I have a secondary e-mail address, andNew in Zoho Chat : Search for contacts, files, links & conversations with the all new powerful 'Smart Search' bar.
With the newly revamped 'Smart Search' bar in Zoho Chat, we have made your search for contacts, chats, files and links super quick and easy using Search Quantifiers. Search for a contact or specific conversations using quantifiers, such as, from: @user_name - to find chats or channel conversations received from a specific user. to: @user_name - to find chats or channel conversations sent to a specific user. in: #channel_name - to find a particular instance in a channel. in: #chat_name - to findTemplate modifiactions
Hello, I am struggling with the templates in ZOHO Books. Especially with the placement of some items, like company address, ship to, bill to etc. For example: One item I like from template X (placement of ship to and bill to next to each other in theAggregating the First Value in the Group By of a dataset
Hi I am trying to get the following Aggregate Formula to work in my chart, but cannot seem to get the right format. I have a series of data that I am running an include_groupby and want to SUM only a column in the first row of each group. So for example.Admin Control Over Profile Picture Visibility in Zoho One
Hello Zoho Team, We hope you are doing well. Currently, as per Zoho’s design, each user can manage the visibility of their profile picture from their own Zoho Accounts page: accounts.zoho.com → Personal Information → Profile Picture → Profile PictureTrack Zoho Campaign and Workflow sales impact
I am attempting to measure the performance of our marketing workflows and campaigns by comparing the date each campaign was sent to a contact with the purchase date of the contact. For example, if Contact A was sent Email A on 9/1 and made a purchaseTables for Europe Datacenter customers?
It's been over a year now for the launch of Zoho Tables - and still not available für EU DC customers. When will it be available?What is a line break code for zoho?
Hi, I am archiving data by adding values from a single line field from one form to a multi-line field in another form. So I need a code/function that starts a new line on that multi-line field so it does not just keep adding it on the same line. Example, doing something like this means that it will be on a same line. archive.field1 = archive.field1 + input.Field1 I need a code so the input.Field1 can just start on the next line. Instead of "value 1, 2,3,4,5" It will be: "1 2 3 4 etc.". somethingAutomatic Project Owner change
Is there a way to change Project Owner automatically once a specific Milestone in a project is marked as completed. Different Teams are working on projects in our Org, they have their own Milestones to complete and so we transfer the project from teamButton to add product to cart
Is there a way to have a button on a page, that when clicked, will add Qty 1 of a product to the cart?Problem with Submit Button Design
I have made a template to apply to my forms and under the button controls, I have it set to "standard" and yet it's still filling the container. This is super frustrating and looks weird. Why do we not have full control over button size? How can I fixZoho CRM- Authorize your Microsoft Teams account issue
Hi, I tried to link Zoho CRM with Teams and I got the following message: Clicking "Authorize now" sent me to the following page, Microsoft tried to start a session but, after 3 seconds the page closed and nothing happened. I get the same message eachPassing the CRM
Hi, I am hoping someone can help. I have a zoho form that has a CRM lookup field. I was hoping to send this to my publicly to clients via a text message and the form then attaches the signed form back to the custom module. This work absolutely fine whenIs there a way to associate an email in ZOHO Main to a Vendor record in ZOHO CRM
My situation is as below, I have a vendor in ZOHO CRM lets say "Vend A" and an associated contact, "Cont A" If Cont A sends me an email using the email I've registered in the contact record the standard OOTB email sync will work. But the vendor has someBank charges are applied. Please select a bank account.
Hello, I'm trying to add bank charges to a customer payment, but I get the error message "Bank charges are applied. Please select a bank account." I found this old thread, where it says that I need to "select a Bank account for the 'Deposit To' dropdownNext Page