Knowledge Base

You can manage dropdown field entities in a datalist using init workflow. You can interlink dropdown fields in the datalist through a special feature of spreadsheet calling a workflow for the dropdown. 

Consider the following example of a datalist with two dropdown fields (Country, City) interlinked to each other.

1. Create a spreadsheet with the following fields: Name, email, country, and city.

2. Create two other spreadsheets, Meta 1 spreadsheet with country names and Meta 2 spreadsheet with country and city names.

3. Connect the Country field in the main spreadsheet to Meta 1 spreadsheet through spreadsheet calling feature.

4. Connect the City field in the main spreadsheet to the workflow created using Meta 2 spreadsheet. The workflow must have an entry block, SS filter block, and a set variable block (output will be an array; key will be same as the column name; array key=value of namespace called “field”, this field will come from entry block).

5. Create a datalist with the main spreadsheet. You can see that the city name changes automatically when the country name is changed.