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.
Enter text in one line. It is possible to set a subtype for specific data with additional functionality.
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 entries of the object are listed. The window contains an internal filter for tag names. Entries are selected by logical OR.
In the Link form, the original value may be redefined when creating the entry.
Enter text in multiple lines.
If two or more text fields are placed on the tab, then when auto-sized, their height fills the free space in equal proportion.
Compiling the value of other fields into one string field.
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 entries 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.
Enter numeric values (integer or floating point). Automatic numbering or duplication of the value of previously entered values is possible.
In the Link form may be:
Calculation based on numerical and other calculation fields. Calculations using date and time fields are also possible.
|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:
Entering a date using a calendar or as a string.
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.
The calculation of the period between two dates in various formats, including the calculation with the system field "today".
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.
Entering time using different methods.
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.
Link to the record of another object with the possibility of one-to-one relationship.
When editing an entry, the button to the right of the field opens a window with a list of entries of the source object without details and with installed filters (by default and taking into account the parameters passed). The entry is selected by the "Select" button or by double-clicking on the entry.
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 entry. If the entry is outside the set filters, a message is issued about this.
To filter entries 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 entry, the link to the entry of the given object will change in the entry of the second object.
[~user]can be used to set a link to the entry of the user logged into the system during multi-user work.
Additional features in the Link form:
Select one value from a predefined list with the ability to add custom icons.
When using the icon display style, only icons without string values are displayed in the object/form entry list.
Icons from Project images must match by name, excluding extension. Valid icon extensions: png / jpg. An empty value or space is allowed in the value list.
In the Form of links, it is possible to override and hide the filter.
Selecting multiple values from a predefined list with filtering based on the principle of AND or OR.
When working with data, the field is a drop-down list in which the required values are checked.
The selected values are listed in the field separated by commas.
Adding a file to the record.
When editing data, the field contains the file name and a button in the right part of the field to open a dialog box for selecting a file.
When viewing the data, on the right side of the tab on which the field is located, space is allocated for placing previews of images or icons with the type of the attached file. This area can be expanded by dragging the separator with the mouse.
Double-clicking on the file icon opens the file in the corresponding application. In the context menu on the file icon, you can open the file with another application, delete and rename the file. The command "File location" is used to open a directory with a file in the system explorer.
For individual work, the attached files are placed in the _files project directory. In multi-user work, the placement depends on the type of project: if the work is carried out only on the local network without Internet connections, the file storage remains in the local folder. If users work with an Internet connection, the files are transferred to Yandex.Disk cloud storage.
The file storage structure is a two-level tree. The names of the first level of directories are internal object IDs, and the names of the second level are the ID of entries in the object. Attached files are placed in second-level directories with the names of entry IDs.
When you open an editable file (.txt, .doc, .xml and others) in network mode, the program monitors changes to the file when it is saved and copies it to the repository.
Execution of one or many predefined commands in the operating system.