Our tables have 3 types of columns that support numerical values:
Number
...
In this field, you can fill in numbers. If you want to sum up all the numbers in the column, select → Sums.
...
To limit the input and set a range between a minimum and a maximum value, click → Manage and choose minimal and maximum value:
...
Decimal Number
In this field, you can insert any decimal number and also sum them. The separator will be chosen according to your selected user language (. vs ,).
...
column.
Decimal number column.
Both columns share the following settings:
an option to limit input by setting up a minimal & maximum value.
minimal column width.
option to make the column mandatory to fill when adding/editing the row.
option to make the column read-only.
option to sum up the column values in an additional row at the end of the table.
define a default value.
configure the tooltip for the column header.
select values alignment: right, left, or centre.
The decimal column includes an additional setting: specifying the number of characters displayed after the decimal point.