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 #226: Using ZRC in Client Script
Hello everyone! Welcome to another week of Kaizen. In today's post, lets see what is ZRC (Zoho Request Client) and how we can use ZRC methods in Client Script to get inputs from a Salesperson and update the Lead status with a single button click. In thisKaizen #222 - Client Script Support for Notes Related List
Hello everyone! Welcome to another week of Kaizen. The final Kaizen post of the year 2025 is here! With the new Client Script support for the Notes Related List, you can validate, enrich, and manage notes across modules. In this post, we’ll explore howKaizen #217 - Actions APIs : Tasks
Welcome to another week of Kaizen! In last week's post we discussed Email Notifications APIs which act as the link between your Workflow automations and you. We have discussed how Zylker Cloud Services uses Email Notifications API in their custom dashboard.Kaizen #216 - Actions APIs : Email Notifications
Welcome to another week of Kaizen! For the last three weeks, we have been discussing Zylker's workflows. We successfully updated a dormant workflow, built a new one from the ground up and more. But our work is not finished—these automated processes areKaizen #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 achieved
Recent Topics
IF Statement in Zoho CRM Formula Field
Hi, I am attempting to write a formula field that will give me one result if one statement AND another statement are true, then a different value if the first statement AND a different statement are true, else 0. Stated differently: if account = destinationCRM Percent custom fields: When will it show the % symbol and behave like %?
1. Actually Percent custom fields fail to show the % symbol. 2. When in formulas Percent fields work like number: 100 x 5% = 5 ideal world 100 x 5% = 500 what happens actually 3. When importing Percent fields the % symbol has to be removed and the dataencountering an error when attempting to associate an email with a Deal using the Zoho CRM extension in Zoho Mail.
When I click "Yes, associate," the system displays an "Oops!! Something went wrong" error message. I have attached a screenshot of the issue for reference.Editing the Ticket Properties column
This is going to sound like a dumb question, but I cannot figure out how to configure/edit the sections (and their fields) in this column: For example, we have a custom "Resolution" field, which parked itself in the "Ticket Information" section of this"Total Hours" on Employee Attendance Report
I'm learning that in Zoho jargon, "total hours" does not include paid breaks. Or at least not the way that my setup is working. That seems a little weird to me, since most jurisdictions in the US don't differentiate between time spent on paid break andFixed assets in Zoho One?
Hi, We use Zoho Books and have the fixed asset option in it. I started a trial for Zoho One and I do not see that as an option. Is the books that is part of zoho one equivalent to Zoho Books Elite subscription or is it a lesser version? Thanks, MattIntegration with...
Dear Zoho Commerce team, Please could you consider the integration within Zoho Commerce / Inventory and Qapla'? (https://www.qapla.it/en/) This app is better than Aftership in many ways: - Aftership integration require PRO plan and price start from moreGenerate leads from instagram
hello i have question. If connect instagram using zoho social, it is possible to get lead from instagram? example if someone send me direct message or comment on my post and then they generate to leadAdding 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 functionalityCreate case via email
Good Afternoon, I have just registered and am taking a look around the system. Is it possible to create a case via email. I.e. an employee/client/supplier emails a certain address and that auto generates the case which then prompts a member of staffNeed a Universal Search Option in Zohobooks
Hello Zoho, Need a Universal Search Option in Zohobooks to search across all transactions in our books of accounts. Please do the needful ThanksLocked Notebook
Hi, I hadn't used my Notebook in some time and was refamiliarizing myself with it. I clicked a lock icon and now I can't unlock. When I hit the information or unlock icons I'm taken to a page with the notebook icon and a keyboard. When I type, nothingHide fields only for creation
Hello, I'd like to hide some fields only during the creation of a contact in Zoho CRM. In fact I have some fields that are automatically calculated thanks to an automation, so when my users create a contact I don't want them to fill those fields. I knowIssues with Zoho Sheet in Mac
I have downloaded the Zoho App from App Store but It is failing to Save As, Open & Download Operations. App StoreWeekly Sales Summary
Is it possible to generate a weekly report in Zoho Books to show -$$ amount of estimates generated -# of estimates generated by Salesperson -$$ amount of Sales Orders created -$$ amount of Invoices generatedOpenAPI Specs are just plain wrong
The provided yml files for generating the OpenAPI specs are absolutely riddled with errors and inconsistencies. From missing fields on the objects, to just incorrectly named resource objects. I'm having to go through and manually changing the spec toAdd Account column to Invoice screen
Please show the account column on Invoice creation screen. It is an unnecessary step to have to click add additional info and then select the account for line item. Example : on the bill creation screen when entering description we can easily code it against an account. On the invoice screen it requires additional click. Adding the column on the Invoice screen will make it faster to enter transactions. We currently have 5-6 different accounts that we code line items against, You can imagine the extraCustom Footer – Zoho Writer Document
Hello everyone, I’m having an issue adding a custom footer in a Zoho Writer document. I would like to insert my company information (including a logo + address) in the footer. The problem is that when I add these elements, the main content of my pagesReport grouping
I have added a grouping in a report but it is not working how i had expected. I wanted to group a summary on a field named Size but when i add the grouping the report is still showing me each record and making a summary at the bottom of the report. WhatSocial Media Simplified with Zoho Social: Preview your Instagram grid before posting
For a platform like Instagram that relies on visual appeal, it's important that you plan your image and video content in a way that holds your audience's attention. Planning your grid ahead of time gives you the benefit of understanding how your postsError code 1000
Can you please tell me why the following, occasionally causes this error via the api, not every time ?... zoho.books.updateRecord("salesorders",organizationID,salesorderID,{"template_id":"#################069","custom_fields":[{"label":"DelDate","value":"Tuesday,Spreadsheet View click & focus issue in Arabic (RTL) localization
Hello Zoho Support Team, I am facing an issue in Zoho Creator Spreadsheet View when using Arabic localization (RTL). Scenario: My app supports English (LTR) and Arabic (RTL). I created a Spreadsheet View for a form. In English, everything works correctly.VAT rates - exempt and out of scope
Good Evening, UK based company here. I am a bit confused in respect of setting up VAT rates for exempt goods and services; at present I am simply leaving the VAT rate blank in the transactions in order to prevent any VAT appearing in the VAT return. WhenHow to loop through Multiple Upload and Display Actual File Name
I have been reading the help on the File Upload Control and reviewed the Deluge help on files and I can not figure out how to loop through the uploaded files and do anything but get the automatically created file names. The code below will run but eachabou arattai
I want to use the Arattai app for business purposes, so please convert my account to a business account.I have my own invoice app, and I want to link it with the Arattai app for direct messaging.vendors / customers with 2 different address and gst no
Why can't we have option for more than one address and depending on the state option for more than 1 GST no. ? We have customers / vendors PAN india with different addresses and GST no. for different states.Configurable Zoho Cliq Notifications for Zoho People Alerts
Hello Zoho People Product Team, Greetings and hope you are doing well. We would like to request an enhancement to Zoho People notifications, enabling a native delivery via Zoho Cliq with admin-level control, similar to the notification settings availableOverlapping Reports in Dashboards
It's rare, but occasionally it would be a good feature if I were able to overlap reports, either fully or partially in the Dashboards. Also, then having the ability to move objects to the front or rear, or make them transparent/translucent would be goodLooking back at Zoho Calendar in 2025
Hello Zoho Calendar Community, As we step into a brand-new year, we’d like to take a moment to thank you for being an active and valued part of the Zoho Calendar community. Your trust, feedback, and continued engagement motivate us to keep evolving andThere was an error while connecting to GSTN
I am trying to file GSTR1. Everything flows smoothly until I reach the final step of filing the return. After I enter the PAN and OTP for filing it raises the error "There was an error while connecting to GSTN"Zoho Books Extension: What Happens If Custom Fields Already Exist?
When developing Zoho Books extensions, what happens if the target Zoho Books organization already has a custom field with the same API name as one defined in the extension? I’m asking because we originally created an on-Books version of this functionality,Internal Server Error (500) When Attempting to View Banking Transactions
I am experiencing an Internal Server Error (500) when attempting to view transactions across all of my banking accounts. Despite multiple attempts to resolve this, I have received little more than runaround from support, and the issue remains unresolved.How do I add a blank line to the Organisation Address Format?
I'd like to have my VAT number, for example, shown prominently by having a clear gap between it and the address block above, but any blank lines in the address format get ignored in PDF outputs.Automatic Invoice Number generation for createRecord
Hello, while testing some custom Buttons in my Zoho Books application, I noticed that I get an error that previously did not occur. After some further digging I found that the automatic transaction numbering of invoices no longer work in my organization.Adding number of days to an estimate.
I need both QTY of item and "number of days hire" in my estimates at the line item level. Any clues as to how this is done would be greatly appreciated. It needs to calculate. Thanks JBooks Api: listing expenses created after certain dates
Is there any parameter I can add to the List Expenses endpoint that will let me look up expenses by when they were created?Why can't we change the Account type from an Expense to an Asset?
Like the question. Why in QuickBooks for example if I mistakenly created an account as an expenses and I already captured information in those accounts, I can just change the account type from expense to assetIs it possible to do validation for the Actions added to Reports?
We have an all-around On Validate function that checks all the possibilities before the Created/Edited form submissions. We want to have a button in the report view, so we can change records without entering. We are able to add this button, and it doesAbility to Edit Ticket Subject when Splitting a Ticket
Often someone will make an additional or new request within an existing ticket that requires we split the ticket. The annoying part is that the new ticket maintains the subject of the original ticket after the split so when the new ticket email notificationFunction #11: Apply unused credits automatically to invoices
Today, we bring you a custom function that automatically applies unused credits from excess payments, credit notes, and retainer payments to an invoice when it is created. Prerequisites: Create a Connection named "zbooks" to successfully execute the function.Next Page