Dependent Drop-down List

Emanuela Dolce
Emanuela Dolce Active Partner
Second Anniversary First Comment
edited April 2020 in Platform

Hello! Is it possible to create a dependent drop-down list?

I have two text cubes (Contry and City) structured by a dummy entity (a counter) and with data-entry option enabled.

For the first cube the suggested value is the entity country, for the second one the suggested value is the entity city.

If I insert one value in the first cube, is there a way to show as suggested value only the cities related to this country?

image

Answers

  • Graeme Whorrall
    Graeme Whorrall Active Partner
    Fourth Anniversary 10 Comments Board Developer Level 200: Building A Planning Solution in Board

    Hi Emanuela,

     

    can't see a nice way of reducing down the selection list but you can validate that the city is in the country selected else return an error like "city not in the UK" when they try to save it. (rules would be quite long)

     

    Or have it so they select the CITY as an entity which is related to the country and then these can be written to text cubes if necessary. 

     

    Regards

     

    Graeme