# Color picker

**Color picker** controls are visual cues which can be used as traffic light indicators to tag records with a meaningful color.

**Data type**: `string`

### Adding a Color picker 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 **Color picker** from the dropdown menu

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

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

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

7\. Add a **field** name

<div align="left"><img src="/files/-MZO2b91o3MeNmIJzun9" 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**

**Color picker** input column can now be updated and saved.

![](/files/-MZB8LSaaGzfuUPLm0Vo)

### Adding color options

When you add a Color picker input column, you will be required to add color options.

To add a color option, please follow these steps:

1\. Edit your sheet\
2\. Click on the **Qommentary Writeback** extension\
3\. Expand the **Input Columns** section and **Color picker** column\
4\. Click on **Add option**

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

5\. Give your color option a **Name**

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

{% hint style="info" %}
Name will be saved in destination table. If no Tooltip text is provided, name will also be displayed in tooltip on color hover.
{% endhint %}

6\. Select a **Color**

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

7\. Check **Show tooltip** if you wish to display a tooltip for this color

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

{% hint style="info" %}
If you wish to hide tooltips for all colors, please see Disabling tooltips section.
{% endhint %}

8\. Alternatively, you may provide a custom **Tooltip text**

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

Once applied, tooltip is displayed on hover

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

{% hint style="info" %}
Tooltip text will override the text provided in the Name field.
{% endhint %}

### Disabling tooltips

If you wish to disable tooltips in your color picker control, please follow these steps:

1\. Edit your sheet\
2\. Click on the **Qommentary Writeback** extension\
3\. Expand the **Input Columns** section and **Color picker** column\
4\. Click on the switch control to disable tooltips

<div align="left"><img src="/files/-MZBCNJdVTgR-6VMVVsp" alt=""></div>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://knowledgebase.qommentary.com/qommentary-writeback/custom-data/adding-input-columns/color-picker.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
