> For the complete documentation index, see [llms.txt](https://knowledgebase.qommentary.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://knowledgebase.qommentary.com/qommentary-writeback/custom-data/adding-input-columns/number.md).

# Number

Number controls accepts whole numbers with decimal formatting options.

**Data type**: `number`

### Adding a Number 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&amp;token=c8a0c47a-fd65-447f-9bcf-fb1394cce274" alt=""></div>

5\. Select **Switch** 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-MZO60vmTRfTYpRCcgsq%2F-MZO7zE8e43sWWWBfIZ0%2Fimage.png?alt=media&amp;token=b0060478-7f77-4421-9409-174956033018" 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-MZO60vmTRfTYpRCcgsq%2F-MZO8goBLcZCT62WrMll%2Fimage.png?alt=media&amp;token=59323552-e3a7-4b62-b7e6-bb9ae77ee8e1" 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-MZO60vmTRfTYpRCcgsq%2F-MZO8plew93goRCXhh7V%2Fimage.png?alt=media&amp;token=b2781d1b-d7c9-45d4-9dd7-dc928d8816dd" 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**

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

![](https://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZO60vmTRfTYpRCcgsq%2F-MZO9P-yd8AKn6LJigMI%2Fimage.png?alt=media\&token=d62c20e7-6c8a-4e05-90a3-682517e62891)

### Integer data types

By default, Number controls are setup as Integers. Integers will accept whole numbers which don't exceed 10 digits and where values lie between -2147483648 and +2147483647.

<div align="left"><img src="https://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZO60vmTRfTYpRCcgsq%2F-MZOB0TkuewXnerGtR7P%2Fimage.png?alt=media&amp;token=c9c90ded-2370-4689-b58b-27d23267a784" alt=""></div>

#### Changing the max integer limit

To customize the maximum amount of digits that can be entered, please follow these steps:

1\. Edit your sheet\
2\. Click on the **Qommentary Writeback** extension\
3\. Expand the **Input Columns** section and **Number** column\
4\. Search for the **Max integer limit** property

<div align="left"><img src="https://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZO60vmTRfTYpRCcgsq%2F-MZOAH_ckLDw9BC9Tqx3%2Fimage.png?alt=media&amp;token=47f1de2f-6aed-4fc8-916a-7039260bd7f7" alt=""></div>

5\. Change the max value

<div align="left"><img src="https://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZO60vmTRfTYpRCcgsq%2F-MZOAWRMgoTzWqYe5Nmd%2Fimage.png?alt=media&amp;token=a8c70a74-ee9d-4a14-9111-d1d9e78ba7c5" alt=""></div>

The Number control will now prevent saving if the value exceeds the limit defined.

### Float data types

Floats will accept whole numbers with decimals and values must not exceed 15 digits.

<div align="left"><img src="https://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZO60vmTRfTYpRCcgsq%2F-MZOBzCQA2O4iZ25L74U%2Fimage.png?alt=media&amp;token=b6815fef-8adc-4434-8d09-ea21951de1ca" alt=""></div>

#### Changing the max digit limit

To customize the maximum amount of digits that can be entered for the whole number part, please follow these steps:

1\. Edit your sheet\
2\. Click on the **Qommentary Writeback** extension\
3\. Expand the **Input Columns** section and **Number** column\
4\. Search for the **Max whole number limit** property

<div align="left"><img src="https://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZO60vmTRfTYpRCcgsq%2F-MZOCNSgqN0XHChkLO2R%2Fimage.png?alt=media&amp;token=443b0922-5fec-4f53-bf9c-15feb2c3871c" alt=""></div>

5\. Change the max value

<div align="left"><img src="https://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZO60vmTRfTYpRCcgsq%2F-MZOCY9Euud86DZSWA6D%2Fimage.png?alt=media&amp;token=b1e6c07c-28fe-4929-a1f9-bc7ab8308b95" alt=""></div>

6\. Change the decimals

<div align="left"><img src="https://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZO60vmTRfTYpRCcgsq%2F-MZOCinpHNR6ZJdHYW5M%2Fimage.png?alt=media&amp;token=db2973f3-82b6-496c-b1c0-c81cc765e0e2" alt=""></div>

The Number control will now prevent saving if the value exceeds the limit defined and will format decimals to the chosen value.
