Qommentary
Qommentary Form
Qommentary Form
  • Welcome
  • Getting started
  • Setting up a connection
  • Defining a primary key
  • Adding data to your table
  • WORKING WITH INPUT DATA
    • Adding input columns
      • Text
      • Number
      • Checkbox
      • Dropdown
      • Rating
      • Color picker
      • Date picker
      • Switch
    • Conditional input control
    • Saving and Reset
    • Custom Label
    • Hide label
    • Placeholder text
  • Form Actions
    • Reloading data
  • CUSTOMIZATION
    • Appearance
  • Support
    • Submit a ticket
Powered by GitBook
On this page
  • Adding a Number control
  • Integer data types
  • Float data types

Was this helpful?

  1. WORKING WITH INPUT DATA
  2. Adding input columns

Number

PreviousTextNextCheckbox

Last updated 2 years ago

Was this helpful?

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 +2147483647.

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.