Attribute | Description |
---|---|
Table | Specify the table name that will be a parent for this column. This mandatory field is a reference to the Tables dictionary (sys_db_table). |
Column type | Specify a column type. You can read more about types there: Field types. |
Title | A column title displayed on the form. It is preferred to be sensible and human-readable. This field is mandatory. Latin, Cyrillic, [0..9] numbers and the underscore symbol ( _ ) are allowed. |
Column name | A system column name. It is preferred to be human-readable and keep the kind of stored data. Latin letters, [0..9] numbers and the underscore symbol ( _ ) are allowed. |
Active | Select this checkbox, and customizing of this field displayed on the form and list will be possible. |
Read-only | Select this checkbox to make the field read-only. |
Mandatory | Select this checkbox to make the field mandatory. |
Full text search | |
Display by ref | When a record references to another record and the table or column containing this record has the attribute Display by ref equal to TRUE, then the column value will be displayed. By default, this attribute is set to TRUE for the sys_id column (this column contains unique IDs). If a table contains a field that has Display by ref = TRUE, the value of this field will be displayed when referencing this table in the Reference field of the referencing table. |
Unique | When turned on, no way to add a record with a value of this field, if a record with the same value already exists. |
Type specification tab | |
Reference | Reference to a table. This field is mandatory for fields of the reference type (like Reference or List); for these fields, a dictionary containing values for them should be specified, |
Max length | |
Extra attributes | |
Reference Qualifier tab | |
This tab appears when the column has a Reference or List type. For more information, please refer to the Reference Qualifiers article. | |
Default Value tab | |
Default value | Specify a default value that will be populated to the field when creating a new record. This field may be specified by a Javascript scenario as well, or in a case of the reference field, a dynamic qualifier may be used (see the screenshot attached). |
Use dynamic default |
Overview
Content Tools