How to display different values in the custom created dropdown field based on the value selected in the another dropdown field (that comes with the application

Hi,

I am new to SuiteCRM and in a learning phase. I am using SuiteCRM 8.9.1. I learned “How to display different values in the custom created dropdown field based on the value selected in the another custom created dropdown field - using “Dynamic Dropdown” concept”. But I want to “display different values in the custom created dropdown field based on the value selected in the another dropdown field (comes with the application. Ex: “Product Category” field in the “Products” module”, “Opportunity”, “Quote Stage” fields in the “Quotes” module", etc)". Could you please guide me on this?

Thank you.

Check out the video:

This video explains “Dynamic Dropdown” option using “Studio”. I already understood this concept. But I want to display different values in the dropdown or dynamic dropdown field (that we create on our own using “Studio”) based on the value selected in the already existing “Product Category” field in “Products” module. I believe this video does not cover my query.

In the “Create Product” page, there is a field called “Product Category” (that comes with the application by default). In the same page, I want to display a new “Dynamic Dropdown” field called “Product Base Name” (that we can create on our own using “Studio”). In the “Product Category” field, we can search the product category records that we have created under the “Product Categories” module and select any one value from it. For each value of the “Product Category” field, I have a different set of options to display in the “Product Base Name” dropdown field. So based on the value selected in the “Product Category” field, I want to display the specific set of options in the “Product Base Name” dropdown field.

Note:
In the “Developer Tools” → “Studio” → “Products” → “Fields” section, For “Product Category” field, below are the basic details I see it:
Date Type = “Relate”
Field Name = “aos_product_category_name”
Module = “AOS_Product_Categories”

In the “Developer Tools” → “Dropdown editor” section, I do not see “AOS_Product_Categories” dropdown as mentioned in the internet search. And I believe that it will not be there because it is not the manually created custom dropdown field.

As I do not have a key, value pair (in suitecrm, it is item name, display label) details for “Product Category” field (“aos_product_category_name”), I am unable to create a “Dynamic Dropdown” field that links to “aos_product_category_name” field as “Parent Category”.

You’re looking for this:


Otherwise check other developer insights on the below page:

Another good method is logic hook: