Creating Custom Lookup Fields - Online Help | Zoho Desk

Creating Custom Lookup Fields in Zoho Desk

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:  


  1. 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.
  2. 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. 
  3. 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

Marking a field as Required and showing tooltips

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

  1. Go to Setup ) > Customization > Layout and Fields.
  2. Choose the desired module and department from the drop-down list.
    You can choose from the Tickets, Accounts, and Contacts module only.

  3. Click Add Layout or choose an existing layout.

  4. From the Add Field tray, drag and drop the Lookup field in the desired section.

  5. On the Add Lookup Field window, do the following:
    1. Enter the field name.

    2. Choose the Related module from the drop-down.

    3. Specify the subtab name in the Subtab Name in Lookup Module field.

    4. Toggle the Mark as Required option to mandate the custom lookup field.

    5. Toggle the Show Tooltip option to display short information on your custom lookup field.



  6. On the Add Lookup Field window, do the following advanced configurations, if needed:
    1. 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.

    2. Select the fields from the Lookup records can be searched by drop-down list by which you want to lookup.

    3. Select the desired Lookup records can be sorted by option from the drop-down list.

    4. Choose which fields from the Record fields to display in lookup table list should be displayed in the suggestion pop-up.

    5. 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.



  7. Click Add.
    The configured settings in the Add Lookup Field window will be saved and the window will close. 
  8. 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

  1. Go to Setup (  ) > Customization > Layout and Fields.
  2. Choose the desired module and department from the drop-down list.
    You can choose from the Tickets, Accounts, and Contacts module only.

  3. Select any of the existing layouts.

  4. Click the setup icon next to the custom lookup field.
  5. Select Edit Properties from the drop-down list.
    The Edit Lookup Field window appears.
  6. On the Edit Lookup Field window, make the necessary changes.
  7. Click Update.
  8. 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 

  1. Navigate to the desired custom lookup field in a layout.
  2. Click the setup icon next to the custom lookup field.
  3. 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 

  1. Navigate to the desired custom lookup field in a layout.
  2. Click the setup icon next to the custom lookup field.
  3. Select Remove Field from the drop-down list.
    The custom lookup field will be moved to the Unused Fields tray on the right.

  4. Click the Delete icon next to the unused custom lookup field.


  5. Click Yes, Delete Now to confirm the deletion.

SEE ALSO

    Zoho CRM Training Programs

    Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

    Zoho CRM Training
      Redefine the way you work
      with Zoho Workplace

        Zoho DataPrep Personalized Demo

        If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

        Zoho CRM Training

          Create, share, and deliver

          beautiful slides from anywhere.

          Get Started Now


            Zoho Sign now offers specialized one-on-one training for both administrators and developers.

            BOOK A SESSION











                                        You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                            Manage your brands on social media

                                              Zoho Desk Resources

                                              • Desk Community Learning Series


                                              • Digest


                                              • Functions


                                              • Meetups


                                              • Kbase


                                              • Resources


                                              • Glossary


                                              • Desk Marketplace


                                              • MVP Corner


                                              • Word of the Day


                                                Zoho Marketing Automation

                                                  Zoho Sheet Resources

                                                   

                                                      Zoho Forms Resources


                                                        Secure your business
                                                        communication with Zoho Mail


                                                        Mail on the move with
                                                        Zoho Mail mobile application

                                                          Stay on top of your schedule
                                                          at all times


                                                          Carry your calendar with you
                                                          Anytime, anywhere




                                                                Zoho Sign Resources

                                                                  Sign, Paperless!

                                                                  Sign and send business documents on the go!

                                                                  Get Started Now




                                                                          Zoho TeamInbox Resources



                                                                                  Zoho DataPrep Resources



                                                                                    Zoho DataPrep Demo

                                                                                    Get a personalized demo or POC

                                                                                    REGISTER NOW


                                                                                      Design. Discuss. Deliver.

                                                                                      Create visually engaging stories with Zoho Show.

                                                                                      Get Started Now









                                                                                                          • Related Articles

                                                                                                          • Working with Custom Fields

                                                                                                            In Zoho Desk, custom fields help you capture and organize information that may not be covered by default system fields. Because custom fields are user-defined, they can be tailored to meet the specific needs of your business and industry. For ...
                                                                                                          • Creating Custom Modules

                                                                                                            Module is a structured compartment used to organize and manage specific types of data.They serve as the building blocks or standard parts that make up the Desk's architecture, allowing businesses to efficiently handle different entities such as ...
                                                                                                          • Encrypting Custom Help Desk Fields

                                                                                                            Just as we lock our money and restrict access to our property in the physical world, we must secure our personal information that is held by businesses and government agencies. We need a virtual lock that prevents identity thieves from stealing our ...
                                                                                                          • FAQs: Custom Modules

                                                                                                            What is a custom module in Zoho Desk? Modules in Zoho Desk are like compartments. Just like each compartment holds different items, modules store different types of information in one place. For example, the Tickets module is a repository of customer ...
                                                                                                          • Introduction to Zoho Desk

                                                                                                            Help Desk is a department in an organization that is in charge of providing the support needed by customers while using the company's product or a service. Customers contact the help desk when they have a question or a problem and a product expert ...
                                                                                                            Wherever you are is as good as
                                                                                                            your workplace

                                                                                                              Resources

                                                                                                              Videos

                                                                                                              Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                              eBooks

                                                                                                              Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                              Webinars

                                                                                                              Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                              CRM Tips

                                                                                                              Make the most of Zoho CRM with these useful tips.



                                                                                                                Zoho Show Resources