Form Elements
The SimpleOne system stores all the form views created, along with the specified elements of these layouts.
When SimpleOne administrators create or change form layout views, the system stores all these changes in the tables listed below:
- Form View (sys_ui_form)
- UI Form Element (sys_ui_form_element)
- Form Section Element (sys_ui_form_section)
- Related List (sys_ui_related_list)
- Related List Element (sys_ui_related_list_element)
It is not recommended to delete the Default views and sections of the list and form layouts.
Form View
System name: sys_ui_form
Description: This table contains form view configurations. It consists of the following fields:
| Field | Mandatory | Description |
|---|---|---|
| Table | Y | Reference to the Table (sys_db_table) dictionary, the title of the table that is the parent for the view. |
| User | N | Reference to the user, owner of the form. If user = null, then the view is shared. |
| Title | Y | The view title. The value must be unique for the selected table. |
UI Form Element
System name: sys_ui_form_element
Description: The table contains configuration records of section elements. It consists of the following fields:
| Field | Mandatory | Description |
|---|---|---|
| Form split element type | N | This column stores information about the kind of an element. If it is a break-up element, it specifies the type:
|
| Column | Y | Reference to the Column (sys_db_column) column that is the form section element. |
| Position | Y | The element position inside the section. |
| Form section | Y | Reference to the Form Section Element (sys_ui_form_section) record. The Display Name of the section that is the parent for the element. |
| Formatter | N | This column stores the formatter name and shares info about the element: whether the element is a widget and what kind of widget it is. |
Form Section Element
System name: sys_ui_form_section
Description: The table contains configuration records of form section views. It consists of the following fields:
| Field | Mandatory | Description |
|---|---|---|
| Form | Y | Reference to the Form View (sys_ui_form) record. A form view that is the parent for the section. |
| Position | N | The tab order on the form view. The first section is general and will not be a tab. |
| Title | Y | The title of the form. |
Related List
System name: sys_ui_related_list
Description: This table contains configurations of the related lists. See Related Lists to learn more. It consists of the following fields:
| Field | Mandatory | Description |
|---|---|---|
| Title | Y | The related list title. |
| Table | Y | Reference to the Table (sys_db_table) record. The Display Name of the table that is the parent for the related list. |
| User | N | Reference to the user, owner of the related list. If user = null then the list is shared. |
| Form | N | Reference to the Form Views (sys_ui_form) record. A form view that is the parent for the related list. |
Related List Element
System name: sys_ui_related_list_element Description: This table contains configurations of the elements of the related lists. It consists of the following fields:
| Field | Mandatory | Description |
|---|---|---|
| Title | Y | The related list element title. |
| Related list | Y | Reference to the Related List (sys_ui_related_list) record. The Display Name of the related list that is the parent for the element. |
| Related table | N | Reference to the Table (sys_db_table) record. |
| Related column | N | Reference to the Column (sys_db_column) record. |
| Related list script | N | Reference to the Scripted Related List (sys_related_list_script) record. See Scripted Related Lists to learn more. |
| Order | Y | The order of the element. |
Formatters
A formatter is a form element used for displaying information that is not a record field. You can add formatters to a form while configuring a form.
In SimpleOne, the most common formatter is implemented – the Activity formatter. It displays the list of activities on a task form.
To set up a formatter, complete the steps below:
- Navigate to System Settings → UI formatter
- Click New and fill in the fields.
- Click Save or Save and exit to apply the changes.
UI formatter form fields
| Field | Mandatory | Description |
|---|---|---|
| Name | Y | Specify a formatter name. |
| Active | N | Select this checkbox to activate the formatter. |
| Table | Y | Specify a table where the formatter should be used (for example, Task). |
| Type | N | Only the Formatter option is available in the "out-of-the-box" solution. |
| Formatter | N | Select a predefined formatter template. |