Field of Lookup in CRM

Field of Lookup in CRM

Last modified on 04/04/2023: Field of lookup is now available for all Zoho CRM users in all DCs. Note that it was an early access feature available only upon request.

Hello All,

We're thrilled to talk about a much-awaited enhancement to lookup fields—
now associate fields from the lookup modules. This is a functionality we had already provided for subforms and is now made available for the layout lookup fields as well. 

So let's get into the details, without further ado!

Field of Lookup
Lookup fields, as we all know, helps you associate data from one module to another. You can lookup for the records in your Contacts module through a lookup field in the Deals module, and associate them as desired.

Until recently, the usage of lookup fields was restricted only to associating the primary field values for the particular module. After looking up for contacts to associate with a deal, only the contact name would be available in the deals module. However, there can be situations when you need additional related details from the lookup module about the record that was associated, for example, the contact's number, or email address.

Although you had provisions to meet these requirements using custom functions, with our latest enhancements you can now associate fields from the lookup module into your record.





How to associate fields of the lookup module?

Let's say, in the Students module of a university, the lookup field for the Course type will display the name of the course a student is interested in. However, in instances when you want to view more details such as course fee, course duration, subjects, principal coordinator, etc. then you can use the field of the lookup module option to associate those fields from the Course module.
. You can either select the field from the courses module to be available in the students module and add it as a new field in the students module. Ex. let's say, course fee, duration, or subject(s).
. Again, let's say, you need to have the course instructor field, and a custom field for the instructor is already existing in the students module. Hence, you can choose the option to map with the existing field.



Points to be noted

. These enhancements will be available for Enterprise and Ultimate editions.
. Field of lookup option will be available in Modules that support the lookup field.
. For each lookup field in your module, you can associate a maximum of 5 fields from the lookup module into your primary module layout.


Upcoming enhancements
Here is a list of future enhancements related to the field of lookup to enhance your experience using the feature.

. Field of lookup User and Record owner fields will be available to associate as fields of lookup.
. Mapping the fields from the lookup module with system-defined fields in the primary module will be supported.
. Keeping the field of lookup values in sync based on the value changes in the lookup module.


That's all about the enhancements. We would love to hear your feedback and suggestions in the comments below. Read more about Field of Lookup in our help doc.

Thanks and have a good one!

    Zoho Campaigns Resources


      • Desk Community Learning Series


      • Digest


      • Functions


      • Meetups


      • Kbase


      • Resources


      • Glossary


      • Desk Marketplace


      • MVP Corner


      • Word of the Day


      • Ask the Experts


        Zoho CRM Plus Resources

          Zoho Books Resources


            Zoho Subscriptions Resources

              Zoho Projects Resources


                Zoho Sprints Resources


                  Zoho Orchestly Resources


                    Zoho Creator Resources


                      Zoho WorkDrive Resources



                        Zoho CRM Resources

                        • CRM Community Learning Series

                          CRM Community Learning Series


                        • Tips

                          Tips

                        • Functions

                          Functions

                        • Meetups

                          Meetups

                        • Kbase

                          Kbase

                        • Resources

                          Resources

                        • Digest

                          Digest

                        • CRM Marketplace

                          CRM Marketplace

                        • MVP Corner

                          MVP Corner




                          Zoho Writer Writer

                          Get Started. Write Away!

                          Writer is a powerful online word processor, designed for collaborative work.

                            Zoho CRM コンテンツ






                              ご検討中の方

                                • Recent Topics

                                • Launching CPQ for Zoho CRM! An in-built solution for bespoke quote management

                                  Hello everyone, We are thrilled to announce the public release of CPQ (Configure, Price, Quote) for Zoho CRM, which is a fundamental block in sales management. NOTE: CPQ was a public early access feature from March 2023 — January 2024. Since February
                                • Enhancing self-service capabilities with AI-based Zia Answer Bot

                                  Hello All, Zia Answer Bot is available with better accuracy to enhance the self-service capabilities of the platform and to empower the users to resolve queries independently. By leveraging knowledge base (KB) resources, the Answer Bot provides accurate
                                • Zoho Creator Get Records Integration Task

                                  Trying to use Zoho Creator's Get Records integration task to fetch records from a specified report in Zoho Creator: https://www.zoho.com/deluge/help/creator/get-records.html However, I continue to receive a code 2894 error saying that the report is not
                                • spark sync problem with iphone

                                  Hello, I am using the spark application on iphone 15 pro max and 16 pro max. After several days of installing the account on spark i dont get notifications on new emails, i have to open the app in order to receive the new emails. After sending email to
                                • Issues with GC Integration and Ticket Retrieval in Instant Messaging

                                  I am using Guided Conversations (GC) within Instant Messaging (IM) channels. When a user sends a message, a ticket is created in Desk, but GC cannot identify which ticket it corresponds to. To address this, I have implemented a workflow rule to rename
                                • Localhost works fine, but issue come Zoha mailer on live server

                                  package.json "proxy": { "/auth/google": { "target": "http://localhost:8000/" } }, ContactForm.jsx import React, { useState, useEffect } from 'react' const ContactForm = () => { const [fname, setFname] = useState(""); const [lname, setLname] = useState("");
                                • Set Mandatory Lookup Fields in Ticket Layout

                                  I added a custom module called 'Site' in the desk. I also added a lookup field 'Site' in the ticket layout. Now, I want the 'Site' field to be mandatory in the blueprint transition. How can I do that?
                                • Ability to Initiate WhatsApp Template Messages in Zoho SalesIQ Without Preexisting Chat

                                  Hi Zoho SalesIQ Team, I hope you're doing well. I understand that with the WhatsApp integration in SalesIQ, clients can contact us via WhatsApp, and we can use WhatsApp templates to send messages outside of the 24-hour window by reopening an existing
                                • CPQ Quantity suggestion does not allow multiple products

                                  I have come across an issue in the CPQ Product Configuration. I want 10 products to trigger the suggestion of an additional product via the quantity in quoted items function. However, when specifying the configuration, I am only able to choose one base
                                • Work Orders / Bundle Requests

                                  Zoho Inventory needs a work order / bundle request system. This record would be analogous to a purchase order in the purchasing workflow or a sales order in the sales cycle. It would be non-journaling, but it would reserve the appropriate inventory of
                                • Email content strategy

                                  This is basically a couple of questions about the best practices when it comes to the use of colors as part of the message sent through the email campaign. 1 - Is there a guide or recommendation as to what are the best colors for text/background associated
                                • Bill Of Material

                                  Can anyone tell me how to generate Bill of  Material (BOM) in zoho. _Thanks and regards, Dinesh A.
                                • How to extract URL parameters with Zoho Flow

                                  Hello, I try to extract different parameters like UTM and Ads platform id like MSCKLID. Ex. mydomain.com/?utm_source=1234 They aren't necessarly all filed due to the usage of different platform. I have a field with the URL in Zoho CRM I have individual
                                • Weekly Tips: SecurePass For Extra Security

                                  Imagine sensitive data from your organisation sent via email is being accessed by unintended recipients. The sensitive data can range from Personal Identification Information to a tender quotation or a client’s NDA document. The unintended access could
                                • Paid Support Plans with Automated Billing

                                  We (like many others, I'm sure) are designing or have paid support plans. Our design involves a given number of support hours in each plan. Here are my questions: 1) Are there any plans to add time-based plans in the Zoho Desk Support Plans feature? The
                                • Delete a department or category

                                  How do I delete a Department?  Also, how do I delete a Category? This is pretty basic stuff here and it's impossible to find.
                                • No puedo enviar correos, outgoing blocked

                                  No puedo enviar correos, me sale un mensaje de error outgoing blocked. Pueden revisar y desbloquear la cuenta. Gracias
                                • Open A.I assistant Connect with Zoho Desk instant Message Conversations

                                  I would like to know how do I connect my instant messenger in Zoho desk with my Open A.I Gpt Assistant. this is very easy to setup using the Salesiq Zobot but when it comes to Zoho Desk i cannot figure how to make the connection. Ideal workflow Customers
                                • Reopen and Continue WhatsApp Chats within 24-Hour Window

                                  Dear Zoho SalesIQ Team, I'm writing to request a new feature that would enhance WhatsApp communication management within the 24-hour window: the ability to reopen and continue conversations with customers after a chat has been closed from our end. Current
                                • How to Initiate WhatsApp Message on SalesIQ?

                                  I've just activated a Business WhatsApp phone number through SalesIQ because of its touted omnichannel chat approach. Sounds exciting. I understand that when a customer sends me a WA message, I can reply to it on SalesIQ and keep the chat going, perfect.
                                • Cannot create alias, getting AS101

                                  The error AS101 is shown while I try to add the alias. How can I fix that?
                                • BOLETO PARA PAGAMENTO

                                  Gostaria de saber como faço para pagar o boleto de licença anual do o email do zoho
                                • CAIXA DE E-MAIL BLOQUEADA

                                  Obrigado, bom dia! O e-mail financeiro@grupoa7.com.br está com a caixa de e-mail bloqueada e já apagamos alguns e-mails e agora estamos tentando fazer backup dos mais antigos e não estamos conseguindo. Poderiam nos ajudar?
                                • Email sent from Automated system on Oracle Netsuite of my customer not being received in my zoho mail

                                  My customer is using Oracle Netsuite to send us enquiries and PO's. It is strange that these are not being received in my Zoho Mail account. It is not even bouncing back. I am not sure why is it is not being shown. I wrote to support@zoho.com but the
                                • Paypal Payaments Pro not available in our live account.

                                  We have a test environment set up and one of hte payment gateways is paypal payments pro. This option is not avaiable in our live account and the regular paypal gateway says auto-charge not available. Why does paypal payments pro not appear in our live
                                • Diagnostic-Code: 4.7.650

                                  Good Afternoon! Today i had this problem with all the emails that i sent... The original message was received at Thu, 23 Jan 2025 11:44:20 -0800 from vxxxxxxx@fxxxxxx.mx [vxxxxx@fxxxx.mx] ----- The following addresses had fatal errors ----- [sxxxxxxxxxxxxxxxxx@hxxxxxxx.com]
                                • 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 which is able to support this operation ? Thank you in advance, Leandros
                                • Firebase Functions integration

                                  Hello Zoho Team, Please advise how I can configure SMTP in my account to facilitate Firebase-triggered email functions. Please note that I desire to send an email with a JSON object collected from Firebase Firestore and included in my mail to forward
                                • Cant connect my Zoho Email to Apollo.io account

                                  Im trying to add my Zoho email to my Apollo account in order to be able to send emails through Apollo but I keep getting time out error. In order to set the email account there is a small form in Apollo I have to fill. For email and password I use the
                                • I am having issues with my Zoho Mail account;

                                  I am having issues with my Zoho Mail account; I am unable to send or receive emails and need to reactivate my account. I am receiving the following message: "This message was created automatically by the mail delivery system. THIS IS A WARNING MESSAGE
                                • User Filter for Dynamic Date Dimensions in Zoho Analytics

                                  One challenge I frequently encounter is the need to create multiple versions of the same report—one for yearly data, another for quarterly data, another for monthly, and so on. While this works, it leads to unnecessary duplication, making maintenance
                                • Zoho CRM - COQL query failing with no reason

                                  Hi I'm trying to execute a COQL query but it's returning an error. Unfortunately I cannot understand where I'm wrong The query is the following;: URL: POST https://www.zohoapis.com/crm/v2.1/coql Body: { "select_query": "select id,Adjustment,Billing_City,Billing_Code,Billing_State,Billing_Street,Buyer_PO_Number,Delivery_Date,Delivery_Method,Due_Date,Grand_Total,Invoice_
                                • Does anyone know what is the time frame for our Tickets to be attended to?

                                  4 Days ago I sent a ticket to check if our vendor's email address/domain is listed as spam because for some reason, their emails kept being bounced back and we did not receive any notification. As of yet, I have not received any indication that my query
                                • Linking an email to a Contact when the email is sent in deluge via sendmail

                                  The "to:" address in this code is a CRM Contact. Email address is forced unique in CRM This sendmail gets sent via a workflow which is in a custom module. It works, except that the outbound email does not appear (i.e, get linked to) the Contact such that
                                • Re-emphasizing the importance of Domain Whitelisting in ASAP's JWT Authentication Mechanism

                                  The problem We discovered a security vulnerability related to using OAuth tokens in non-whitelisted domains and have reinforced our security measures. If you experience any request failures in the authorized domains, please verify that they are whitelisted
                                • How do you arrange order in which the speakers are listed in a session once they have been selected?

                                  Probably another simple thing I've missed but I can't find how to arrange the order in which the speakers are listed in a session once they have been selected. We usually want the speakers listed alphabetically by last name, but sometimes not. Once the
                                • How do you select/display the Speaker that will be the chair/moderator of a Session?

                                  I could very well be missing something but I can't see an option for displaying the Speaker that will be chairing/moderating a Session There doesn’t appear to be an option for this in the available Session fields I can can’t find anywhere that would allow
                                • How do I connect a Google Cloud Project as a Custom Service

                                  How can I connect a Google Cloud project as a custom service to ZohoCRM? I need to pull YouTube Analytics data into CRM, but I cannot use the included YouTube service as it does not have the scopes I need. Therefore, I need to create a custom service.
                                • email configuration - email is rejected - what is best way forward

                                  We started getting rejection/bounce back on email sent out of zohodesk. typically we have SMTP from our domain into zohodesk eg support@example.com our mail respones go back out as example : support@example.zohodesk.com These email bounce with error:
                                • Sync Gmail for Admins

                                  Hello. We migrated from gmail to Zoho mail a few years ago, but some users want to be able to use gmail. I have set up dual delivery in the Zoho Mail Admin console. This is working fine. I can't figure out how to sync outgoing emails. Specifically, if
                                • Next Page