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!

    Access your files securely from anywhere



      Zoho Campaigns Resources

            Zoho Developer Community

                Bootcamp
                Community
                Pricing
                Webinars
                What's New
                Integrations
                Contact Support
                Contact Sales

                  Zoho Survey Resources
                    Features
                    Survey Templates
                    Integrations
                    Community
                    iOS Mobile Surveys
                    Pricing
                    Android Mobile Surveys
                    Insurvey Blogs
                    Insight Blogs
                    Tips & Tricks






                                  Latest Feature Updates


                                      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 SalesIQ Resources


                                                  Manage your brands on social media
                                                  Access Zoho Social

                                                    Zoho Pagesense Resources


                                                        Zoho TeamInbox Resources

                                                          Zoho DataPrep Resources



                                                            Zoho CRM Plus Resources

                                                              Zoho Books Resources


                                                                Zoho Subscriptions Resources

                                                                  Zoho Projects Resources


                                                                    Zoho Sprints Resources


                                                                      Qntrl Resources


                                                                        Zoho Creator Resources



                                                                            Zoho CRM Resources

                                                                            • CRM Community Learning Series

                                                                              CRM Community Learning Series


                                                                            • Kaizen

                                                                              Kaizen

                                                                            • Functions

                                                                              Functions

                                                                            • Meetups

                                                                              Meetups

                                                                            • Kbase

                                                                              Kbase

                                                                            • Resources

                                                                              Resources

                                                                            • Digest

                                                                              Digest

                                                                            • CRM Marketplace

                                                                              CRM Marketplace

                                                                            • MVP Corner

                                                                              MVP Corner





                                                                                Design. Discuss. Deliver.

                                                                                Create visually engaging stories with Zoho Show.

                                                                                Get Started Now


                                                                                  Zoho Show Resources


                                                                                    Zoho Writer Writer

                                                                                    Get Started. Write Away!

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

                                                                                      Zoho CRM コンテンツ






                                                                                        Nederlandse Hulpbronnen


                                                                                            ご検討中の方





                                                                                                  • Recent Topics

                                                                                                  • The email address you have entered belongs to a different deployment/region.

                                                                                                    Hi, I am trying to create the user - mprust@crombiecomputers.co.uk but keep getting the message below -  The email address you have entered belongs to a different deployment/region. Please contact support@zohoaccounts.com for assistance. Look forward

                                                                                                  • Pre-fill TO and CC fields for Email Templates

                                                                                                    This would be a game changer to be able to set either specific email addresses or merge fields based on deal role titles into email templates. Please pass this along to *hopefully* add to future features of Zoho CRM.

                                                                                                  • Leads and Deals Issue

                                                                                                    Hi! Is Zoho having trouble today? I've been experiencing issues today. When I move a deal to closed/won, it previously would require a closing date but today the screen just went blur and the closing date did not pop up. And then under leads, I was trying

                                                                                                  • QR codes in templates

                                                                                                    I'm excited about the new QR code generator. I have included a QR code that contains the record ID setting "${ID}" as input data. In the report detail it works perfectly but when printing it in a template the code is not shown.

                                                                                                  • How do I hide all leads from Standard users in my CRM ZOHO

                                                                                                    I want to configure my crm zoho in such a way that standard users will only see leads owned or assigned to them. How do I go about doing this? I have tried all i could, but nothing...can anyone help me?

                                                                                                  • How to Implement Time-Based Filters in Zoho Workflows?

                                                                                                    Hi everyone, I’m looking for a workaround to implement time-based filters in Zoho workflows. Specifically, I need a workflow to trigger only within certain hours (e.g., between 10:00 AM and 8:00 PM, Sunday to Friday). Currently, Zoho workflows execute

                                                                                                  • is there a better way to routinely export my project timesheets?

                                                                                                    Hi there, I am somewhat happy with how Zoho books handles time.  One thing that is missing is more user driven control over my data.  I have a workflow where I constantly need to give customers feeds of work done.  So I pick a project, and would ideally

                                                                                                  • Portal Default View

                                                                                                    Hello! My company is about roll out portals for some users, but we were wondering if it was possible to set the Record Detail Page View to default to a custom view that we made. That way the information they need would be streamlined and easier to see.

                                                                                                  • Does zoho rest api support token exchange from microsoft entra id token

                                                                                                    i want to get access token from the Microsoft user token in rest api. so it is possible to exchange microsoft user access token to zoho's access token or auth token ( token should be user specific not super admin).

                                                                                                  • Important: DKIM verification needed for unauthenticated email domains

                                                                                                    Hi all, This post is to inform users who are currently using unauthenticated email domains as their sender email for their notifications. We have mandated DKIM verification for all domains used as sender email addresses for the outgoing emails by 01-Feb-2025

                                                                                                  • How do I define a weekend

                                                                                                    I noticed the default for weekends does not seem to include Saturdays. How can i define weekends to include both Saturdays and Sundays? Thank you.

                                                                                                  • Zoho Sign Product updates - H2 2024

                                                                                                    Hello! We have almost come to the end of 2024! Here's a list of features and enhancements that went live in the later half of the year. NOM 151 certification Witness signing Formula, conditional, and custom fields Zoho Sign's extension for Bigin by Zoho

                                                                                                  • Custom Status for Purchase Orders

                                                                                                    Currently Zoho books has functionality to create custom statuses for Sales Orders. Can this be extended to include custom status for purchase orders as well? It was a great decision to add this functionality to sales orders. Our use case is for tracking

                                                                                                  • Remove Address from credit card payment

                                                                                                    I would like to remove the need to add address when paying by credit card. I only want the customer to have to add their credit card details.

                                                                                                  • Is it possible to Select Item Serial Numbers from a Sales Order?

                                                                                                    Our accepted estimates are converted to Sales orders for our warehouse staff to pick.  How can my warehouse staff select the serial numbers for an item when editing a Sales Order?  Logically when staff pull an item and have the serial in front of them they update the Sales Order and select the serial. I understand a serial can be added when creating an invoice but how can accounts team know the serial if the warehouse staff can't select it! A basic flaw!

                                                                                                  • New Built In QR/Barcode Generator Print Settings

                                                                                                    I'm trying out the new QR/Barcode generator field in Creator. I would think most people will want to print these, like I do. I am not seeing any way to control the height or width of the barcode for printing (inside the print/pdf template builder). The

                                                                                                  • My Zoho mail has been blocked for suspicious activity. cannot unblock it! need urgent help!

                                                                                                    Hi, I was accessing my email on an airplane which for some reason resulted in my mail being blocked. I have managed to unblock my incoming however outgoing is still blocked. I have contacted all your support emails but it still says contact support when I try to unblock outgoing emails. Its now been over 8 days with the same issue which is really serious as I'm not able to send several business emails during this period. I have followed all your steps to unblock this and contacted your support 5

                                                                                                  • Copy Widget to another Dashboard

                                                                                                    I can see the option to clone a widget to the same dashboard but is it possible to copy it to another dashboard?

                                                                                                  • Error while importing products Purchase Price: Value in the field does not match with the data type supported by us.

                                                                                                    I am trying to import items into zoho inventory using an excel spreadsheet. I keep getting this error Purchase Price: Value in the field does not match with the data type supported by us. no matter how i format the cells this comes up and will not import

                                                                                                  • Quotes Module - import data

                                                                                                    Hello Zoho, is it possible to import Quotes records? I was trying and i have no results. Raport shows no data imported. Could you help me please how to do it?

                                                                                                  • Year-End Wrap: Disconnect now; Reconnect later with Offline Mode

                                                                                                    🎄Happy Holidays🎄 Let's say you are travelling home to spend the holiday season with your loved ones. Before you even board the train, you check your phone only to find your inbox rapidly filling with urgent emails that need your attention. There’s no

                                                                                                  • Resource booking functionality questions

                                                                                                    I'm exploring the resource booking functionality in Zoho Bookings for my organisation's needs. I have a few questions about the available Zoho Bookings functionalities. Is it possible to force all users to sign up for an account before they book a resource?

                                                                                                  • How to create a Field with answers as Yes, No> Further if no is selected a new field to be visible to give details

                                                                                                    Dear All, I am creating a feedback form in HR Letter. The question is were you satisfied with the work allotted. Expected answer to this is Yes, No. Further if the response is no, then a field to be give to fill more details as to why no was selected.

                                                                                                  • Modify the way a phone number is shown in footer on ZOHO Booking Page

                                                                                                    The default display of the phone number field in the footer is not customer friendly - See image below. We would like it to use the accepted standards of phone number display: +61 (0)2 88545440, or allow us to choose. At the moment ZOHO Booking sets how

                                                                                                  • Zoho Bookings Multilingual ?

                                                                                                    Hello, Not sure if there is a way to do it currently, but it would be very helpful if Zoho bookings allowed multilingual translations so we could have our booking pages and notifications setup in multiple languages. Thanks,

                                                                                                  • Allow customers to choose meeting venue and meeting duration on booking page

                                                                                                    My business primarily involves one-to-one meetings with my clients. Given the hybrid-work world we now find ourselves in, these meetings can take several forms (which I think of as the meeting "venue"): In-person Zoom Phone call I currently handle these

                                                                                                  • Two way sync Zoho Mail and Bookings

                                                                                                    Hi, I know it’s possible to view Bookings appointments in Zoho Mail, but is there a way to see my Zoho Mail meetings in the Bookings calendar?

                                                                                                  • Modifying iframe data of Zoho booking iframe

                                                                                                    Hello, I have integrated a Zoho Bookings embedded iframe into my website. Currently, I am pre-filling the booking form with default values as part of our process flow. However, I want to ensure that if an input field is already populated with a default

                                                                                                  • Sending my emails to Spam Folder

                                                                                                    I am loosing my business because of this issue, many of my customers are receiving their email in the spam sometimes no one checks them

                                                                                                  • Why can't I sync my Zoho Mail tasks and notes with my mobile device, and is there a way to fix this issue?

                                                                                                    I'm having trouble syncing my Zoho Mail tasks and notes with my mobile device. Despite following the usual steps, the tasks and notes don't appear on my phone. Is there a way to fix this issue? Regards, Adamjes, Tekskills India Pvt Limited, India.

                                                                                                  • Re: constant rejected email form and to my account

                                                                                                    Hi, have had several rejection when I sent an email to Zoho account as well as other people have sent emails to my as your health Centre they have account and all aspects have been ejected. i wonder why the email are rejecting to and from. If you see

                                                                                                  • How do I redeem credits?

                                                                                                    How do I redeem credits that are shown in billing section?

                                                                                                  • Cannot add IMAP account to "new" Outlook

                                                                                                    Hi, I am attempting to add an IMAP account to my copy of the "new" Outlook on my desktop computer. I have tried using the default password when MFA was disabled and an app password when MFA was enabled. But neither attempt worked. My Windows 11 OS number

                                                                                                  • Update Zoho Flow on Sprint Work Item Status Change

                                                                                                    Hello, I've contacted Zoho One support but have been unable to help in a timely manner, so I'm asking the community. I want to start using sprints, but I'm having an issue. I need to post updates to Slack when a Work Item has a status change. My understanding

                                                                                                  • Create Dashboard using data/tables from different workspaces

                                                                                                    Is it possible do create a Dashboard using different tables that are part of different Workspaces?

                                                                                                  • Este domínio já está associado a esta conta

                                                                                                    quando digitei meu domínio recebi essa mensagem que meu domínio estava associado a uma conta que eu nem faço idéia de quem seja. Como que faço pra resolver isso?

                                                                                                  • Storage addon failed to upgrade

                                                                                                    Hi, I am trying to purchase addon storage, but i am getting upgrade failed error Sorry! We are unable to process your information. Please try again after some time. If the problem occurs again, please visit our Contact Us page to reach out to the appropriate

                                                                                                  • no puedo recibir correos

                                                                                                    Hola, en la cuenta de la empresa desde hace unos tres días dejamos de recibir correos y no hemos realizado ningun cambio de configuracion, requerimos asistencia urgente por favor

                                                                                                  • NO PUEDO RECIBIR CORREOS EN MI CUENTA ZOHO MAIL

                                                                                                    LO QUE SI PUEDO HACER ES ENVIAR CORREOS PERO NO PUEDO RECIBIR CORREOS. Y LA CONFIGUIRACION DE MI DNS YA ESTA CORRECTA Y APUNTAN A ZOHO PERO AUN ASI NO PUEDO RECIBIR  NECESITO AYUDA URGENTE YA QUE EN MEXICO NO HAY FORMA DE COMUNICARNOS VIA TELEFONIA CON

                                                                                                  • Send email is not authenticated

                                                                                                    Hi, I’m getting an error in Gmail, when receiving an email from my account in zoho, my email is already authenticated in my domain, and I don't know why I keep receiving this message... also testing in outlook, the message goes directly to "junk".

                                                                                                  • Next Page