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 Writeback extension 3. Expand Input Column section 4. Click on Add column

5. Select Dropdown from the dropdown menu

6. Add a label to be displayed as a column header

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 Writeback extension 3. Expand the Input Columns 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 Writeback extension 2. Expand the Input Columns 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 Writeback extension 3. Expand the Input Columns 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