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

5. Select Number from the dropdown menu

6. Add a label to display in the form

7. Add a field name

If database is selected as data connection, then field name must map to destination table column name.

Field name cannot contain spaces.

8. Click on Done

Number input column can now be updated and saved.

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 [phone].

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

5. Change the max value

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.

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

5. Change the max value

6. Change the decimals

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