Page History

The SimpleOne system stores all the list and form views created, along with the specified elements of these layouts.

Tip
Role required: admin.

When SimpleOne administrators create or change form layout views, the system stores all these changes in the tables listed below.

Deleting

Manage view items

Use these system tables if you want to delete manage forms, lists, sections, and other elements of the records view created:

List View

UI List Column

Form View

UI Form Element

Form Section

Related List

Related List Element.

Note
It is not recommended to delete the Default views and sections of the list and form layouts.

List elements

When SimpleOne administrators create or change list layout views, the system stores all these changes in the tables listed below.

List View

System name:

Form View (sys_ui_

list.

Description: This table contains configurations of list views of the tables. It consists of the following fields:

Field

Mandatory

Type

Description

TitleYStringThe view title.FormNReferenceReference to the Form View

form)
UI Form Element (sys_ui_form

) table. A form view that is a parent for the section.

_element)
Form Section Element (sys_ui_form_section)
Related List (sys_ui_related_list)
Related List Element (sys_ui_related_list_element)
UI Formatters (sys_ui_formatter)

Note
It is not recommended to delete the Default views and sections of the list and form layouts.

UserNReferenceReference to the user, owner of the form view. If user = null, then the view is shared.TableYReferenceReference to the Table (sys_db_table) table. The ID of the table that is a parent for the view.

UI List Column

System name: sys_ui_list_column.

Description: This table contains configurations of the columns in list views of the tables. It consists of the following fields:

Field

Mandatory

Type

Description

List

Y

ReferenceReference to the List View (sys_ui_list) table. The ID of the list view that is a parent for the column.ColumnYReferenceReference to the Column (sys_db_column) column. The ID of the column is shown in the list view.OrderYIntegerThe order of the columns.

Form elements

When SimpleOne administrators create or change form layout views, the system stores all these changes in the tables listed below.

Form View

System name: sys sys_ui_form.

Description: This table contains form view configurations. It consists of the following fields:

TypeReference to the Table (sys_db_table) table, the ID of the table that is a Reference to the user, String

Field	Mandatory		Description
Table	Y	Reference	The table that is the parent for the view.
User	N	Reference	The owner of the form. If user = null, then the view is shared.
Title	Y		The view title.

UI Form Element

System name: sys sys_ui_form_element.

Description: A table for configurations of the The table contains configuration records of section elements. It consists of the following fields:

Split Element TypeEnum form___ an : if .Reference ID of the IntegerReferenceString

Field	Mandatory	Type	Description
Form	N	split	element	type	N	This column stores information about the kind of	element	. If it is a break-up element, it specifies the type: begin_split end_split split
Column	Y	Reference to the Column (sys_db_column) column.	The	column that is the form section element.
Position	Y		The element position inside the section.
Form Sectionsection	Y		Reference to the Form Section Element (sys_ui_form_section) table. The ID of the section that is a the parent for the element.
Formatter	N		This column stores formatter 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 sys_ui_form_section.

Description: The table for the configurations of the record view form sections. It contains configuration records of form section views. It consists of the following fields:

Tabs

Field	Mandatory	Type	Description
Form	Y	Reference	Reference to the Form View (sys_ui_form) table. A The form view that is a the parent for the section.
Position	Y	String	The tab order on the form view. The first section is general and will not be a tab.
Title	N	String	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:

StringReference to the Table (sys_db_table) table. ID of the a Reference to the user, If Reference to the Table (sys_ui_form)table. A a section

Field	Mandatory	Type	Description
Title	Y		The related list title.
Table	Y	Reference	The	table that is	the parent for the related list.
User	N	Reference	The owner of the related list.	If user = null then the list is shared.
Form	N	Reference	The 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:

TableReference ID of the is a parent for the ColumnReference to the Column (sys_db_column) column. ID of the related column List ScriptReference ID of the See The elements order

Field	Mandatory	Type	Description
Title	Y	String	The related list element title.
Related Listlist	Y	Reference	Reference to the Related List (sys_ui_related_list) table. The ID of the related list that is a the parent for the element.
Related	table	N	Reference to the Table (sys_db_table) table.	The	table that	contains records for the element.
Related	column	N	Reference	The	column that referenced to other list.
Related	list script	N	Reference to the Scripted Related List (sys_related_list_script)script.	The	related script that creates a list.	See Scripted Related Lists to learn more.
Order	Y	Integer	The elements order.

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	Y	Select a predefined formatter template.

Table of Contents

class	fixedPosition

Page tree

Versions Compared

Old Version 1

New Version Current

Key

Manage view items

List elements

List View

UI List Column

Form elements

Form View

UI Form Element

Form Section Element

Related List

Related List Element

Formatters