Table of Contents
Field: Decimal field
General
The decimal field allows you to store numbers with decimal places. These can be both negative and positive numbers.
Settings
Id
The Id field contains the internal id of the field, this field is read-only and is determined when adding a new field. This value is not returned in the display application.
Field type
The Field type indicates the type of field, this is determined when adding the field. This type cannot be changed after adding it. Each field type has different properties and strongly determines how the field is displayed in the display application.
Name
Via the Name you determine the display name of the field; this name appears frequently in the display application and is used everywhere to indicate this field. This value must not be empty.
Database column
The Database column is the internal column name in the database where the data of the field is stored. This field is read-only and is determined when adding the field. This value is not reflected in the view application.
Entity list header
Via this property you customise the header in the entity list, when this field is empty the Name will be displayed in the header. When this field does contain a value it will be displayed in the header. This can be used, for example, to display a shorter text when the field name is relatively long.
Default column width
Determines the default column width of this field in the entity list. When in the view application this column are added to a filter, the width will initially have this value. Using the button to the right of the input field, you can open a visual designer to determine the width of the column.
Default value
The Default value specifies the default numeric value of this field when adding a new entity. The entity field is immediately populated with this value upon creation, this is also immediately visible in the entity properties window. This value cannot be empty and is 0 by default. In addition, this value must be between the Minimum and Maximum value.
Minimum
Determines the minimum numeric value to be entered. This value must be smaller than the Maximum value.
If you enter the Maximum value for a field while there is already data present in the database for that field, then all values greater than the new Maximum are made equal to the new Maximum. This means your data will be adjusted.
Maximum
Determines the minimum numeric value to be entered. This value must be greater than the Minimum value.
If you enter the Minimum value for a field while there is already data present in the database for that field, then all values smaller than the new Minimum are made equal to the new Minimum. This means your data will be adjusted.
