Number
Number fields are used for inputting and storing numerical data. This field type can be applied in various business scenarios such as financial statistics and inventory management.
Number fields only accept numerical input, including integers and decimals, such as “12”, “3.1415”, etc. The field will automatically filter out any non-numeric characters. Number fields can have range restrictions set to only allow input within specified intervals.
Number fields can be used for sorting and filtering, quickly finding maximum and minimum values. They can also be referenced in formulas for mathematical operations.
Formatting
Number fields support three formatting types, which users can choose according to their needs.
Number
Number
Displayed as regular numbers, such as 1, 2.0
Currency
Currency
Displayed with a given currency symbol, such as $1.00
Percentage
Percentage
Displayed in percentage format, such as 1%. Note that the stored value for 1% is 0.01, for 100% is 1, and percentages can exceed 100%
Precision
The product provides 6 precision levels for users to choose from, ranging from integers to five decimal places.
Display Modes
Number fields currently have 3 display modes.
Default
Default
No special display mode, simply presents the number itself in the cell.
Ring Chart
Ring Chart
Users can choose to display a ring chart, with options to set target value, chart color, and whether to show the number.
Bar Chart
Bar Chart
Users can choose to display a bar chart, with options to set target value, chart color, and whether to show the number.
Formatting can be used not only in number fields but also in formula fields, rollup fields, and references. For details, please see Formatting