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
Separate Default Payment Modes for Receipts vs. Payments
Right now, when I set a default Payment Mode via a customer invoice or Payments Received screen, that same mode shows up for vendor payments (Purchases → Payments Made). 🔹 Request: We need different default modes for: Customer receipts (e.g., defaultUpdate/Change GSTIN in GST Settings of zohobooks
We are trying to update our GSTIN under the GST settings section of our Zohobooks account Initially, we had entered a dummy GSTIN (123456789123456) to generate a sample invoice before obtaining our official GST registration. After receiving our actualLink Payment Mode and Paid Through Accounts
For most users, it's very difficult for them to understand that the Payment Mode is totally independent of the Paid Through account when paying bills. It seems (and is) redundant for them to have to select what is basically the same thing twice. The currentLets enable business to choose the default payment mode
Lets enable business to choose the default payment mode so that we do not have choose payment mode again and again for each and every transsctionsAdd Attachment Support to Zoho Flow Mailhook / Email Trigger Module
Dear Zoho Support Team, We hope you are well. We would like to kindly request a feature enhancement for the Mailhook module in Zoho Flow. Currently, the email trigger in Zoho Flow provides access to the message body, subject, from address, and to address,South African Payment Gateways
Since the "Demise" of Wave many South African users have moved over to Zoho and yet for years users have been requesting Integration with a South African Payment Gateway to no avail. Payfast was the most commonly requested gateway as it supports recurringHas anyone verified if Zoho is PCI compliant?
We are planning on using Zoho to process payments via Authorize.net. We have everything set up and are attempting to complete the PCI DSS SAQ-A requirement for our merchant account. This requires us to prove Zoho has completed the SAQ-D for Service Providers. We need a way to verify compliance, or a copy of an attestation of compliance signed by the appropriate officer at Zoho. I assume I'm not the first person to use Zoho to process payment, and therefore not the first to require this informationSupport for Custom Fonts in Zoho Recruit Career Site and Candidate Portal
Dear Zoho Recruit Team, I hope you're doing well. We would like to request the ability to use custom fonts in the Zoho Recruit Career Site and Candidate Portal. Currently only the default fonts (Roboto, Lato, and Montserrat) are available. While theseBigin Plugin for Outlook
Could we get this added? The Gmail version already exists, and I would like to avoid having to make a switch.Date does not fit the field
Hi There. I am having fun learning zoho sign API. Today I noticed the "Signed Date" field does not fit, or alternatively the font is to large for the auto field space. See screenshot below. The signed date field is created by putting {{Signdate}} on theTip of the Week #69 – Automate your Zoho TeamInbox tasks with n8n integration.
Don’t waste time repeating the same tasks—like sending follow-up emails or adding new contacts. Let automation save the day. With n8n, an open-source automation tool, you can connect your favorite apps and let them handle the busywork for you. You don’tMulti Page/Step Forms in creator
Greetings i was wondering if it's possible to create multipage/step forms on creator similar to what we have on zoho forms. is that possbile? ThanksPackage Geometry
how can i add the dimensions and weight capacity of the available boxes to be default in the system everytime we use it ?How to create a Master Kanban Board that syncs with Child Projects?
Hello, We're currently using Zoho Sprints for managing our interdepartmental teams, and we're looking to enhance our workflow using Kanban boards as part of a company-wide productivity improvement initiative. Our goal is to implement a project structureWriter.. Broken?
Hello, Writer has been really good to me during the months I've used it, up until now. I usually launch the app by tapping the icon and I could immediately pick up where I left off. Now I'm greeted by a loading circle not reaching 100% and I only have the option to create a new account. By pressing that button it now switches to a login screen and I can access my account. However, it seems (only speculating ofc) to be stuck in cell-phone mode? everything looks scrambled. I can't access any ofHow to access Recruit Variables in a Deluge function?
I have set up Recruit Variables in Zoho Recruit, and I would like to know how to retrieve these variables from within a Recruit custom function (Deluge). Could someone please explain the correct way to access them? I tried the following code, but it didUpon De activate a user what name doe sthe contacts candidates go under?
When deactivating a user, does the user name remain the same, as the candidate owner? If not what/who, does it change to? Do I need to change the user name in contacts and candidates before I deactivate the user?Weekly Tips: Customize alerts from your Priority Users
You might receive hundreds of emails daily, but messages from your manager, clients, or team leads often require immediate attention, as they may contain urgent requests or critical updates. How would you ensure you never miss important messages fromMaximum 100 records in Sheet View is limiting. How can I increase this?
Thanks in advance for any help with this. There was a similar post that showed answered but it did not help with increasing the number of records you see in a Sheet View. Editing in the Sheet View is fast and efficient but I have 3500 records and I needRevenue Management: #3 Revenue Recognition Simplified
In continuation of the previous post on how to compute revenue recognition, let's explore a solution that helps businesses handle real-world complexities. While the Accounting Standards provide a clear framework for recognizing revenue, the real challengeTip #40- Strengthen Remote Support with IP-based Restrictions in Zoho Assist– ‘Insider Insights’
Protecting sensitive data and preventing unauthorized access is a top priority for any organization. With IP-based restrictions in Zoho Assist, you can ensure that only users from trusted networks can initiate remote support sessions. Say your IT teamPush Invoices to Xero Manually
Hi guys, I'm wondering if anyone has wanted to do this and has a workaround or knows of an app that may be able to help with this. I sell B2B and B2C. The customers can purchase on our website or through marketplace, all of which send sales to zoho. TheOpenAI error code: 1010 in a Zobot
Please see short linked screen recording. Insights welcome. Please and thank you! https://workdrive.zohoexternal.com/external/f3247ba9c872639157b707700c0300c433c7664aea924a034f4da3c3ad2e355fAbility to Create Sub-Modules in Zoho CRM
We believe there needs to be a better, more native way to manage related records in Zoho CRM without creating clutter. Ideally, Zoho would support "sub-modules" that we can create and associate under a parent module. Our use case: We have a custom moduleInstalling EMAIL Setup in New Domain
Respected Support team, I'm facing an issue with cloudflare in Pakistan, I want to setup Zoho Mail Setup but I Don't know how to enable Zoho mail setup without cloudflare. My Website https://stumbleguymod.com/ is using CF, and I want a different ZohoSignature change
I cannot see how to change signature or out of office details easily now in the new format.Inventory API - Retrieve all uploaded product / item images
I know that I can get the primary image for each product / item or composite item, by using the /image endpoint. https://inventory.zoho.com/api/v1/compositeitems/<item-id>/image?authtoken=<TOKEN> This will return only one photo, even if the item has multiple images uploaded. Is there a way to retrieve all images stored for an item via the Zoho Inventory API?Ebay Integration malfunction
My eBay integration in Inventory has always worked well. It suddenly malfunctioned. It is creating its own parts in Inventory that are unavailable instead of selling the parts I've always sold. Tech help was unable to resolve this. The latest sale attemptIntroducing Bin Locations In Zoho Inventory
Hello users, We are excited to let you know that your wait for the Bin Locations feature has now come to an end! Yes, you heard us right! We are here to introduce the much-awaited Bin Locations now in Zoho Inventory. But before we dive into the featurehow to get all the records in the custom View more than 200 records , Without using the page Concept
how to get all the records in the custom View more than 200 records , Without giveing page as default in the Loop Concept Pls help how We can Achive this void schedule.Lead_Attempt_To_contact_schedule_10_30() { pages = {1,2}; for each pg in pages { query_mapThe way that Users can view the ticket
I have created users. What I would like to achieve is the following: All users under the same company account should be able to view each other’s tickets.Zoho UAE SMS/WHATSAPP
Hello everyone, so I have a question as regards DC and their impact on automation, integration and app usage. For example I am working with a UAE clientniw but each time I tried to connect their WhatsApp and sms then automate their process I tend to receiveLooking to Flag or Tag contacts/ accounts on Zoho Desk?
I am looking for a way to flag certain accounts and make it obvious on the views pages. So for example if a has a certain package or needs extra attention it is clear before even clicking on the ticket. This could be via adding a tag or flag onto an account,setting date-time field from string
hello everyone, i hope someone could help me. i have a date-time field in a form that i want to fill in from two separate fields of date, and time. i need to combine the two fields to a one date-time field but can make it work. i tried to convert theCalendars and CRM Contacts
I'm finding having multiple calendars in Zoho One so confusing. I have a few questions so I can get this straight. We have a meeting room that we have set up as a resource in Calendar. Can this be set up in Bookings and the CRM Calendar? Using Zoho Calendar,Announcing new features in Trident for Mac (v1.23.0)
Hello everyone! Trident for macOS (v.1.23.0) is here with interesting features and thoughtful enhancements to elevate your workplace communication and productivity. Here's a quick look at what's new. Record your meetings. You can now record audio andApplying a record template
Hi all, I can't figure this out. I hope you can help. The scenario: We have learners who have to complete a 'digital' journal with tasks in order to qualify. Those tasks, once completed, need a final signature from their 'Mentor', which will trigger theirQuickbooks invoice with Zoho Creator
Is it possible to push data from Zoho Creator directly to an invoice on QuickBooks? If so, where can I find information on how to do this?Help: Capture full page URL in hidden field when same Zoho Form is embedded on multiple pages (iframe)
Hi all, Goal Use one Zoho Form across multiple pages and record the exact page URL (incl. subdomain + path + hash) where the user submitted it. Example pages: https://www.example.com/cargo/ https://www.example.com/cargo/containers/#contact https://cargo.example.com/auto/Automatically Populate fields - HELP!
There have been many discussions on this but I still can't seem to get it to work for me. I am trying to create a lookup field and have other fields automatically populate. Based on the instructions in the Help Center, I should be using the "on user input". It's just not working, here is the layout... Both forms are in the same application. Current form is called Add Note, form to fetch records from is called Add Client. Lookup field is called Select_Client_ID related field in fetch form is calledNext Page