Map Dependency Fields in Zoho CRM using APIs
Welcome back to another week of Kaizen!
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
LinkedIn Chrome Extension
Hello - I believe it is a known issue that the LinkedIn extension Resume Extractor has stopped working and they are working on potential fixes. Wondering how others users are finding this issue and if there are any better workarounds for this issue? ItAdvance PDF creation from CRM data
I'm trying to create a PDF export of data in the CRM. My problem is I want a pretty complicated format for the data. I'm trying to export multiple modules worth of data, with nested one-to-many relationships between the modules. Along with that, I wantSub-Form Padding in CSV Export
Hi, When you use the Sub-Form, and for example you have a Date Field on the Main Page, then Option 1 and Option 2 fields on the Subform, when you export this to CSV the Date column will only have the Date in 1 row, the first row, it would be nice to padMore Formula Functions
Hi, I would like for example to be able to have a Date Field and Formula Fields, and then in the Formula Fields I would like to grab just the Month of the above Date Field or the Week Number of the above Date Field. So more "Functions" than the currentFile upload size limits
I am designing a contact form in Zoho Creator with File upload facility. I am not sure where and how to set the following properties for the same: Allowed File Types Maximum Size of the Attachment Number of AttachmentsComposite Services and Account Tracking
I am looking to garner support/request the ability to make composite services. A quick search in the forums brings up multiple requests for this feature. I fail to see why an item is mandatory while services are optional. I also would like to see theAll operation codes getting Not applied in WO-TT22J1025WOR0471, SR-TT22J1025PRE0423,FOR VIN-W1K6G2AB2SL005130.
Dear Support Team, Please refer attached screenshot. All operation codes getting not applied in work order. Request you to please check and update ASAP.Bank Receipt Catagorization
Hi, how can I match a bank deposit to multiple customer's invoices ? For e.g. A single person paid to us on behalf of different five customers. I need to keep the separated invoices for each customerExclude Segment from Campaign Recipients
I've created two Segments in order to separate Non-Marketing Contacts from Marketing Contacts. I'd like to send an Eblast to all Marketing contacts in my lists, but when I go to select Recipients, I have two options: 1. To Choose Lists to Send to; 2.Reschedule Multiple/Mass Calls at Once
When we go into a Call record, we have the option to "Reschedule Call." How can we select multiple Calls at once from the Activities tab and Reschedule them? The big use case for us: We have many leads that our reps are supposed to call on a daily basis.Option to Empty Entire Mailbox or Folder in Zoho Mail
Hello Zoho Mail Team, How are you? We would like to request an enhancement to Zoho Mail that would allow administrators and users to quickly clear out entire folders or mailboxes, including shared mailboxes. Current Limitation: At present, Zoho Mail onlyI want to Make the due date of the project appears automatically
hello everyone I want to know if the zoho projects app can add automatically the END DATE of the project I added the duration, start after dates of each tasks in the project template & the starting date of the project itself and the end date of it doesn'tDrag 'n' Drop Fields to a Sub-Form and "Move Field To" Option
Hi, I would like to be able to move fields from the Main Page to a Sub-Form or from a Sub-Form to either the Main Page or another Sub-Form. Today if you change the design you have to delete and recreate every field, not just move them. Would be nice toGet Zoho Mail API working (including DRE Connector, Oauth Token, ZUID, ZOID & ACCOUNT_ID)
Disclaimer: I’m not a professional coder! Do you need to use Zoho Mail API? Me too. It lets you do all sorts of things — like reading the complete header of an email, or forwarding an email with its attachments — which is what I wanted to do. But settingDeluge Tips & Tricks: Mastering dates and times
Hello everyone! We're bringing back our Deluge Tips & Tricks series, where we show you how to make the most of Deluge for achieving a wide range of use cases. Working with dates and times is a fundamental part of almost any business application. WhetherAdding a Button in a Form in Zoho Creator App
Hi I want to know how can I add a Button in Zoho Creator form. I have options that I select from a multiselect options and I want the button to add those selected options in a Subform. I do not want to add on a Page Builder I want it inside a specificFeature Enhancement Request – Text Formatting Options in Item Description (Zoho Books/Quotes Module)
Dear Zoho Development Team, Greetings from Radiant360 Integrated Technical Services LLC. We would like to bring to your attention a functional limitation we've encountered within the Item Table / Quote Description section of Zoho Books (and Zoho CRM Quotes).Internal Exception for Creator function
I have been running a script successfully for several days using the scheduler in my application. Now today it suddenly creates and Internal Exception error. Nothing has changed about the script. The data is still retrievable from the web service it is using. Why would this suddenly be happening for no apparent reason? Also noticed that my usage logs are not up to date. Is something changing behind the scenes?How to Set Up a Custom Domain and Customize Homepage
Hello, I am experimenting with Zoho Creator to build applications for my own use case and have encountered a couple of issues: 1. Custom Domain Access: Is it possible to access my Zoho Creator application through a domain that I own? If so, how does theAnnouncing new features in Trident for Mac (1.26.0)
Hello everyone! Trident for macOS (v1.26.0) is here with new updates to securely manage your passwords, locally save your emails, and protect against emails with suspicious URLs. Let's take a quick look at them. Manage passwords with Zoho Vault eWidget.Default Value on a Number
Hi, I would be nice to also be able to set the Default Value for a Number Field, not just the Initial Value shown, so if not on the screen so not enetred it can have a value of 0 for example. Thanks DanHaving trouble fetching contents of Zoho Connect Feeds using the API, requesting alternative API documentation.
I'm trying to retrieve feed/post data from Zoho Connect using the API but facing challenges with the current documentation. What I've tried: OAuth authentication is working correctly (getting 200 OK responses) Tested multiple endpoints: /pulse/nativeapi/v2/feeds,Tip#45: Custom Tags and Cluster Tags
Tagging your work items helps categorize and label work items within your Zoho Sprints workspace. Now, this feature is expanded across multiple modules, along with the introduction of cluster tags that offer an advanced tagging mechanism. Manage TagsExtensions 101 webinar series: Build, integrate, and monetize with extensions
Attention developers! Are you ready to take your extension development skills to the next level? We're excited to bring back the Extensions 101 webinar series with an expanded lineup of Zoho products and an introduction to more platform features. LastWhen using "locations" in zoho books, can you keep the two locations totally separate from each other?
I am looking to add a location but I don't want to intermingle the banking or other accounts. I want that to be like two separate independent branches that use different banking accounts, accounts payable, and accounts receivable. The people who are in[Free Webinar] User Management in Zoho Creator - Creator Tech Connect
Hello Everyone! We welcome you all to the upcoming free webinar on the Creator Tech Connect Series. The Creator Tech Connect series is a free monthly webinar that runs for around 45 minutes. It comprises technical sessions in which we delve deep intoA couple of minor enhancements to Workflows
Last updated on September 17, 2024: These enhancements were initially available for early access, and we've now enabled them for all users. We are elated to announce a couple of enhancements to custom functions in our Workflows! Say hello to: "Source"Business Continuity - Disaster Recovery
I know about the Zoho CRM backup .zip files, however, this doesn't include any of the infrastructure with like custom fields or custom modules. I am curious on what everyone has in place for a true backup or what your plan is if your Zoho instance wereFree webinar alert on October 16 - Less Complexity, More Security: Workplace + Directory
Hello Zoho Workplace Community! Security and productivity shouldn't be at odds—and with Zoho, they're not. Discover how Zoho Workplace + Directory delivers seamless collaboration with enterprise-grade security, all in one integrated ecosystem. Join ourNarrative 11: Are your customers happy?
Behind the scenes of a successful ticketing system: BTS Series Narrative 11: Are your customers happy? Happiness isn't just something you experience; it's something you remember. Hear your customers' voices by enabling customer happiness ratings in ZohoDon't understand INVALID_REQUEST_METHOD when I try to post up an attachment
When I make the POST request (using python requests.post() for files): https://www.zohoapis.com/crm/v8/Calls/***************01/Attachments I get this response: r:{ "code": "INVALID_REQUEST_METHOD", "details": {}, "message": "The http request method typeSignature field is showing black
Hello, When customer signed the service form, it is showing as below picture Phone model: iPhone 16 Pro We tried delete and install application, but it not solved. This has on phone of a few person. There is any advice to solve this?Zoho CRM Android app updates: record sharing, user image upload, Zoho Survey integration, and more
Hello everyone, We've made some important improvements to Zoho CRM's Android app, and we'd like to walk you through the latest updates. Here's what's new: Record sharing with org users User image upload Zoho Survey integration support Venue preferenceHow to Delete/hide Google adwords section from Layout?
Hi people, maybe someone can tell me how to remove or hide the Google adwords section from my layout? Im not using it and it takes too much space.WIDGET in related record list ZOHO CRM; how to get and put data to subform custom fields?
he need: Read and write two custom subform line-item fields on Quotes: Segment_wyceny (picklist/text) and W_pakiecie (number). Write works; read does not return these fields via SDK. Environment Zoho CRM Widget Zoho Embedded App SDK v1.2 Module: QuotesIntroducing Assemblies and Kits in Zoho Inventory
Hello customers, We’re excited to share a major revamp to Zoho Inventory that brings both clarity and flexibility to your inventory management experience! Presenting Assemblies and Kits We’re thrilled to introduce Assemblies and Kits, which replaces theWay to update CRM records in quik view
I have custom module in zoho crm and that module have 500 records. I want a quick way or UI so that user can easily update the record information in quick view without going to record detail view or edit view. I tried zoho sheet option but in zoho sheetWriter sing up problom
Zoho writer sing up prolom faceWhere to integrate Price Book and Product List Price
Hello, We sync zoho crm all modules with all data to zoho analytics. In zoho crm, we have "Price Books" and "Products" modules, where each product is assigned to a few price books with different list prices. From zoho crm, I am able to export a datasetForm / CRM Integration Not entering into workflow
I have a simple form setup with company name, first name, last name and lead source. Each of the fields are mapped to CRM Leads module. When the form is submitted, the lead is populated properly. I also have a workflow created that when the lead sourceNext Page