...
| 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. The column type specifies the type of the data stored, also, depending on the type selected, additional tabs or fields may appear on the form (see below). | ||
| 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 | Set this attribute equal to TRUE to make it possible to perform a Global Search against the current column. | ||
| 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 equal 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 | |||
| Max length | (For the columns that have a String or Text type) Specify a maximum value length for this column. The value length cannot exceed allowable length for the specified data type. | ||
| Extra attributes | By filling this field, you become available to use extended parameters on lists and forms. Some examples:
So, these operators become available to use on the column view. 2. For the Image type columns, you can specify maximum image width and height, like this: This field allows extending column properties compared to the regular. | ||
| 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 | Select this checkbox if you want to generate the default value dynamically. | ||
| Dynamic default | This field appears only when the Use dynamic default attribute is set to TRUE. Select the script from sys_default_value_dynamics dictionary, so its execution result will be automatically calculated and entered into this field; this value will be the default value for the column specified.
| ||
Client-side logic on columns
...