The Number Field can be used to store whole or decimal numbers. The Number Field is most commonly used to store:
Learn how you can add a new Field in Fusioo. Here are some of the Number Field’s additional options:
Auto increment |
If ticked, a unique number will be generated automatically when a new record is created. When adding a new Number Field, you can choose the increment starting point. When an existing Number Field is set to auto increment, Fusioo will start the auto increment from the largest existing value. |
Default Number | The Default Number (Value) is added automatically when creating a new record. |
Minimum Value | The Minimum Value option is used to set the lowest numeric value that can be entered in the Text Field. |
Maximum Value | The Maximum Value option is used to set the highest numeric value that can be entered in the Text Field. |
Decimal Places |
The maximum number of decimal places allowed. When left empty, only whole numbers will be allowed. |
Unit | A short number description (suffix). For example $, % or Km. |
Format Number | When ticked, this option will format the number according to the User’s culture settings. For example, 150500 may be formatted as 150,500. |
Can be used for searching? | Yes |
Can be used to sort records? | Yes |
Can be used as a Badge Heading? | Yes |
Can be used for grouping in the Kanban Board? | No |
Filtering options |
|
Type above and the results will be displayed here.