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
6. Select a Color
7. Check Show tooltip if you wish to display a tooltip for this color

8. Alternatively, you may provide a custom Tooltip text
Once applied, tooltip is displayed on hover
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
Last updated
Was this helpful?