Text

Text controls are ideal for capturing any type of content - from short comments/notes to lengthy narratives.

Data type: string

Adding a Text control

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

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

Text input column can now be updated and saved.

Enabling multi-line text

By default, the Text control displays values in a single line. When multi-line is enabled, users have a larger area to compose their narrative text before saving.

To enable multi-line text, please follow these steps:

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

5. Click on Multi-line button

6. Select an appropriate Text input size which will determine the textarea width

7. Drag and drop the slider handle to set the desired number of text lines to display in the textarea

8. Set the number of lines which should be visible on the table cell before overflowing content is clipped

Adding multi-line text

To add multi-line text to your table, please follow these steps:

1. Load your sheet with a Qommentary Writeback extension 2. Click on a Text control. A textarea will popup.

3. Start typing your text and click on the green tick icon

Text control is updated with new content

Setting a max limit

If you wish to set a limit to the maximum amount of characters that can be typed, please follow these steps:

1. Edit your sheet 2. Click on the Qommentary Writeback extension 3. Expand Input Column section and Text control 4. Locate the Max length property

5. Change the max length to your desired limit