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

        • Archiving Contacts

          How do I archive a list of contacts, or individual contacts?

        • Cant Save Gauge on Creator Page

          How to Save Gauge on Creator Page see movie https://vimeo.com/1116410860?share=copy#t=0

        • Update application by uploading an updated DS file

          Is it possible? I have been working with AI on my desktop improving my application, and I have to keep copy pasting stuff... Would it be possible to import the DS file on top of an existing application to update the app accordingly?

        • Granular Email Forwarding Controls in Zoho Mail (Admin Console and Zoho One)

          Hello Zoho Mail Team, How are you? At present, the Zoho Mail Admin Console allows administrators to configure email forwarding for an entire mailbox, forwarding all incoming emails to another address. This is helpful for delegation or backup purposes,

        • Change Currency symbol

          I would like to change the way our currency displays when printed on quotes, invoices and purchase orders. Currently, we have Australian Dollars AUD as our Home Currency. The only two symbol choices available for this currency are "AU $" or "AUD". I would

        • Auto Capitalize First Letter of Words

          Hi I am completely new to ZOHO and am trying to build a database. How can i make it when a address is entered into a form field like this: main st it automatically changes is to show: Main St Thank You

        • Follow-up emails via Workflow Automation not staying in the same thread

          Dear Zoho Support Team, I am currently using Workflow Automation in Zoho Campaigns to send follow-up emails. In my test case, I noticed the following behavior: All emails in the automation have the same subject line. If the follow-up email is sent within

        • Client Script refuses to set an initial value in Subform field

          I tried a very simple, 1 line client script to set a default value in a custom subform field when the "Add Row" button is clicked and the user is entering data. It does not work - can someone tell me why? ZDK documentation suggests this should be doable.

        • How do I filter contacts by account parameters?

          Need to filter a contact view according to account parameter, eg account type. Without this filter users are overwhelmed with irrelevant contacts. Workaround is to create a custom 'Contact Type' field but this unbearable duplicity as the information already

        • Send / Send & Close keyboard shortcuts

          Hello! My team is so close to using Zoho Desk with just the keyboard. Keyboard shortcuts really help us to be more efficient -- saving a second or two over thousands of tickets adds up quickly. It seems like the keyboard shortcuts in Desk are only for

        • Zoho Social - Post Footer Templates

          As a content creator I often want to include some information at the end of most posts. It would be great if there was an option to add pre-written footers, similar to the Hashtag Groups at the end of posts. For example, if there is an offer I'm running

        • Zoho Expense - The ability to add detail to a Trip during booking

          As an admin, I would like the ability to add more detail to the approved Trips. At present a requestor can add flights, accommodation details and suggest their preferences. It would be great if the exact details of the trip could be added either by the

        • Simplified Call Logging

          Our organization would like to start logging calls in our CRM; however, with 13 fields that can't be removed, our team is finding it extremely cumbersome. For our use case, we only need to record that a call happened theirfor would only need the following

        • Week date range in pivot table

          Hello, I need to create a report that breakouts the data by week.  I am using the pivot table report, and breaking out the date by week, however the date is displayed as 'Week 1 2014' format.  Is there anyway to get the actual dates in there? ex. 1/6/2014-1/12/2014 Thanks,

        • Help Center IFrame Issue

          I have had a working Help Center on my website using an iframe for a while. But now for some reason the sign in page gets a refused to connect error. Can someone please help. If I go to the url manually it works correclty

        • Staff rules

          Hi! Do you people know what are the default staff rules when a new booking is created? We have two staff members in my team (me as the admin, and my employee). As we share the same services, I'm wondering how Zoho will pick the staff for new apointments.

        • Comment Templates

          Is it possible to add a template option for comments? We have some agents in the process who's responses require a pre-formatted layout. It would be incredibly handy to have a template for them where they can insert the template and then add their responses

        • [ZohoDesk] Improve Status View with a new editeble kanban view

          A kanban view with more information about the ticket and the contact who created the ticket would be valueble. I would like to edit the fields with the ones i like to see at one glance. Like in CRM where you can edit the canvas view, i would like to edit

        • Adding Markdown text using Zoho Desk API into the Knowledge Base

          Hi Zoho Community members, We currently maintain the documentation of out company in its website. This documentation is written in markdown text format and we would like to add it in Zoho Knowledge Base. Do you know if there is REST API functionality

        • An Exclusive Session for Zoho Desk Users: AI in Zoho Desk

          A Zoho Community Learning Initiative Hello everyone! This is an announcement for Zoho Desk users and anyone exploring Zoho Desk. With every nook and corner buzzing, "AI's here, AI's there," it's the right time for us to take a closer look at how the AI

        • Shared values: From classroom lessons to teaching moments in customer service

          While the world observes Teachers’ Day on October 5, in India, we celebrate a month earlier, on September 5, to mark the birth anniversary of Dr. Sarvepalli Radhakrishnan, a great teacher, renowned scholar, educationist, and advocate for empowerment.

        • Export to excel stored amounts as text instead of numbers or accounting

          Good Afternoon, We have a quarterly billing report that we generate from our Requests. It exports to excel. However if we need to add a formula (something as simple as a sum of the column), it doesn't read the dollar amounts because the export stores

        • Image Upload Field | Zoho Canvas

          I'm working on making a custom view for one of our team's modules. It's an image upload field (Placement Photo) that would allow our sales reps to upload a picture of the house their working on. However, I don't see that field as a opinion when building

        • Create a list of customers who participated in specific Zoho Backstage events and send them an email via Zoho CRM

          How to create a list of customers who participated in specific Zoho Backstage events and send them an email via Zoho CRM? I was able to do a view in CRM based on customer that registered to an event, but I don't seems to be able to include the filter

        • Custom Button Disappearing in mobile view | Zoho CRM Canvas

          I'm working in Zoho CRM Canvas to create a custom view for our sales team. One of the features I'm adding is a custom button that opens the leads address in another tab. I've had no issue with this in the desktop view, but in the mobile view the button

        • Zoho Desk blank page

          1. Click Access zoho desk on https://www.zoho.com/desk/ 2. It redirects to https://desk.zoho.com/agent?action=CreatePortal and the page is blank. Edge browser Version 131.0.2903.112 (Official build) (arm64) on MacOS

        • Clearing Fields using MACROS?

          How would I go about clearing a follow-up field date from my deals? Currently I cannot set the new value as an empty box.

        • I hate the new user UI with the bar on the left

          How can I reverse this?

        • Constant color of a legend value

          It would be nice if we can set a constant color/pattern to a value when creating a chart. We would often use the same value in different graph options and I always have to copy the color that we've set to a certain value from a previous graph to make

        • Office 365 and CRM mail integration: permission required

          Has anyone run into this weird problem? My email server is Office 365. When I try to configure Zoho CRM to use this server, a Microsoft popup window opens requesting user and password. After entering that, I get a message in the Microsoft window saying

        • Field Not Updating in FSM Script - Service and Parts module.

          Dear Team, I am reaching out regarding a script I have implemented in Zoho FSM to automate the calculation of the End of Service date based on the End of Sale date in the Service and Parts module. Overview of the script: Fetches the End_of_Sale__C and

        • Question regarding import of previous deals...

          Good afternoon, I'm working on importing some older deal records from an external sheet into the CRM; however, when I manually click "Add New Deal" and enter the pertinent information, the deal isn't appearing when I look at the "Deals" bar on the account's

        • Client Script also planned for Zoho Desk?

          Hello there, I modified something in Zoho CRM the other day and was amazed at the possibilities offered by the "Client Script" feature in conjunction with the ZDK. You can lock any fields on the screen, edit them, you can react to various events (field

        • One person/cell phone to manage multiple accounts

          Hi. I have a personal Free account to keep my own domain/emails. Now I need to create a Business account to my company's own domain, but I have only one mobile phone number I use to everything. How do I do to manage this? Can I manage a Free domain and

        • Tracking KPIs, Goals etc in People

          How are Zoho People users tracking employee targets in People? For example, my marketing assistant has a target of "Collect 10 new customer testimonials every month". I want to record attainment for this target on a monthly basis, then add it to their

        • Zoho Desk: Ticket Owner Agents vs Teams

          Hi Zoho, We would like to explore the possibility of hiding the ‘Agents’ section within the Ticket Owner dropdown, so that we can fully utilise the ‘Teams’ dropdown when assigning tickets. This request comes from the fact that only certain agents and

        • CRM limit reached: only 2 subforms can be created

          we recently stumbled upon a limit of 2 subforms per module. while we found a workaround on this occasion, only 2 subforms can be quite limiting in an enterprise setting. @Ishwarya SG I've read about imminent increase of other components (e.

        • Can not Use Attachment Button on Android Widget

          this always pops up when I touch the attach button on android widget. going to settings, there is no storage permission to be enabled. if I open the app, and access the attach feature there, I can access my storage and upload normally.

        • Can I add Conditional merge tags on my Templates?

          Hi I was wondering if I can use Conditional Mail Merge tags inside my Email templates/Quotes etc within the CRM? In spanish and in our business we use gender and academic degree salutations , ie: Dr., Dra., Sr., Srta., so the beginning of an email / letter

        • Zoho Notebook Sync problem

          I'm facing a problem with syncing of notebook on android app. It's not syncing. Sometimes it syncs after a day or two.  I created some notes on web notebook but it's not syncing on mobile app. Please help!!!!

        • Next Page