Field of Lookup | Zoho CRM

Field of Lookup

Lookup fields enable users to associate records between two modules. Let's say, for example, you have two modules: Students and Courses. By adding a lookup field called Course type in the Students module, users can select a course when a new student record is created or added in Zoho CRM, as well as view the list of students enrolled in a particular course in the Courses module's related list.
While the Course type lookup field displays the names of the courses in which a student has expressed interest, in instances when you want to view more details—such as course fee, course duration, subjects, course instructor, and so on—you can use the field of lookup module option.

Business scenarios

  1. View additional details of a contact in the Deals module
    Sales associates can view a contact's email address, phone number, referrer, and—alongside the primary lookup field—the contact's name. They can also view the values in these fields in a report created for the Deals module.
  2. Find the loan applications approved by a certain approver
    In the Applications module, adding a loan approver field can help agents quickly find the email address, role, and other details of the person who approved an application. Including a loan approver's email address field in the layout via the field of lookup option can also be helpful. Agents can also filter records on modules' list view pages based on the lookup field or the fields of lookup field added in the module. 

Working with field of lookup 

Field of lookup modules can be used in the following steps.
  1. Identifying and selecting the field - Depending on your business requirement, you need to identify and select the specific fields from the lookup module that needs to be added.
    For example, course fee, course duration, instructor, etc.
  2. Choosing the method to relate the fields - Once you have identified and selected the field from the lookup module to associate, you need to choose whether to map this with an existing field in the primary module, for example, course instructor, or add as a new field, like course fee, or course duration.
  1. While mapping fields, only similar field types will be listed for selection. Similarly, and adding new fields, fields with similar data types will be created.
  2. You will have the option of similar field types, when it comes to mapping the fields. However, there are certain exceptions like Picklist, Multi-Select, Auto-Number, Lookup, Formula, User Lookup and Record owner, etc.
    Lookup module fields (parent module)
    Field type newly created or fields listed for mapping
    Single line
    Multi-line (small)
    Lookup or single line
    Field type will be decided based on the return type of the formula field
    User lookup and record owner
    User lookup or Single-line

Adding a field of lookup 

To add field of lookup
  1. Log into your Zoho CRM account with Admin privileges, and click on the setup icon ( )
  2. Navigate to Customization and then to Modules and Fields.
  3. Select the module and go to the layout editor.
  4. Click the More icon next to the lookup field.
  5. Click Add field of lookup module.
  6. In the Field of lookup module page, click Add Fields.
  7. Choose a field from the lookup module.
  8. In How do you want to relate the field value with the [Contacts] module?, check either Add as new field or Map with existing Fields.
  9. If you choose Add as new field, enter the field name where you want the value to be added.
  10. If you choose to Map with existing fields, choose the field to which you want to map.

  11. Click Done.
  12. The added field(s) will be displayed in the Field of lookup module page. The relationship type will show if the field is added or mapped.
  13. Click + Add Fields, to include more fields.
  14. You can add upto 5 fields.
  15. Click Save.
  16. Click Save and Close, to exit the layout editor. 

Points to remember 

Data population

  1. For importing records - During import, the values for field of lookup fields are populated based on the values present in the imported file. Only if the value is empty, it will be populated based on Lookup record.In case the field value is empty then the system will check if any values are present for these fields in the existing lookup records and replace it. For example, while importing deals, if the contact's phone is empty in the field, then the phone number present in the contact record will be captured directly.
  2. During Lead conversion - When a lead is converted and a contact, account or deal is created, then the values of the related fields will be populated from the mapped fields in the leads module. However, if the fields have empty values then, value form the lookup will be populated.
  3. Updating records in the lookup module - The FOL field values will be populated only when the record is updated in the lookup field.
    When the related field in the parent module record is updated it doesn't change the value in the field of lookup fields.
    Similarly, when the field of lookup field is updated it doesn't change the value of the mapped field in the parent module.
  4. The field of lookup module will not be listed in the Find and merge - During find and merge, only the lookup fields will be listed and based on the lookup value that is updated in the master record, the data in FOL will be populated.
  5. During mass owner updates, the related data will be populated in all the FOL fields.
  6. Value in a field of lookup field will be populated if it has both Read-write and Read-only permission. 

Configurations side

  1. Unsupported Fields - The field of lookup is not supported for multi-select lookup, file upload, multi-user fields, or image upload fields.
  2. Parent lookup field is moved to unused fields/deleted - The dependent fields added to the module layout as fields of lookup will also be moved to unused fields. However, the relationship will still exist.
    If the parent lookup field is deleted from the layout, the dependent fields would still be available, but the relation for the field of lookup will not be existing.
  3. These fields cannot be marked as "Unique" fields.
  4. The character limit of the FOL fields is determined based on the parent field - After the field of lookup fields are created, the character limit of those fields cannot be edited and will be dependent on the parent field.
  5. Fields that are added to a layout via the field of lookup option cannot be updated through the field update option available in automation or process management such as workflows, blueprint, CommandCenter etc. 
    Similarly, if a field is used in one of those field update actions, it won't be listed to map under a field of lookup.
  6. System-defined fields can not be a field of lookup field.
  7. When multi-currency is enabled, the currency value populated in the FOL is based on the record currency and exchange rate present in the current record.
  8. If the value is changed in the parent field, the value in FOL won't be changed, and if the value in the child is changed, the value in the parent will not be changed, i.e. 2- way sync is not possible.

    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

                                                                                                      • Lookup Filters

                                                                                                        Lookup filters enable users to select only valid values from a lookup field while creating or editing a record. Admins can set the filter such that only the correct field values are displayed, and thereby help users avoid entering data incorrectly. ...
                                                                                                      • FAQs : Field Customization

                                                                                                        How can I create a Formula number field with the 'If, Else' statement? Currently, you can't create a Formula number field with the 'If, Else' statement. You can only create a formula field using the IF condition. However, you can also achieve the If, ...
                                                                                                      • Types of Custom Fields

                                                                                                        In Zoho CRM, you can add different types of custom fields as per your requirements. These fields will be available to all the users added to your organization's CRM account. Customize Zoho Defined Fields : You can edit, delete and hide some of Zoho ...
                                                                                                      • Setting Field Updates

                                                                                                        The Field Update option helps you to automatically update certain field values in the records, when the associated workflow rule is triggered. Availability Permission Required Users with administrative profile can access this feature. To create field ...
                                                                                                      • Actions - Field updates

                                                                                                        Setting up field updates  Help guide Setting Field Updates
                                                                                                        Wherever you are is as good as
                                                                                                        your workplace



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


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


                                                                                                          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