How to create a new form field
This is a numeric field type. Its main use is to capture simple numerical values with no special formatting, as you can create your own format. However, you can use either currency or percentage fields instead, just keep in mind that those two fields have a decimal limit of two. You can learn more about them in the following tutorials:
Currency Field
Percentage Field
In this Article:
Configuring a Number Field
Go to Settings > Apps, select the app you'd like to add the field to and select the 'Form Fields' tab.
Give your field a name and add a field hint if desired. You can then select the section in which the field will be created or keep the default option.
The field type must be set to 'Number'.
Now you will see the 'Precision' field. This will set the number of decimal digits that will be stored in the system for your Number Field.
For example, setting the Precision to '2' will store an inputted number to two decimal points. If a number is input as 1.1234, it will still be stored as 1.12. Setting this field to '0' will ensure only the integer is stored.
Leaving the Precision field blank will result in unlimited decimal points being stored.
Note: This field applies only to how real numbers are stored. To change how Number Fields are formatted and displayed, refer to the next section - as this is achieved through a Format Mask
If desired, you can set a default value for all new records. Team members will have the option to override the default value if needed.
Formatting a Number Field
You can use the format mask to change the way the information is presented on your number field to look like currency, percentages, times, or even plain old numbers with decimal places, thousands, and abbreviations, these are some of the available options, to get a full list of all formatting options, please click on the following link: Numeral.JS
| Number | Format Mask | Result |
| 10000 | 0,0.0000 | 10,000.0000 |
| 10000.23 | 0,0 | 10,000 |
| 10000.23 | +0,0 | +10,000 |
| -10000 | 0,0.0 | -10,000.0 |
| 10000.1234 | 0.000 | 10000.123 |
| 100.1234 | 00000 | 00100 |
| 1000.1234 | 000000,0 | 001,000 |
| 10 | 000.00 | 010.00 |
| 10000.1234 | 0[.]00000 | 10000.12340 |
| -10000 | (0,0.0000) | (10,000.0000) |
| -0.23 | .00 | -.23 |
| -0.23 | (.00) | (.23) |
| 0.23 | 0.00000 | 0.23000 |
| 0.23 | 0.0[0000] | 0.23 |
| 1230974 | 0.0a | 1.2m |
| 1460 | 0 a | 1 k |
| -104000 | 0a | -104k |
| 1 | 0o | 1st |
| 100 | 0o | 100th |
Here is an example:
To remove the decimals of a number and add a thousand separators, 10000.23, you will need to input 0,0 in the format mask field. The result will be 10,000.
Currency Formats
| Number | Format Mask | Result |
| 1000.234 | $0,0.00 | $1,000.23 |
| 1000.2 | 0,0[.]00 $ | 1,000.20 $ |
| 1001 | $ 0,0[.]00 | $ 1,001 |
| -1000.234 | ($0,0) | ($1,000) |
| -1000.234 | $0.00 | -$1000.23 |
| 1230974 | ($ 0.00 a) | $ 1.23 m |
Percentage Formats
| Number | Format Mask | Result |
| 1 | 0% | 100% |
| 0.974878234 | 0.00% | 97.48% |
| -0.43 | 0 % | -43 % |
| 0.43 | (0.00 %) | 43.00 % |
Time Formats
Even though it is a number field, it also accepts Time values. If you want to add a formatting mask for them, you have the following options:
| Number | Format Mask | Result |
| 25 | 00:00:00 | 0:00:25 |
| 238 | 00:00:00 | 0:03:58 |
| 63846 | 00:00:00 | 17:44:06 |
Number fields can also be calculated. Just enable the 'Calculated' checkbox and add your custom code in the space available for it.
Enable the 'Required' checkbox if the information for this field is mandatory. It means that if you enable this option, every time a team member creates a new record, they will need to input a number for this field in order to save it.
If you enable the 'Lock After Create' as its name implies, the field will be locked once the new record is saved and the value of the field will not be editable afterward.
Once you are done setting your field, click the save button.
Note: All new fields are added at the bottom of the form.