The ability to establish connections between different sets of data is crucial in any business. For example, in the hospitality industry, departments like sales, marketing, and bookings can derive essential insights from customer data if it is linked to details like type of service, location, and date and time of booking. Linked data provides a 360-degree view of the customer, and helps employees make informed decisions and align their marketing activities more effectively.
Support agents can provide better service when customer details are displayed within a ticket. This way, they have convenient access to the contextual information they need to resolve a ticket quickly.
In Zoho Desk, a customer's email address, contact number, date of purchase, and other essential details are stored in fields. While most fields stand alone, Lookup Fields correlate data across modules. A Lookup Field can establish a one-to-many relationship between standard and custom modules, such as Contacts, Accounts, Assets, Raw Materials, Tickets and so on. For example, a field called, Industry Type, present in the Accounts module can be viewed inside the Tickets module. In addition to standard Lookup Fields, Zoho Desk empowers Admins to create custom Lookup Fields to address their business needs.
Availability
Permission Required
Users with Support Administrative profile permission can create custom Lookup Fields.
- Professional edition: 3 custom Lookup Fields/module and layout.
- Enterprise edition: 5 custom Lookup Fields/module and layout.
By default, standard Lookup Fields, such as Contact Name and Account Name, are available in Zoho Desk. In addition to these, Custom Lookup Fields can be added to a layout to suit different business needs. Custom Lookups can only be created in the Contacts, Accounts, and Tickets modules.
Some benefits of creating a custom Lookup Field:
- Streamlined data selection: By setting up filters based on specific criteria, users can limit the results displayed when searching within a Lookup Field, making it easier to find and associate the correct records.
- Efficient creation of related records: Create records in a related module directly from the layout. Users can seamlessly create and associate relevant information without navigating away or switching screens.
- Automated related value prefilling: Automatically prefill other fields with values from the related module. This automation saves time and simplifies data entry by populating relevant information for users.
Here's how you can create a custom Lookup Field:
Let's say you're creating a relationship between the Tickets and Contacts module. A lookup field called "Supervisor" is added to the Tickets module. While creating custom lookup fields, basic and advanced configurations can be set to allow users to search the desired records quickly. Mentioned below are the details on the same:
Basic Configurations
Entering the custom lookup name
Provide the name of the custom lookup field that you want to create.
Choose a module that will be related to your custom lookup field. You can choose either Accounts, Contacts, or Tickets. Based on the above example, the related module is the Contacts module.
A subtab of the parent module can be added to show the related records in the child module. For example, if you are creating a custom lookup field in the Tickets module and you select Contacts as the related module, you can create a subtab named Associated Tickets in the Contacts module, which will display all the tickets associated with the contact. So, if you are viewing a record for the contact, "John," within the Tickets module, all tickets associated with John can be viewed inside the Contacts module as well.
From the subtab, Agents or Admins can easily associate or disassociate tickets and even create new tickets. Note that when a record is associated from the subtab, the value in the custom lookup field will be auto-populated. It cannot be dissociated if the lookup field is marked as Mandatory
Additional options allow Admins to set a custom lookup field as Mandatory, and display a tooltip to provide hints or instructions to users while they're entering a field value.
Advanced Settings
Filtering the records displayed in the lookup
Use this option to set an additional filter layer and show only a limited set of records as value suggestions. For example, Supervisors from "Boston", who belong to the company "ABC Constructions" with the job title as "QC inspector". Likewise, you can also filter the records based on a specific account name and so on. This filter will fetch only those records that match the above criteria further narrowing down the list of records displayed in the lookup value.
Using fields to search for records in the custom lookup field
When creating a new record in a module, an appropriate value must be set in the custom lookup field. Admins can select the fields upon which lookup field search results will be based. This is useful for narrowing down results and helping the record creator select an appropriate value. Note the fields displayed in the Lookup records can be searched by are based on the related module.
For example, when a ticket is created, the supervisor's details need to be filled. Users can search for a supervisor by last name, city, and zip code. During configuration, Admins can set these fields as parameters to filter records. Say a user enters "Boston" as a search filter. All supervisors from Boston will be displayed in the results.
Using fields to sort records in the Search Suggestion pop-up
Records displayed in the Search Suggestion pop-up can be sorted based on created time, [related module] name, or modified time to ensure the most relevant results are displayed first. The available sorting options are based on the related module selected. For example, if contacts are sorted by "created time," then the most recently added contact will be displayed at the top of the list.
Other fields to show in the Search Suggestion pop-up
Additional information can be displayed in the search box to help users find the most appropriate record. For example, when the user is searching for a supervisor using the city (Boston), the system will display all the supervisors from Boston. To provide more context to the search result, other field values, such as the supervisor's email address, first name and last name, and company name can also be shown.
Other fields of the layout (where the custom Lookup Field is added) can also be auto-filled with values from the related module. For example, in the Tickets module, other fields, like supervisor's email address, product code, and discount value, which are present in the Contacts module can be auto-populated.
Let's say you are creating a custom lookup field in the
Tickets module and choose the
Phone field as the
related module field and
Contact Number as the
current layout field using the
Prefill Values from Related Module option. By doing this, you can pre-populate the Contact Number field in the Tickets module (current layout field) based on the corresponding data in the Phone field of the Accounts module (related module field). Note, this
is only useful if you have similar fields as the related module in the layout. You can create a maximum of five Prefill Values from Related Module criteria.
Note- The layouts for Accounts and Contacts module are organization specific and not specific to a department. However, layouts for the Tickets module are department-specific.
- In the Add Lookup Field window, the Lookup records can be searched by and Record fields to display in lookup table will automatically fill in the name field, which is mandatory. This is based on the related module selected in the Add Lookup Field window.
- You can select only six fields in the Lookup records can be searched by field.
- You can select only six fields from the Record fields to display in lookup table field.
To create a custom lookup field
- Go to Setup ( ) > Customization > Layout and Fields.
- Choose the desired module and department from the drop-down list.
You can choose from the Tickets, Accounts, and Contacts module only.
- Click Add Layout or choose an existing layout.
- From the Add Field tray, drag and drop the Lookup field in the desired section.
On the Add Lookup Field window, do the following:
Enter the field name.
Choose the Related module from the drop-down.
Specify the subtab name in the Subtab Name in Lookup Module field.
Toggle the Mark as Required option to mandate the custom lookup field.
Toggle the Show Tooltip option to display short information on your custom lookup field.
On the Add Lookup Field window, do the following advanced configurations, if needed:
Toggle the Filter Lookup Records option to narrow down the list of records displayed in the lookup suggestion.
Note: You can create a maximum of five filter criteria. You can also choose the Also display, all records from the lookup module to enables users to view all records and filtered records as separate lists in the lookup table.
Select the fields from the Lookup records can be searched by drop-down list by which you want to lookup.
Select the desired Lookup records can be sorted by option from the drop-down list.
Choose which fields from the Record fields to display in lookup table list should be displayed in the suggestion pop-up.
Toggle the Autofill the layout fields with values from the selected lookup record option to pre-fill values in the current layout field from a related module field.
Click Add.
The configured settings in the Add Lookup Field window will be saved and the window will close.
Click Save & Close to close the layout.
Editing Custom Lookup Field
Editing a custom lookup field allows to modify various aspects of the field, such as the filter criteria and prefill options. With the ability to fine-tune these settings, you can ensure that your custom lookup field displays the data you need in a way that is most useful to you.
To edit a custom lookup field
- Go to Setup ( ) > Customization > Layout and Fields.
- Choose the desired module and department from the drop-down list.
You can choose from the Tickets, Accounts, and Contacts module only.
- Select any of the existing layouts.
- Click the setup icon next to the custom lookup field.
- Select Edit Properties from the drop-down list.
The Edit Lookup Field window appears. - On the Edit Lookup Field window, make the necessary changes.
- Click Update.
- Click Save & Close to close the layout.
Disabling and Deleting the Custom Lookup Field
Custom lookup fields can be useful in many scenarios, but there may be times when you need to disable or delete them. Disabling a custom lookup field will not delete the data already associated with it.
To disable a custom lookup field
- Navigate to the desired custom lookup field in a layout.
- Click the setup icon next to the custom lookup field.
- Select Remove Field from the drop-down list.
The custom lookup field will be moved to the Unused Fields tray on the right.
Note
To enable the unused custom lookup field, drag and drop the desired custom lookup field back onto the layout. The field will be restored with its previously configured settings, so you won't need to set it up from scratch.
Deleting a custom lookup field, will permanently remove the field and all of its associated data such as related module field, subtab in the related module field, filter criteria from the system. It is important to note that deleting a custom lookup field cannot be undone and the action cannot be reversed.
To delete a custom lookup field
- Navigate to the desired custom lookup field in a layout.
- Click the setup icon next to the custom lookup field.
- Select Remove Field from the drop-down list.
The custom lookup field will be moved to the Unused Fields tray on the right.
- Click the Delete icon next to the unused custom lookup field.
- Click Yes, Delete Now to confirm the deletion.
SEE ALSO