Map Dependency Fields in Zoho CRM using APIs
Map dependency fields with a use case
- Parent Field - Issue Type: The value chosen here determines which options appear in the dependent field.
- Child Field - Sub-Issue: The available options change dynamically based on the selected value in the parent field.
Issue Type | Sub-Issue |
Login Issue | Forgot Password, Account Locked, 2FA Not Working |
Payment Issue | Credit Card Declined, Refund Not Received, Double Charge |
Feature Request | New Integration, UI Enhancement, Report Customization |
Without map dependency
Without configuring a map dependency, the Sub-Issue picklist would always display all available options - regardless of the selected Issue Type. For example, users might see options like Forgot Password, Double Charge, and Report Customization all at once. This can easily confuse users and lead to incorrect selections, such as choosing Double Charge under Login Issue.With map dependency
With mapping dependencies, you can guide users to make correct selections by showing only the relevant options in the child field based on the option selected in the parent field.Mapping picklist options in UI
- Go to Setup → Customization → Modules and Fields.
- Select the desired module. In this case, Support Cases.
- Click the ⋯ (more) icon next to the module name.
- Select Map Dependency Fields.
- On the Map Dependency Fields page, click the New button to create a new dependency.
- Choose the Parent Field and Child Field you want to map.
- Click Next button.
UI options mapping viewMapping picklist options via API
- Modules Metadata API - To know the API name of the module.
- Endpoint: GET - /settings/modules
- Here, the API name of the Support Cases module is Support_Cases.
- Layouts Metadata API - Since dependencies are layout-specific, this API helps you identify the layout ID and all the available picklist fields for mapping. It also provides detailed metadata such as the layout ID, field IDs, and the corresponding picklist value IDs.
- Endpoint: GET /settings/layouts?module=Support_Cases
Create Dependency using the POST Map Dependency
{ "map_dependency": [ //Array that contains one or more dependency mappings { "parent": { // Mandatory - Represents the parent picklist "api_name": "Issue_Type", //Mandatory - API name of the parent field "id": "5725767000007985243" // Mandatory - Unique ID of the parent picklist }, "pick_list_values": [ //Mandatory - List of parent picklist values and their corresponding child mappings { "display_value": "-None-", "maps": [ { "display_value": "-None-", "actual_value": "-None-", "id": "5725767000007985204" } ], "actual_value": "-None-", "id": "5725767000007985249" }, { "display_value": "Login Issue", "maps": [ { "display_value": "Forgot Password", //Label shown in the UI for the parent value "actual_value": "Forgot Password", //Actual stored value of the parent picklist option "id": "5725767000007985185" //Mandatory - Unique ID of the parent picklist option }, { "display_value": "Account Locked", "actual_value": "Account Locked", "id": "5725767000007985187" }
], "actual_value": "Login Issue", //Actual value of the parent field's option "id": "5725767000007985242" //Mandatory - Unique ID of the parent field's option }, { "display_value": "Payment Issue", "maps": [ { "display_value": "Credit Card Declined", "actual_value": "Credit Card Declined", "id": "5725767000007985191" }, { "display_value": "Refund Not Received", "actual_value": "Refund Not Received", "id": "5725767000007985193" }, { "display_value": "Double Charge", "actual_value": "Double Charge", "id": "5725767000007985195" } ], "actual_value": "Payment Issue", "id": "5725767000007985244" }, { "display_value": "Feature Request", "maps": [ { "display_value": "New Integration", "actual_value": "New Integration", "id": "5725767000007985197" }, { "display_value": "UI Enhancement", "actual_value": "UI Enhancement", "id": "5725767000007985199" }, { "display_value": "Report Customization", "actual_value": "Report Customization", "id": "5725767000007985201" } ], "actual_value": "Feature Request", "id": "5725767000007985246" } ], "child": { //Mandatory - Represents the child field "api_name": "Sub_Issue", //Mandatory - API name of the child field "id": "5725767000007985186" //Mandatory - Child picklist field ID } } ] } |
{ "map_dependency": [ { "code": "SUCCESS", "details": { "id": "5725767000008174001" }, "message": "map dependency created", "status": "success" } ] } |
Retrieve the configured field mappings using the GET Mapped Dependency Fields API
{ "map_dependency": [ { "parent": { "api_name": "Issue_Type", "id": "5725767000007985243" }, "internal": false, "active": true, "id": "5725767000008180001", "source": 1, "category": 0, "pick_list_values": [ { "display_value": "-None-", "maps": [ { "display_value": "-None-", "actual_value": "-None-", "id": "5725767000007985204" } ], "actual_value": "-None-", "id": "5725767000007985249" }, { "display_value": "Login Issue", "maps": [ { "display_value": "Forgot Password", "actual_value": "Forgot Password", "id": "5725767000007985185" }, { "display_value": "Account Locked", "actual_value": "Account Locked", "id": "5725767000007985187" }, { "display_value": "2FA Not Working", "actual_value": "2FA Not Working", "id": "5725767000007985189" } ], "actual_value": "Login Issue", "id": "5725767000007985242" }, . . . ], "child": { "api_name": "Sub_Issue", "id": "5725767000007985186" } } ] } |
Update the existing mapped options using the PUT Mapped Dependency Fields API
{ "map_dependency": [ { "parent": { "api_name": "Issue_Type", "id": "5725767000007985243" }, "pick_list_values": [ { "display_value": "-None-", "maps": [ { "display_value": "Login Issue", "maps": [ { "display_value": "Forgot Password", "actual_value": "Forgot Password", "id": "5725767000007985185" }, { "display_value": "Account Locked", "actual_value": "Account Locked", "id": "5725767000007985187" }, { // mapped a new option to the existing mapping "display_value": "2FA Not Working", "actual_value": "2FA Not Working", "id": "5725767000007985189" } ], "actual_value": "Login Issue", "id": "5725767000007985242" } ], "child": { "api_name": "Sub_Issue", "id": "5725767000007985186" } } ] } |
Delete existing dependency using the DELETE Mapped Dependency Fields API
{ "map_dependency": [ { "code": "SUCCESS", "details": { "id": "5725767000008174001" }, "message": "map dependency deleted", "status": "success" } ] } |
Assigning picklist values using the Insert Records API
{ "data" : [ { "Name" : "Support Case 1", "Support_Case" : "Login Issue", "Issue_Type" : "Login Issue", "Sub_Issue":"Forgot Password" } ] } |
FAQs
- Map picklists within the main form, or
- Map picklists within the same subform.
Topic Participants
Subramanian K
Sticky Posts
Kaizen #152 - Client Script Support for the new Canvas Record Forms
Hello everyone! Have you ever wanted to trigger actions on click of a canvas button, icon, or text mandatory forms in Create/Edit and Clone Pages? Have you ever wanted to control how elements behave on the new Canvas Record Forms? This can be achievedKaizen #142: How to Navigate to Another Page in Zoho CRM using Client Script
Hello everyone! Welcome back to another exciting Kaizen post. In this post, let us see how you can you navigate to different Pages using Client Script. In this Kaizen post, Need to Navigate to different Pages Client Script ZDKs related to navigation A.Kaizen #210 - Answering your Questions | Event Management System using ZDK CLI
Hello Everyone, Welcome back to yet another post in the Kaizen Series! As you already may know, for the Kaizen #200 milestone, we asked for your feedback and many of you suggested topics for us to discuss. We have been writing on these topics over theKaizen #197: Frequently Asked Questions on GraphQL APIs
🎊 Nearing 200th Kaizen Post – We want to hear from you! Do you have any questions, suggestions, or topics you would like us to cover in future posts? Your insights and suggestions help us shape future content and make this series better for everyone.Kaizen #198: Using Client Script for Custom Validation in Blueprint
Nearing 200th Kaizen Post – 1 More to the Big Two-Oh-Oh! Do you have any questions, suggestions, or topics you would like us to cover in future posts? Your insights and suggestions help us shape future content and make this series better for everyone.
Recent Topics
Age Calculation
I've attempted to calculate the age of someone based on their birthday input by using the formula field. It works but I don't want all those decimals on there. I then tried to use "set variable" after birthday input but I get a field type mismatch, long vs. floating. Any ideas would be wonderful.Search on Custom Field
We're working on an integration with the Zoho FSM API and are trying to retrieve companies based on a custom field we added to the Companies module. However, we can't find a way to filter or query records using custom fields through the API. We have aSendmail function / custom action?
I've setup a function hoping to email various business departments the details of a record once all work in that record is complete so gone about setting up a custom action in such way that each record line on the report has a button to click. Question is how do I actually include data from that record in the email that is sent when the button is clicked? I had thought that since this were being sent per record the email would include the data which had been enteredAPI to post drafts for social media
I we want to post draft posts to our zoho social account and then approve and schedule them within Zoho social. is this possible with for example: https://apis.zoho.com/social/v2/post TIA JonWhat impactful sales coaching techniques have you used to boost your team's performance?
I'm curious about the real-world impact of sales coaching on team performance. What specific techniques or strategies have you found most effective in driving consistent improvement and growth in your sales team? Any success stories or lessons learnedAdding Taxes to paid consultations in Zoho Bookings
I created a 'paid' consultation under Zoho Booking and integrated it with payment gateways for online/instant payment before a booking is done. How can I add 'taxes' to the price of consultation? I can add taxes to other Zoho apps (liks Books, Checkout,Possible to bold or indent text in the description field?
As part of one item, I often have a detailed description that would be much easier to read if there was the ability to have a bulleted list or bold text and the like. Is this possible? My last invoicing software allowed markup in the field so, for example, an asterisk meant a bullet. I haven't been able to find any documentation related to this. Any information would be appreciated. Thank you.Formatting of Balance Sheet and Profit & Loss Reports
The default format of the Balance Sheet and P&L Reports are based on the Account Types and then the individual accounts within the Chart of Accounts. These are then ordered alphabetically under these sub-headings and one is unable to re-order these orUK MTD reports concerning turnover and cerash accounting
Hi I am a sole trader, and I have just started with Zoho Books in order to comply with the new HMRC requirements. I use 'cash basis' - which I understand to mean that income is when the cash comes in (not the invoice date) and expenses are when they areRetainer Invoice.
Why ZOHO not have facilities to deduct partially advance payment from an invoice.Share saved filters between others
Hi, I am in charge to setup all zoho system in our company. I am preparing saved filters for everybody, but the only one can see its me. How can others see it? ThanksKanban view on Zoho CRM mobile app!
What is Kanban? The name doesn't sound English, right? Yes, Kanban is a Japanese word which means 'Card you can see'. As per the meaning, Kanban in CRM is a type of list view in which the records will be displayed in cards and categorized under the givenPresenting ABM for Zoho CRM: Expand and retain your customers with precision
Picture this scenario: You're a growing SaaS company ready to launch a powerful business suite, and are looking to gain traction and momentum. But as a business with a tight budget, you know acquiring new customers is slow, expensive, and often deliversNo practical examples of how survey data is analyzed
There are no examples of analysis with analytics of zoho survey data. Only survey meta data is analyzed, such as number of completes, not actual analysis of responses, such as the % in each gender, cross-tabulations of survey responses. One strange characteristicZoho Creator as LMS and Membership Solution
My client is interested in using Zoho One apps to deploy their membership academy offer. Zoho Creator was an option that came up in my research: Here are the components of the program/offer: 1. Membership portal - individual login credentials for eachAdding Chargebee as a Data Connector
Is it possible to get Chargebee added as a Zoho Analytics data connector?Webform & spam
Hi, We set up 2 webform on our website, fowarding the content to Zoho CRM. Since it has been opened up, we are getting lot of spam message (for now about 20 a day). To lower the amount of false new leads we added the captcha field and new enquieries are send to the Approval Leads list. However we still get some spam. Is there any "anti spam" mechanism built in Zoho CRM, or how is the best way to avoid these kind of spam ? ThanksDropbox to Workdrive
Namaste, Trust you all are doing well. Wanted to check how this can be done with Zoho flow. I typically receive dropbox links from my clients. Is there a way where I can provide the link to Zoho flow and it downloads the files from dropbox link to a workDeals by Stages Funnel not showing in correct order
Using the Stage-Probability Mapping for the Deals module we have created a steps our deals will pass through, RFQ, Closed/Lost, Declined/No-Go, Pricing, Submitted, Negotiations, Won. However when I view the Deal By Stages Funnel it does not show in theConfirmation prompt before a custom button action is triggered
Have you ever created a custom button and just hoped that you/your users are prompted first to confirm the action? Well, Zoho knows this concept. For example, in blueprint, whenever we want to advance to the next state by clicking the transition, it isHow to create auto populate field based on custom module in Zoho CRM?
Hello, i'm still new to Zoho CRM and work as administrator in my company. Currently, I'm configuring layout for Quotes Module. So, the idea is, I've created a read-only field in Quotes called "Spec". I want this field automatically filled with SpecificationRich Text For Notes in Zoho CRM
Hello everyone, As you know, notes are essential for recording information and ensuring smooth communication across your records. With our latest update, you can now use Rich Text formatting to organize and structure your notes more efficiently. By usingOffice 365 and CRM mail integration: permission required
Has anyone run into this weird problem? My email server is Office 365. When I try to configure Zoho CRM to use this server, a Microsoft popup window opens requesting user and password. After entering that, I get a message in the Microsoft window sayingTables improvement ideas / features
Heya, I've been using Zoho Tables for a few months now and wanted to post some features that I think will be greatly beneficial for the tool: 1. Ability to delete a record in automation or move a record in automation. - Usecase: I move a record from oneDeluge - Can't get phone number SalesIQ
Hey folks, I’m building a custom plug for SalesIQ that’s supposed to register leads into Zoho CRM. The SalesIQ chat is being implemented on WhatsApp, and in my plug I’m using this line: mobile_clean = session.get("phone").get("value"); From what I understand,Zoho Desk - Community
As a regular user of Zoho Cares Community I would really love to see the publish date of articles. For example, when I look at Announcements, it would be very beneficial to see which ones were posted recently, over those which have just and a recent comment.access to quartz for my customers
Hi how can I have access to the application quartz you use for us to send you screen rocording, this feature would be immensely useful for our customers support https://quartz.zoho.com/Issue with Inline Images in Email Reply via Zoho Desk API
Hi, I am attempting to send inline images in an email reply using the Zoho Desk API, but the images are not being displayed inline for the recipient. I have followed this documentation: https://desk.zoho.com/DeskAPIDocument#Uploads https://desk.zoho.com/DeskAPIDocument#Threads#Threads_SendEmailReplyHow to search a value stored in a subform?
Hello, We store serial numbers in subforms but now we would like to be able to search the values to be able to easily find the record with the serial number. I saw that it's not possible to search such values through global search but is it possible to do it an other way? Thank you,Field Dependency Not Working on Detail Page in Zoho Desk
Hi Support Team, I’ve created field dependencies between two fields in Zoho Desk, and they are working correctly on the Create and Edit layouts. However, on the Detail page, the fields are not displaying according to the dependencies I’ve set — they appearHow do the keyword critera work?
Hi, I'm working on automated assignment of tickets based on keywords. How does this feature work? Where does this criteria look for keywords - email address, subject, email body? Can you please clarify this as I want to avoid overlapping with criteriaError: Unsupported content type: text/html;charset=UTF-8 after tryeing to get the token for n8n automation
I am working on ZOHO Desk automation and need to get the ZOHO auth token for n8n I have created the app in ZOHO Desk API, got client id and client secret. Added all data required to get a token in n8n. After I sign in with my ZOHO credentials in ZOHOImproving Collaboration Features in Zoho Portal
Hello Zoho Community, I’ve recently started exploring Zoho services and I’m really impressed with the wide range of features. However, I feel there is still room for improvement in the collaboration area. For example, it would be really helpful if weAutomated Shopify Emails Not Being Delivered
I have an ecommerce store with Shopify. I recently set up my email to be served through Zoho. Since doing this, customers are not receiving some of our automated emails from Shopify itself. Our initial email that confirms their purchase goes through but our Shipping Notification that is automatically sent out upon fulfillment is not going through. Sometimes we get a notice that it's been classified as spam, sometimes nothing. I can send/receive email via Outlook on my desktop and I can send/receiveSend a campaign to one recipient.
Very often I speak to a customer and they say they didn't see my email (maybe it went in Junk, maybe they deleted it). Anyway, I just want to go into the Campaign and send it to one person. You already have a feature very close to this - when sending a Test. While developing a campaign, I can send tests to anyone. Why can't we have this AFTER the campaign has been sent? I know, there's a caveat, and that's in the use of merge tags. Most of the time I only use FNAME, but maybe you could check ifTry FSM again for our business
We already have our customers individual equipment in CRM with serial numbers, install dates, warranty length and importantly next service which is generally 2 years. a month before the service date is due we get get a report and send out service reminders.Get Cliq Meetings in my O365 calendar
Hi, we are currently evaluating to replace the Teams Messaging and Meetings with Cliq. We currently still have all our email and calendars in O365. What i want to achieve is, to create a (ZOHO) meeting from Cliq and have this meeting added to my Outlook/O365Issue with Zoho Help Portal – Tickets Missing or Not Answered
Hi, How are you? I think there may be an issue with the Zoho Help Portal. I opened a few tickets directly in the help portal a some time ago but never received any response I also opened ticket 148356451 by email. I did receive a reply to it, but theDUNS & Bradstreet and Credit risk monitoring integration with Zoho books
Small businesses not being paid by bigger clients and clients of all sizes is a huge problem. It will be nice if Zoho develops integration with DUNS & Bradstreet(D&B) and Credit risk monitoring integration with Zoho books. That have small businesses canZoho Forms - Form Rules based on attachment fields
Many businesses use forms to collect documents and images from customers. In many cases, you may want to trigger a notification or other automation based on whether or not an attachment was added. I've noticed that attachment fields do not appear in RulesNext Page