Dropdown

Dropdown controls are one of the most popular controls used to select a single value from a list of options. They are often used to set a status, tag records with specific labels or simply pick one value from multiple options.

Dropdowns can be custom (user-driven options) or countries (pre-set list of countries with flags).

Data type: string

Adding a Dropdown control

1. Edit your sheet 2. Click on the Qommentary Form extension 3. Expand Input fields section 4. Click on Add input field

5. Select Dropdown from the dropdown menu

6. Add a label to display in the form

7. Add a field name

If database is selected as data connection, then field name must map to destination table column name.

Field name cannot contain spaces.

8. Click on Done

Dropdown input column can now be updated and saved.

Custom dropdowns

If you wish to create dropdowns with custom values, please please follow these steps:

1. Edit your sheet and select the Qommentary Form extension 3. Expand the Input fields section and Dropdown input control 4. Scroll down to Dropdown Type and select Custom from the dropdown menu

5. Click on Add option

6. Enter an option Name

7. Repeat steps 5 and 6 as many times as needed

The custom options are now displayed in the dropdown column

Dimension dropdowns

If you wish to use a field or dimension as the source for your dimension values, please follow these steps:

1. Edit your sheet and select the Qommentary Form extension 2. Expand the Input fields section and Dropdown input control 3. Scroll down to Dropdown Type and select Dimension from the dropdown menu

4. Update the expression with the field name you would like to use

The field dimension values are now displayed in the dropdown column

Country dropdowns

The Dropdown control includes a curated list of countries with corresponding flags which you can use out of the box in your writeback table.

To create a countries dropdown, please follow these steps:

1. Edit your sheet and select the Qommentary Form extension 3. Expand the Input fields section and Dropdown input control 4. Select Countries from the dropdown menu

A full list of countries with flags are now displayed in the dropdown column