Choices based on other field in record producer?

[Community Alums]

Hi All,

I have two fields say 'brand' AND 'Region'. I want to populate multiple values in region based on the choice selected in brand and region having bulks of records say(3500). please let me know how to do it.

Region and brands are there in same table only.

Regards,

Anuhya 

[Ratnakar7]

Hi @Community Alums ,

You can use a reference qualifier on the 'Region' field. Here's how you can achieve this:

-->> Open the form design of the table where the fields 'Brand' and 'Region' are located (assuming it's a record producer form).

-->> Edit the 'Region' field and go to the Reference Qualifier section.

-->> Write a script in the Reference Qualifier that filters the 'Region' values based on the selected 'Brand'. The script should return a condition that narrows down the list of 'Region' values.

For example, if the 'Region' and 'Brand' fields are in the same table, you can use a script like this:

javascript:'brand=' + current.brand

This script filters the 'Region' records where the 'brand' field is equal to the selected 'Brand' value.

Note: Replace 'brand' with the actual field name in your table.

-->> Save the form design changes.

If my response was helpful in resolving the issue, please consider accepting it as a solution by clicking on the ✅Accept solution button and giving it a thumbs up 👍. This will benefit others who may have a similar question in the future.

Thank you!

Ratnakar

[Community Alums]

Can you please provide the information in detail with screenshots

[Community Alums]

Can you please provide me the screenshots that will help for me more

[Community Alums]

I have written the script it is not working