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.
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.
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.
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!
. 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 Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
Saishree T K
Jordan Talmor
R T Kaushik
Nick
Ishwarya SG
Sticky Posts
Announcing Early Access to "Zoho CRM for Everyone" — A new and exciting update to Zoho CRM
We are delighted to announce an Early Access to Zoho CRM for Everyone— a truly democratic approach to managing a CRM, gift-wrapped in an exciting and intuitive user interface. Here, multiple teams across an organization can coordinate among each other[Early Access] Voice of the Customer (VoC) for Zoho CRM
Happy new year, everyone! We have an exciting addition to our suite of features and would like to introduce you to VoC (Voice of the Customer) for Zoho CRM, powered by Zia. 2023 is definitely the best time to be a customer with rapid innovations and advancementsAdding calls as a channel in Voice of the Customer
Dear All, We hope you're well! It's been almost a year since we opened Zoho CRM's Voice of the Customer solution up for early access. We are grateful for the reception and support you have been showing us with regards to its adoption and feedback. Since
New to Zoho TeamInbox?
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 Campaigns Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
Nederlandse Hulpbronnen
ご検討中の方
Recent Topics
Portal orders
Is it possible to set up an ordering system through the portal so that my customers can place orders through their portal?CLIENT PORTAL (If clients can place orders directly on the portal)
Zoho client portal is excellent. Everything is there except one thing. Client should be able to place orders directly on the portal. This would enhance the portal and end users will be extremely happy. This suggestion infact came from one of our client.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.Macro Email to be determined by a ticket field
Hi, we are a commercial energy brokerage and are implementing Desk as our helpdesk tool to replace manual emails, personal whataspp and telephone. We have setup a macro rule when we can trigger an email, update ticket status and trigger a task.... butWelcome Link Expired
Hi The links sent to the users didn't get clicked on in time and now all the links have expired. Is there a way to send a new link without deleting them and re-adding them>Custom view for Milestones
Hi, Just an idea for the future... would it be possible to create custom views for the Milestones view under Work Overview ? I usually need to look at this view filtered by project group but the filter doesn't remain when navigating away. A custom viewZoho expense linked with Campaign instead of customers
Hi, Is there a development planned for linked an expense or a report to a zoho campaign? Indeed, suppose I created a campain in which I add different clients (for example a trip to a foreign country where I meet 3 different clients), I would like this campaign to be linked to the expenses I have. Say I have a plane ticket, taxis and 1 hotel night, I would like those expenses to be linked to the 3 clients. With Zoho expense, it is not possible at the time (or maybe it is but I do not know how!). thanks🎄 Jingle, Mingle, and Automate: Spread Christmas Cheer with Zoho Desk Auto-Replies! 🎄
Hello Everyone! Welcome to this week's episode of the Community Learning Series. Christmas is in the air, and I’m sure we can all feel the jingle and the mingle of the season! The folks at Zylker Techfix are no exception—they’re busy with holiday plansHow to Iterate a Function in Zoho Desk Workflow with Delay Between Calls?
Hi everyone, I’m working on a function in Zoho Desk that searches for a specific ticket record. If the ticket is not found, I need to retry the search multiple times with a delay between each attempt until the ticket is located or a maximum number ofMaking Calls Using ZDialer on Zoho Creator Widgets
The Zdialer Browser Extension does not seem to recognize phone numbers on custom widgets. What is the best way to work around this?Adjusting Physical Inventory
Not getting very far with support on this one, they say they are going to fix it but nothings happened since November. Please give this a thumbs up if you would like to see this feature or comment if you have some insight. Use Case: Inventory set to bePrint PO receipt
Hi I would like to print the PO receipt. There does not seem to be any way to do this. I track batch numbers and printing the PO does not show this. Only the receipt would show the details of the receipt. Currently I print the screen which does not haveCreate a purchase order in vendor's currency
I am having a problem working this out and would appreciate some suggestions. We have Books and Inventory working in tandem. We are in Australia, our product is sold in Australia in $A and obviously all our invoices, accounts and reports need to be inTime Field
Good Day, I have a question, when I save a draft and reload it. Why does the time field format keeps goes from hh:mm to hh:mm:ss? Is there a way I can force it to load to hh:mm only? I have tried example = totime(input.TimeField, "hh:mm") in the -createdWork 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 ofGetting error during inserting a record in form of zoho people using zoho api
import requests import json # Set your access token and Zoho People API base URL access_token = '1000.XXXXXXXXXXXXXXX.XXXXXXXXXXXXXXXXXXXXX' api_base_url = 'https://people.zoho.in/people/api/' # Set the form name and data to be inserted form_link_nameDisplay your zoho contact name when they call your mobile number
As per the title If a contact calls the office number, the contacts name shows on mobile as long as I have their contact details registered in my crm. Is there a way that if the contact calls my mobile, their name can be displayed? Currently just their number shows when they call.Change script to add fields
Hi, I have a custom function (writen by a different implementation company in the beginning) which I would like to edit to add a different field as well. Can't get it to work on my own though. - The script now adds the address fields to a new quote (needs1 API to all channel
hi zoho team: I am the product manager of anywheel, we are planning to integrate zoho, we want to integrate multiple channels through 1 API, please can you send me the integration document and guideline?Custom Profile Agents Unable to Update Mandatory Phone Number in tickets under Zoho Desk
Hi, While working in the Ticket module in Zoho Desk, agents with a custom profile are unable to update the Phone Number field (which is mandatory) under Account Information. The agents need to enter values such as "NA" or "Nil" in the field to close theRevamped Print in Zoho Sheet—customized for paper
The latest enhancements to Zoho Sheet's Print settings allows you to print a worksheet or a selected range, with customizations that make the data comprehensible, even on paper. Customize header and footer Make your spreadsheets meaningful with a relevant header and footer. You can now choose to display the file name, sheet name, current page number, total pages, date, and time as the header and footer in your print view. Besides the predefined elements, you can also give a custom text for header/footer.Adding Bluesky channel
Hello, Is Bluesky (AT protocol) soon added on Social ? Bluesky is being developped and is now open to anyone (no more invitation) Thank youHow Can i put a form in Zobot
Hi,how can i integrate a form which has a multiple options to choose from.the form should be opened or displayed by zobot after it meets a requirement in the conversation. Thanks in advance !Query table pull last 12 months
I am tying to pull the following criteria and the date is always what causes me the issue. I want to pull people (pco_id) who have entries of "event_id" being these 2 events and whos "kind" is Regular or Guest and where the event_starts_at (date column)Unified customer portal login
As I'm a Zoho One subscriber I can provide my customers with portal access to many of the Zoho apps. However, the customer must have a separate login for each app, which may be difficult for them to manage and frustrating as all they understand is thatResponse Violation - Zoho Desk
Hi Team, I just need an information regarding the zoho desk - Response Violation and how can we avoid the tickets from getting the tickets response violated.message on click of button
Hi, i added insert task on 'Quick view' below 'Action' of report just below 'Delete' button, so i am trying to add a message on click of button that, "This item is now added into Pending Request" like this .... So, how can i achieve this ; becauseIs it possible to disable Chat Waiting Time, or to make it indefinite?
We have used many online chat services over the years. However, Zoho's SalesIQ appears to be the only one we've tried that has a mandatory time limit where we must respond to new customer queries. We are a small business so we have no dedicated staffAccess CRM Variables from Formula field
Is it possible to use a CRM variable (defined in Developer Space -> CRM Variables) in a formula field for calculations ?Client Script: $Client.refresh({ triggerOnLoad: true }); not triggering onLoad Client Scripts
Hey friends! I'm trying to store a temporary var, refresh the page for the user, then check that temporary var and do some actions. Theoretically using the title's code: $Client.refresh({ triggerOnLoad: true }); should refresh the page and trigger onSuper Admin login to delete certain folders and passwords and clearing the trash folder, they are still appearing on my dashboard
Hi Zoho Team, I need help with an issue I've encountered. Despite using the Super Admin login to delete certain folders and passwords and clearing the trash folder, they are still appearing on my dashboard. I would like to understand why this is happeningPulling Specific Products from Sales Orders in Books to a CRM Record
We currently process orders directly through our website (woocommerce) as well as through manual sales orders in zoho books. When an order comes through the website, all of the individual products from that order show up in the CRM record of that customer.Automatically add a retainer to every estimate
Hi all, I've been trying to find a way to automatically add a retainer at a set % to every estimate we create and send. So far I haven't been successful, does anyone know of a way to do this? Thanks,Clear String field based on the value of other field
Hello everyone, We would like to be able to clear a string field (delete whatever has been written and make it empty) when another field (picklist) is changed to a specific value. While I can empty other types of fields, I noticed that I can't do thisCustom Deal Name in Lead Conversion Mapping
I know there are ways to change the name of a Deal after conversion using a custom function, so no need to repost that information. I would like to see the CRM Improved with Deal Name Customisation and I think the Lead Conversion Mapping page would beWithin the Basic KPI component in Analytics, it is impossible to set "next" day range as a filter
Hi there, I am currently setting up a deal dashboard for the Sales team. While it is possible to filter deal records to show records that were created LAST X days only, it looks like a NEXT X days Closing date filter is not available. Would it be possibleInvoice status on write-off is "Paid" - how do I change this to "Written off"
HI guys, I want to write off a couple of outstanding invoices, but when I do this, the status of the invoices shows as "Paid". Clearly this is not the case and I need to be able to see that they are written off in the customer's history. Is there a wayFor each loop with available time slots
I am very new to Deluge, and this question was unable to be answered by Zoho Creator tech support upon request. Task at hand: I have a Form with 4 fields: - Date Start - Date End - Dropdown: Time Start: contains time slots (12:00PM, 12:15PM, etc) - Dropdown:Can we have Backorder Management ?
Can we have Backorder Management ?Converting Amazon Sales Order to Invoice
Hi there, We need advice on the Amazon integration with Zoho Inventory. Now, we want to convert all the Sales orders synced from Amazon to Invoices. We want also to include and record the Amazon fees associated with the sales (Amazon fees, FBA fees, Cost of Advertising etc.) However, Sales order only captures the sales proceeds (Gross Sales) in Zoho Inventory. Does anyone currently work with Amazon and can suggest how to correctly process the sales and Amazon payments through Zoho Inventory andNext Page