# 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**

<div align="left"><img src="https://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZCvqSqKXuXT2WpbY2f%2F-MZCx6ezSPuMpGDkleyH%2Fimage.png?alt=media&#x26;token=c8a0c47a-fd65-447f-9bcf-fb1394cce274" alt=""></div>

5\. Select **Text** from the dropdown menu

<div align="left"><img src="https://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZCvqSqKXuXT2WpbY2f%2F-MZCzQxLm0qri0ZeEmpB%2Fimage.png?alt=media&#x26;token=c0a755fe-28e5-4644-b563-1700c9abdc2d" alt=""></div>

6\. Add a **label** to be displayed as a column header

<div align="left"><img src="https://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZD-CaMvGCDI-akxhB-%2F-MZD0d4MuDZhlOxmpczs%2Fimage.png?alt=media&#x26;token=6419eec0-f023-4c35-8823-9d3937c09fe8" alt=""></div>

7\. Add a **field** name

<div align="left"><img src="https://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZD-CaMvGCDI-akxhB-%2F-MZD0qIq01H1TeXz-JxX%2Fimage.png?alt=media&#x26;token=c569f3d9-815e-48ab-83b8-8ec29584444a" alt=""></div>

{% hint style="danger" %}
If database is selected as data connection, then field name **must map** to destination table column name.
{% endhint %}

{% hint style="warning" %}
Field name cannot contain spaces.
{% endhint %}

8\. Click on **Done**

**Text** input column can now be updated and saved.

![](https://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZD-CaMvGCDI-akxhB-%2F-MZD1Y2YHnQeDY44vDwJ%2Fqwr-text-single.png?alt=media\&token=02f9fd9f-1da0-4328-95c5-136ba763f720)

### 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

<div align="left"><img src="https://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZDJXBPujnEslrwotv6%2F-MZD_XVkoDAAZYiMNUP_%2Fimage.png?alt=media&#x26;token=71d14feb-e973-48b0-99c1-3b7173f32ba4" alt=""></div>

5\. Click on **Multi-line** button

<div align="left"><img src="https://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZDJXBPujnEslrwotv6%2F-MZD_yNPX4VnJCHeeXmZ%2Fimage.png?alt=media&#x26;token=b6aa7b4e-28b3-4bd8-b504-0131a41c01cb" alt=""></div>

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

<div align="left"><img src="https://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZDJXBPujnEslrwotv6%2F-MZDaTxshENmPkEIcORM%2Fimage.png?alt=media&#x26;token=579feb9d-8c6b-4707-afe5-795aafb4da35" alt=""></div>

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

<div align="left"><img src="https://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZDJXBPujnEslrwotv6%2F-MZDasV0ZfRP3q3WOGHp%2Fimage.png?alt=media&#x26;token=49dae3ff-f57c-4d1c-8e08-3adefcdf7510" alt=""></div>

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

<div align="left"><img src="https://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZDJXBPujnEslrwotv6%2F-MZDbFWITWEtkwLz1W-e%2Fimage.png?alt=media&#x26;token=a8a3471c-add7-44e1-b738-d59939bb7e57" alt=""></div>

### 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.

![](https://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZDc50aZdxZ5eib9GNN%2F-MZDdEGmZMNy_fZjNoM_%2Fimage.png?alt=media\&token=00b88b3c-d06e-4863-9f2c-8391a98358bf)

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

![](https://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZDc50aZdxZ5eib9GNN%2F-MZDdkR3ky6dJiUihC7H%2Fimage.png?alt=media\&token=9e13ac83-9c2e-454f-a8ce-8734ccfde3fe)

{% hint style="success" %}
Text control is updated with new content
{% endhint %}

![](https://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZDc50aZdxZ5eib9GNN%2F-MZDe-F1Dk1-JHIeM6Ft%2Fimage.png?alt=media\&token=e2a8b241-f541-44db-844e-3758f8efe455)

### 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

<div align="left"><img src="https://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZDeOP-w_Uu-RVX1s1V%2F-MZDemrNA6NkrbYiJX7j%2Fimage.png?alt=media&#x26;token=32b15c9f-b011-40d1-af3f-cce5e128a2b9" alt=""></div>

5\. Change the max length to your desired limit

<div align="left"><img src="https://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZDeOP-w_Uu-RVX1s1V%2F-MZDfGlLdlix_zzgvzeT%2Fimage.png?alt=media&#x26;token=5edfbcd8-676b-4d8d-85bd-84f244bf661b" alt=""></div>

### 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

<div align="left"><img src="https://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZDJXBPujnEslrwotv6%2F-MZDMKp4nLaBy5IYUHON%2Fimage.png?alt=media&#x26;token=fc4479d8-ee70-43c1-976e-9abc55bedcad" alt=""></div>

5\. Drag the slider to adjust the column width

<div align="left"><img src="https://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZ90EIKtNZ2VjrnYFQ-%2F-MZAAMpAXfEWAmU2bfz4%2Fimage.png?alt=media&#x26;token=bb9af150-f97d-49bc-a18f-ca1faf5dd7b2" alt=""></div>

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

<div align="left"><img src="https://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZ90EIKtNZ2VjrnYFQ-%2F-MZAAZ3qrMZoe0U7VUxs%2Fimage.png?alt=media&#x26;token=be40bae3-ecea-4aef-acae-9db423ae5c82" alt=""></div>
