> 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="/files/-MZCx6ezSPuMpGDkleyH" alt=""></div>

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

<div align="left"><img src="/files/-MZO7zE8e43sWWWBfIZ0" alt=""></div>

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

<div align="left"><img src="/files/-MZO8goBLcZCT62WrMll" alt=""></div>

7\. Add a **field** name

<div align="left"><img src="/files/-MZO8plew93goRCXhh7V" 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.

![](/files/-MZO9P-yd8AKn6LJigMI)

### 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="/files/-MZOB0TkuewXnerGtR7P" 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="/files/-MZOAH_ckLDw9BC9Tqx3" alt=""></div>

5\. Change the max value

<div align="left"><img src="/files/-MZOAWRMgoTzWqYe5Nmd" 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="/files/-MZOBzCQA2O4iZ25L74U" 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="/files/-MZOCNSgqN0XHChkLO2R" alt=""></div>

5\. Change the max value

<div align="left"><img src="/files/-MZOCY9Euud86DZSWA6D" alt=""></div>

6\. Change the decimals

<div align="left"><img src="/files/-MZOCinpHNR6ZJdHYW5M" alt=""></div>

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