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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://knowledgebase.qommentary.com/qommentary-writeback/custom-data/adding-input-columns/number.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
