You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

AttributeDescription
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.

TitleA 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.

ActiveSelect this checkbox, and customizing of this field displayed on the form and list will be possible.
Read-onlySelect this checkbox to make the field read-only.
MandatorySelect 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.

UniqueWhen 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
ReferenceReference 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
  • No labels