Fields that store information in the database:– string
The basic properties of the fields are described on the page Fields. Below is a description of the specific properties for each field.
When you enable the filter by string with the "Tags" subtype, a window is used to select the values, in which all the tags that appear in all records of the object are listed. The window contains an internal filter for tag names. Records are selected by logical OR.
In the Link form, the original value may be redefined when creating the record.
If two or more text fields are placed on the tab, then when auto-sized, their height fills the free space in equal proportion.
In the Composite field formula, template functions can be used, except those who work with files and images.
When the fields that are included in the formula are changed, the field value is recalculated automatically.
The "Apply" button is used to update all records in the object.
In the Link form, the receipt of data from the child list can be redefined, but at the same time updating the data in the object by the button is blocked.
In the Link form may be:
|Operations and functions||Description|
exponentiation (degree may be fractional)
the integer part of the number (without rounding)
fractional part of the number with the specified number of digits after the decimal point (the result is an integer)
module (absolute value)
change the date to the number of days specified in the argument (if the new date value does not have a valid value, then the nearest date is returned)
change the date to the number of months specified in the argument
change the date to the number of years specified in the argument
The degree, precision or argument can be: field / number / calculation.
For fields, it is allowed to use links to fields of an object of any nesting depth.
In the formula of the Calculation field, the use of Date and Time fields is allowed. Allowed operations:
[Field] + Number), the result: date / number of minutes;
[Field] - Number), the result: date / number of minutes;
[Field] - [Field]), the result: the number of days / number of minutes.
The number of minutes is calculated by the formula: hours * 60 + minutes.
The formula of the Calculation field allows the use of the system field
[~ today], which is replaced in calculations for the current date. When you first open the database (or at midnight) in objects that use Calculation fields with the system field
[~ today], the result is recalculated to the current date.
To recalculate all the fields in an object, use the "More" - "Recalc" operation in the object's menu.
To test recalculation with the system field
[~ today], the operation "More" - "Recalc for date" in the object menu is used. If, after using this operation, recalculation to the current date is not made, it will be executed automatically at midnight or at the first launch on the next day.
Additional features in the Link form:
For the string mode, the following characters are allowed as a separator: space, dot, minus, forward slash. The input data is analyzed and the result is shown to the right of the field. Data entry examples:
Input without a separator is also allowed. For correct recognition, it is desirable to indicate 6 or 8 numbers (two or four digits of the year), for example:
In the data mode, to the right of the field there is a button to quickly set the current date.
Changing data in the "calendar" mode is possible using the Up/Down keyboard buttons.
In the Link form, you can set the lower and upper boundaries of the filter by default, differing from the current date by the specified number of days.
For both date fields, you can specify the system field
[~ today]. If it is used, when you open the project for the first time a day (or at midnight), the data of the Period field is recalculated to the current date.
To manually recalculate the data of an object that contains a Period field, use the "More" - "Recalc" operation in the object menu.
In the data mode, for input methods value and string, to the right of the field there is a button to quickly set the current time.
Changing data in the value mode is possible using the Up / Down keyboard buttons.
For the string mode, a space is also allowed as a delimiter.
When editing a record, the button to the right of the field opens a window with a list of records of the source object without details and with installed filters (by default and taking into account the parameters passed). The record is selected by the "Select" button or by double-clicking on the record.
The field of the object link displays the value of the first (key) field of the object.
To delete a value in the object field, use the icon with a cross in the right part of the field.
When viewing data, the button to the right of the field serves to open the source object and go to the selected record. If the record is outside the set filters, a message is issued about this.
To filter records with an undefined (empty) value, the button (« ») is used in the filter. This combination of characters (« ») can be used to set the default value in the filter.
When backlink is established with the second object, when selecting / deleting the link to the record, the link to the record of the given object will change in the record of the second object.
[~user]can be used to set a link to the record of the user logged into the system during multi-user work.
Additional features in the Link form: