Variable Select box , list collector auto populate

[arshad199110]

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? 

[Rohit99]

Hi @arshad199110 ,

Could you please share respective table names of the fields ?

Thanks,

Rohit Suryawanshi

[Slava Savitsky · Accepted solution]

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.

[arshad199110]

@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? 

[Slava Savitsky]

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.