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

![](https://3028830514-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUSRPWcyYI4YAL7ad9DIS%2Fuploads%2F0v2Y8LfRS2Gp4TxmjMrw%2Fimage.png?alt=media\&token=9340cd32-0dfb-43f2-be9c-13648463109c)

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

![](https://3028830514-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUSRPWcyYI4YAL7ad9DIS%2Fuploads%2F9wxVVkFfUwLJoEWVYfn7%2Fimage.png?alt=media\&token=eed8a6ea-0fe1-41d5-93ef-03ec066481fe)

6\. Add a **label** to display in the form

![](https://3028830514-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUSRPWcyYI4YAL7ad9DIS%2Fuploads%2F8Ew3xjHoqgiflFjOVGhT%2Fimage.png?alt=media\&token=0a717c31-0658-4027-90b4-48bfdcd866c9)

7\. Add a **field** name

![](https://3028830514-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUSRPWcyYI4YAL7ad9DIS%2Fuploads%2FDpCZEBRSy3kjMwn3Jb6Q%2Fimage.png?alt=media\&token=41c7b4c4-3005-431a-94d2-77b8b369c995)

{% 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.

![](https://3028830514-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUSRPWcyYI4YAL7ad9DIS%2Fuploads%2FKMUfmiuRrhzYa0sYlUGy%2Fimage.png?alt=media\&token=f4c7358e-6005-4ef4-8987-6ac129c5e7e0)

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

![](https://3028830514-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUSRPWcyYI4YAL7ad9DIS%2Fuploads%2FQ6Lj8KXCP4D7ClWc3cIC%2Fimage.png?alt=media\&token=deba7877-0f3d-4651-ac0e-08663e1d4455)

5\. Click on **Add option**

<div align="left"><img src="https://3028830514-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZBdfBopGpRCzwVbHAR%2F-MZBherR_nCCxnrQCuW5%2Fimage.png?alt=media&#x26;token=fed25eda-baba-4ed1-9f49-b1bb7414bb39" alt=""></div>

6\. Enter an option **Name**

<div align="left"><img src="https://3028830514-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZBdfBopGpRCzwVbHAR%2F-MZBilGHheGwXYdbtmyr%2Fimage.png?alt=media&#x26;token=f9b7ccf3-5518-4090-ba18-a3eff08da699" 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 %}

![](https://3028830514-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUSRPWcyYI4YAL7ad9DIS%2Fuploads%2FhWlIRiFD0wx8vGYWF9OW%2Fimage.png?alt=media\&token=081a7bcd-1c25-4682-bc1c-ae2729161e24)

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

![](https://3028830514-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUSRPWcyYI4YAL7ad9DIS%2Fuploads%2FzCexkfAQoEbyeXrqs9AU%2Fimage.png?alt=media\&token=b868cdc8-3b8e-4d6c-b17f-82c5ddf5ff1d)

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

![](https://3028830514-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUSRPWcyYI4YAL7ad9DIS%2Fuploads%2FLvme2FbJKLIvGp6hUAcF%2Fimage.png?alt=media\&token=8cba3b0a-3667-4017-a23a-3a28b22f406a)

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

### ![](https://3028830514-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUSRPWcyYI4YAL7ad9DIS%2Fuploads%2FXvyG5D7GyN2DCqOnvf2k%2Fimage.png?alt=media\&token=41215c75-b30d-4927-ad5e-1cac1c48c825)

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

![](https://3028830514-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUSRPWcyYI4YAL7ad9DIS%2Fuploads%2F70oe7VkPVN6zG81n215j%2Fimage.png?alt=media\&token=7a99ebb9-a5cb-43f5-9a39-8fd2d83c5037)

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

![](https://3028830514-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUSRPWcyYI4YAL7ad9DIS%2Fuploads%2FPbbsC6BmaHkYTmPX4Cf3%2Fimage.png?alt=media\&token=7e1a7b88-252b-4fb0-805f-61e9d633006e)
