I am currently building an employee profile, and I have 1 data type I labelled “country”. What I want to happen is the dropdown of fields, namely, country, city, province, are dependent from one another.
Currently, each city in a province and country is built in the database, individually, I was just wondering if I can make a field for the city which is a list of texts but display it individually when I run the dropdown for the city. I tried it but it shows all cities in the same cells in the database, as well as displayed in 1 and the same dropdown but only separated by a comma.
If you are trying to define a list of options in a dropdown menu where a data source is a list, where in some cases it can be just one piece of data and in other cases it can be multiple pieces of data, separated by a comma. You must configure in the dropdown, the choices style to dinamic choices, the type of choices to text, the choices source to “do a search for: your list: data type” (with sorted option if you want) and in the option caption just the current option.
Thanks mate! I it worked, but I have to figure out how to sustain its dependency from another dropdown since the workflow is: country > province > city.
While I am able to run country to province properly, your solution worked but the filtering seems not to work with it.
Your database is defined as:
country (txt) > province (txt) > city (txt - list)
Right?!
Then, in the city dropdown, you need to use the suggestion I gave to create a list of countries, separated one by one.
The province dropdown list needs to be grouped, to show a list of provinces (unique names).
And you need to use some constraint to filter province by the country, and city by the province.
The city became an independent dropdown on its own but the cities inside a cell, is displayed individually instead being in one row separated by commas
