In SimpleOne, the field is accompanied by a magnifier icon which opens a record picker window and by a plus icon which opens a window for creating a new record in the referenced record.
Creating a new record via a reference column is available on forms and in lists for inline editing.
To create a missing record in the referenced table, perform the following steps:
- Click the plus icon . A modal window will appear.
- Fill in the fields.
- Click Save.
Please note that the new record will be created in the table to which the field references. That is, if we created a custom field called Incident which references the Task table, the record will be created in the Task table, not Incident.
Use the following column types to create a reference:
- Reference
- List.
Please keep in mind the dot-walking limitations for fields of the List type:
For conditions in Condition Builder, the limit is one-level-depth.
- For list views and form views configuring, using dot-walking is not allowed.
Reference | List | |
---|---|---|
Description | References a record in the specified table. It stores the record's ID. | References several records in the specified table. It stores the records' IDs. |
Scalar type | int8 | text |
Validation criteria | The values specified should not exceed this range: [9223372036854775808 ... 9223372036854775807]. | All elements must be separated by a comma without spaces. |
Sometimes, reference columns display record IDs instead of record values. Values cannot be shown because of loops.
For example, a reference column refers to a table with a display_by_ref column. This column can also be a reference one. At some point, the next column may refer to a table that has already been viewed – it means a loop is formed, and it is impossible to identify the displayed value. The shown ID is the way to navigate to the necessary record.
Creating a reference column
Role required: admin.
To create a column of the reference type, complete the following steps:
- Navigate to the System Settings → All Tables.
- Open the table for which you want to create a column.
- Scroll down to the Related Lists area and click on the Columns tab.
- Click New and fill in the fields.
- Click Save or Save and Exit to apply changes.
Tabs specific for the reference column type
Type Specification tab | ||
---|---|---|
Field | Mandatory | Description |
Reference | Y | Define the table to which the field will reference. |
On Delete | N | Select the action to take when the referenced record is deleted. Available options:
|
Reference Qualifier tab See the Reference Qualifiers article to learn more. | ||
Reference Qualifier Type | N | Select the type of the reference qualifier. Available options:
|
Reference Qualifier Condition | N | Configure 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 breadcrumbs. This functionality will block using the Condition Builder functionality. |
- No labels