> For the complete documentation index, see [llms.txt](https://knowledgebase.qommentary.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://knowledgebase.qommentary.com/qommentary-writeback/custom-data/adding-input-columns/dropdown.md).

# 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**

<div align="left"><img src="/files/-MZCx6ezSPuMpGDkleyH" alt=""></div>

5\. Select **Dropdown** from the dropdown menu

<div align="left"><img src="/files/-MZO4fXlG3YHSNJrDvka" alt=""></div>

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

<div align="left"><img src="/files/-MZO4nOnKLkwe3jB9zPQ" alt=""></div>

7\. Add a **field** name

<div align="left"><img src="/files/-MZO4v2OapPjtEuxkr0X" alt=""></div>

{% hint style="danger" %}
If database is selected as data connection, then field name **must map** to destination table column name.
{% endhint %}

{% hint style="warning" %}
Field name cannot contain spaces.
{% endhint %}

8\. Click on **Done**

**Dropdown** input column can now be updated and saved.

![](/files/-MZBuYDJpuImDndNbNwZ)

### 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

<div align="left"><img src="/files/-MfWwf-wYyXxHoXfiQxr" alt=""></div>

5\. Click on **Add option**

<div align="left"><img src="/files/-MZBherR_nCCxnrQCuW5" alt=""></div>

6\. Enter an option **Name**

<div align="left"><img src="/files/-MZBilGHheGwXYdbtmyr" alt=""></div>

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

{% hint style="success" %}
The custom options are now displayed in the dropdown column
{% endhint %}

![](/files/-MZBj4E0aFBBaCGiOSAA)

### 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

<div align="left"><img src="/files/-MfX02fy0vMNZFch_5WJ" alt=""></div>

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

<div align="left"><img src="/files/-MfX0HFZ5y_43Q4Nu7uS" alt=""></div>

{% hint style="success" %}
The field dimension values are now displayed in the dropdown column
{% endhint %}

![](/files/-MfX1SNB9pEH8eAoYqmD)

### 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

<div align="left"><img src="/files/-MZBrS0WcT1aI6vrKuoA" alt=""></div>

{% hint style="success" %}
A full list of countries with flags are now displayed in the dropdown column
{% endhint %}

![](/files/-MZBru7mzi7Vs3Jae9BL)
