- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-03-2024 03:30 AM
I have a requirement like for example having three variables in a catalog.
Continent - Select Box field
Country - List collector field
City - List collector field
continent selection should populate country, user can select multiple countries, country selection should populate city. User can select multiple cities. How to achieve this? Can we do it without custom table? If not what other way to implement?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-03-2024 04:11 AM - edited 07-03-2024 04:19 AM
Assuming that Continents, Countries and Cities are maintained as records in the Location [cmn_location] table, you can connect them via the Parent field to form a hierarchy. Then you would be able to apply reference qualifiers to your list collector variables, so that only records that are children of the Parent selected in the other field are available for selection.
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
07-03-2024 04:33 AM
So basically All regions, countries and cities will be a record in same table. We do the parent mapping between 3 of them. And location type will define their type. Display value column will remain the same.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-03-2024 04:42 AM
Right.
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
07-03-2024 04:23 AM
By the way, why are you reluctant to use the [cmn_location] table for this?
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
07-03-2024 05:31 AM
Client uses location for different purpose. This is just for a catalog they need this logic with limited countries and cities.
