Linking combo boxes by database using Filters

In Flokzu you have the possibility to link combo box fields to make your form smarter. The way to achieve this is by using Filters.

The first step to link combo boxes is to create the combo boxes you want to link, e.g. A combo box named 'Country' and another one named 'Cities'.



Once you have done this, you must create a database that contains the respective columns. We will call our database 'Countries and Cities Database'.



Next you must edit the first combo box (Countries) as follows:

Select 'Database' as Data Source.
Clic on 'Click here to edit the settings' and select the database from which you want to extract the information.
Select the first column (Countries) as Values to display in the combo box.
Click on the checkbox 'Do not display repeated values'.

Lastly you must edit the second combo box (Cities) as follows:

Select 'Database' as Data Source.
Clic on 'Click here to edit the settings' and select the database from which you want to extract the information.
Select the second column (Cities) as Values to display in the combo box.
In the Filters tab, select the column whose values you want to take into account to bring the information to the second combo. In this case, it is the 'Countries' column.
Then select 'Equal' as Operation.
Finally, select the 'Country' combo box as Value.

The result is that when the end user chooses the country in the first combo, the second combo will be charged by database with the cities of the corresponding country.

Updated on: 25/10/2019