Switch

Switch controls are ideal for visually indicating mutually exclusive states - such as active/inactive, yes/no.

Data type: boolean

Adding a Switch control

1. Edit your sheet 2. Click on the Qommentary Writeback extension 3. Expand Input Column section 4. Click on Add column

5. Select Switch 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

Switch input column can now be updated and saved.

Customizing column width

Input columns have a set width by default. If you wish to change the column width, please follow these steps:

1. Edit your sheet 2. Click on the Qommentary Writeback extension 3. Expand Input Column section 4. Locate the Column width property

5. Drag the slider to adjust the column width

4. Alternatively, you can enter a specific value in the Custom column width field