Color picker
Last updated
Last updated
Color picker controls are visual cues which can be used as traffic light indicators to tag records with a meaningful color.
Data type: string
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.
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.
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
