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

5. Select Color picker 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

Color picker input column can now be updated and saved.

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

5. Give your color option a Name

Name will be saved in destination table. If no Tooltip text is provided, name will also be displayed in tooltip on color hover.

6. Select a Color

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

If you wish to hide tooltips for all colors, please see Disabling tooltips section.

8. Alternatively, you may provide a custom Tooltip text

Once applied, tooltip is displayed on hover

Tooltip text will override the text provided in the Name field.

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