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

![](https://3028830514-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUSRPWcyYI4YAL7ad9DIS%2Fuploads%2FmbK4M28B0nbkPVliUqeh%2Fimage.png?alt=media\&token=957c7f55-2689-43c4-b972-608527abaa7e)

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

![](https://3028830514-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUSRPWcyYI4YAL7ad9DIS%2Fuploads%2FiDKXycudbBL1EzwVhCNE%2Fimage.png?alt=media\&token=9e4adcfe-88ec-4686-9d5f-8ec21d0be569)

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

![](https://3028830514-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUSRPWcyYI4YAL7ad9DIS%2Fuploads%2FeH1grzoTBcztnE61uGB8%2Fimage.png?alt=media\&token=c9c9512a-4cca-4e33-ad33-bef3867b902d)

7\. Add a **field** name

![](https://3028830514-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUSRPWcyYI4YAL7ad9DIS%2Fuploads%2FqgZrDjeCVUjtywMWzofK%2Fimage.png?alt=media\&token=23a04825-7932-4369-95dd-0c6716659d8a)

{% 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://3028830514-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUSRPWcyYI4YAL7ad9DIS%2Fuploads%2Fu3hrxg8B7StCnvOe13bd%2Fimage.png?alt=media\&token=72c65eb6-62e1-45fe-aebc-a83ad6cf6c3e)

### 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://3028830514-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZO60vmTRfTYpRCcgsq%2F-MZOB0TkuewXnerGtR7P%2Fimage.png?alt=media&#x26;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 Form** extension\
3\. Expand the **Input fields** section and **Number** column\
4\. Search for the **Max integer limit** property

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

5\. Change the max value

<div align="left"><img src="https://3028830514-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZO60vmTRfTYpRCcgsq%2F-MZOAWRMgoTzWqYe5Nmd%2Fimage.png?alt=media&#x26;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://3028830514-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZO60vmTRfTYpRCcgsq%2F-MZOBzCQA2O4iZ25L74U%2Fimage.png?alt=media&#x26;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 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="https://3028830514-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZO60vmTRfTYpRCcgsq%2F-MZOCNSgqN0XHChkLO2R%2Fimage.png?alt=media&#x26;token=443b0922-5fec-4f53-bf9c-15feb2c3871c" alt=""></div>

5\. Change the max value

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

6\. Change the decimals

<div align="left"><img src="https://3028830514-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZO60vmTRfTYpRCcgsq%2F-MZOCinpHNR6ZJdHYW5M%2Fimage.png?alt=media&#x26;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.
