dependent choices on catalog variables - dynamic filter

Priyansh_98
Tera Guru

Hi Team,

 

I have a record producer form, where i have to create 3 variables field

 

1. region (one value to be selected) - select box type

2. country (multiple values to be selected) - list collector - referring to company table- (country field)

3, entities(multiple values to be selected) - list collector - referring to company table - (name field)

 

based on region i have to show countries in 2nd field which can be multiple selected,

and based on countries i want to show entities related to country. which also be multiple select type (that is by i want to use list collector type field)

 

i want to know how i can create dynamic filter on these 2 fields (i.e. country and entities)

 

can anyone help me on that..!!!

 

thanks in advance

 

 

 

 

1 ACCEPTED SOLUTION

Jordan Vignoni
Tera Guru

I think the best way would be to create a script include.  You can then call the function in the script include using the reference qualifier.  For example, if your script include is named "regionUtil" and the function is called "getCountries", you would apply this to the reference qualifier for the "Country" variable:

Screenshot 2024-08-16 at 4.06.50 PM.png

View solution in original post

2 REPLIES 2

Slava Savitsky
Giga Sage

List collector variable type is exactly what you need for multi-select. To limit selection options based on the value of another field, you need to use a reference qualifier.

 

Jordan Vignoni
Tera Guru

I think the best way would be to create a script include.  You can then call the function in the script include using the reference qualifier.  For example, if your script include is named "regionUtil" and the function is called "getCountries", you would apply this to the reference qualifier for the "Country" variable:

Screenshot 2024-08-16 at 4.06.50 PM.png