There are two types of objects in the system: tables and columns. Tables consist of columns. Both of these objects can be created via the agent interface.
Role required: admin.
You can create a column in two ways:
- via table forms
- by adding a record to the All Columns table.
Columns can be added only to existing tables.
To create a column via a table form, complete the following steps:
- Navigate to System Definition → All Tables.
- Choose the table you need to add a column to.
- Scroll down to the Related Lists area and select the Column tab.
- Click New and fill in the form.
- Click Save or Save and Exit to apply changes.
To create a column record in the All Columns table, complete the steps below:
- Navigate to System Definition → All Columns.
- Click New and fill in the form.
- Click Save or Save and Exit to apply changes.
Column attributes
| Attribute | Mandatory | Description | ||||
|---|---|---|---|---|---|---|
Table | Y | Specify the table in which the column should be created. If this table has child tables, then this column will also be added to them. This field references to the Tables (sys_db_table) dictionary. | ||||
Column Type | Y | Specify a column type. The column type specifies the type of the data stored. Depending on the type selected, additional tabs or fields may appear on the form (see below). For more information, refer to the Column Types article. | ||||
Title | Y | Specify a column title displayed on the form. It should be sensible and human-readable. You can use Latin or Cyrillic letters, [0..9] numbers and the underscore symbol ( _ ). | ||||
Column Name | Y | System column name. This field is populated automatically depending on the title entered. Latin letters, [0..9] numbers and the underscore symbol ( _ ) are allowed. Column name prefixes are added depending on the circumstances listed below:
| ||||
Comments | N | Put some comments here describing the column. | ||||
Active | N | Select the checkbox to activate or deactivate the column. If unselected, the column will be not visible in the Form Layout or List layout configuration. | ||||
Read Only | N | Select the checkbox to make the field read-only. The Read Only attribute is not available for selection when the Journal Input type is chosen in the Column Type field. | ||||
Mandatory | N | Select the checkbox to make the field mandatory. | ||||
Full Text Search | N | Select the checkbox to make it possible to perform a Global Search against the current column.info Note that after activating this attribute, search indices (records in the Search Indices (sys_search_index) table) for the column will not be created automatically. To create these indices, update the records. | ||||
Display by Ref | N | Enable the attribute Display by Ref, so the column value will be displayed in the reference fields. By default, this attribute is set equal to 'true' for the sys_id column this column contains unique IDs. If a table contains a column that has Display by Ref equal to 'true', the value of this field will be displayed when referencing this table in the Reference field. | ||||
Unique | N | Select the checkbox to forbid to add a new record with a certain value, if a record with the same value already exists. |
Type Specification Tab
In SimpleOne, several column types have an extended attribute set. In addition to the standard field set, these column types demonstrate a dynamic change of the sys_db_column object attribute set depending on its type. Some of these attributes can be defined in the Type Specification tab.
The Choice, Conditions, Reference, List, Image, Template, and Field Name column types have a specific set of fields. See the description in the sections below:
Default Value Tab
The Default Value tab is available for all column types.
| Attribute | Mandatory | Description |
|---|---|---|
Default Value | N | Specify a default value that will be populated automatically to the field when a new record is created. |
Use Dynamic Default | N | Select the checkbox if you want to generate the default value dynamically. |
Dynamic Default | N | This field appears only when the Use Dynamic Default attribute is set to 'true'. Select the script from the Dynamic Default Values (sys_default_value_dynamic) dictionary, so its execution results will be automatically calculated and entered into this field. This value will be the default value for the column specified.
|
Reference Qualifier Tab
The Reference Qualifier tab appears for the following column types:
- Field Name
- List
- Reference.
| Field | Mandatory | Description |
|---|---|---|
Reference Qualifier Type | N | Select the type of reference qualifier. Available options:
|
Reference Qualifier Condition | N | Configure the filters using the Condition Builder. This field appears when the Reference Qualifier Type value is Simple. |
Dynamic Reference Qualifier | N | Select the dynamic reference qualifier from the list. This field appears when the Reference Qualifier Type value is Dynamic. |
Reference Qualifier Fixed | N | Select the checkbox to fix filters in the breadcrumbs of the dictionary when using this field. This functionality will block using the Condition Builder functionality. |
