> 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-form/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 Form** extension\
3\. Expand **Input fields** section\
4\. Click on **Add input field**

![](/files/guywfEFhHlae55j3UXaD)

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

![](/files/kr09GjNp0AjfrFwJSL8Y)

6\. Add a **label** to display in the form

![](/files/MhlCdejeOpp5jBlDuVDi)

7\. Add a **field** name

![](/files/nxbUmBliG2ajkXKZ84mY)

{% 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/6TYlUK1uyHxztihx18Ez)

### 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 Form** extension\
3\. Expand the **Input fields** 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 Form** extension\
3\. Expand the **Input fields** 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.
