- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-16-2024 02:15 AM
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-16-2024 01:03 PM - edited 08-16-2024 01:08 PM
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:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-16-2024 03:49 AM
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.
Blog: https://sys.properties | Telegram: https://t.me/sys_properties | LinkedIn: https://www.linkedin.com/in/slava-savitsky/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-16-2024 01:03 PM - edited 08-16-2024 01:08 PM
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: