question Re: Variable Select box , list collector auto populate in Developer forum

Variable Select box , list collector auto populate

arshad199110 — Wed, 03 Jul 2024 10:30:08 GMT

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?

Re: Variable Select box , list collector auto populate

Rohit99 — Wed, 03 Jul 2024 11:03:21 GMT

Hi @arshad199110 ,

Could you please share respective table names of the fields ?

Thanks,

Rohit Suryawanshi

Re: Variable Select box , list collector auto populate

Slava Savitsky — Wed, 03 Jul 2024 11:19:41 GMT

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.

Re: Variable Select box , list collector auto populate

arshad199110 — Wed, 03 Jul 2024 11:19:10 GMT

@Slava Savitsky Thanks for your reply. We are not trying to use CMN location table here. But if we create a custom table and try to implement this. The display column will be only one , say if it is city. How I can pull continent and country from same table to display it in separate fields?

Re: Variable Select box , list collector auto populate

Slava Savitsky — Wed, 03 Jul 2024 11:22:18 GMT

In your custom table, you need an attribute that would define the type of location (similar to "Location type" in the Locations [cmn_location] table in the base system). This would enable you to filter by that attribute in your reference qualifiers.

Re: Variable Select box , list collector auto populate

Slava Savitsky — Wed, 03 Jul 2024 11:23:08 GMT

By the way, why are you reluctant to use the [cmn_location] table for this?

Re: Variable Select box , list collector auto populate

arshad199110 — Wed, 03 Jul 2024 11:33:25 GMT

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.

Re: Variable Select box , list collector auto populate

Slava Savitsky — Wed, 03 Jul 2024 11:42:03 GMT

Right.

Re: Variable Select box , list collector auto populate

arshad199110 — Wed, 03 Jul 2024 12:31:25 GMT

Client uses location for different purpose. This is just for a catalog they need this logic with limited countries and cities.