Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
No Bound Choices
Field types that do not offer to a user any choices to select from.
Field Type | Description | Scalar Type | Length or Example, validation criteria | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
Big Integer | It's a numeric field type used for the storage of the very huge numbers. Size of the data stored is 8 bytes. In SimpleOne, it is displayed as an input field with a numeric value. | int8 |
| |||||||||
Days of week | This field is displayed as a drop-down list with checkboxes presenting days of weeks: Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday. One or more options can be selected. Technically, the field stores a numeric value or a sum of values. Size of data is 2 bytes. Each day of week is assigned with a value: Monday = 1 For example, if Tuesday (2) and Wednesday (4) are selected, the field value is 6. | int2 | Minimum value is 0 (days are not selected). Maximum value of the field is 127 (all days selected). | |||||||||
Decimal | This field type implements number with up to two digits after the decimal points (for example, 12.34). | decimal | ||||||||||
Duration | This field type is used to provide a duration between two events in milliseconds. It stores an integer number. | int8 | The validation processing:
| |||||||||
Encrypted Password | This field type is used to provide secure password storage in the database, with the decoding ability (2-way encryption).
| varchar | This field can contain all kinds of symbols. The length is limited up to 255 symbols. | |||||||||
Float | This field type implements a floating point number. | float4 | Validation criteria:
| |||||||||
HTML | This field type is implemented as a rich text widget. It has various settings which are displayed as HTML tags in the database. When this field is read-only, the data is displayed as HTML; otherwise, it is displayed as text that can be edited and transformed.
Changes made in one of modes are displayed in another, and vice versa. | text | This field can contain all kinds of symbols, and it is lengthless until not limited by the Max Length attribute. | |||||||||
Integer | This is a numeric field type. Size of the stored data – 4 bytes. | int4 | The value specified should not exceed this range: [-2147483648 ... +2147483647]. | |||||||||
Journal Input | This field type is used to operate with the comment widget. It is implemented as a text area with a placeholder or the field title. When comments are added, they are stored in the Activities Stream Fields (sys_activities_stream_field) and in the Activity Feed Items (sys_activity_feed_item) tables. The Activities Stream Fields (sys_activities_stream_field) table stores comments from Activity Feeds that are working within UI formatter. The Activity Feed Items (sys_activity_feed_item) table stores comments for the widget that can be configured via <activityFeed> SimpleTag.
| text | This field can contain all kinds of symbols, and it is lengthless until not limited by the Max Length attribute. | |||||||||
JSON | jsonb | Field content example:
Fields of a JSON type are validating as if they contain a string structured in a JSON way. To learn more about this, please refer to official JSON documentation. | ||||||||||
Password | This field stores passwords. It is displayed as an input field.
| varchar | This field can contain all kinds of symbols. The length is limited up to 255 symbols. | |||||||||
Percent Complete | This field type is used to display a task completion rate. | decimal | Field validation criteria:
| |||||||||
Phone | This field stores a phone number. In SimpleOne interface, it is displayed as an input field with the phone number.
| varchar | Phone validation criteria:
| |||||||||
Script | This field type is physically implemented as a lengthless text string. In SimpleOne interface, it is displayed as a CodeMirror widget (JS component that provides ability of the code editing in a browser).
| text | This field can contain all kinds of symbols, and it is lengthless until not limited by the Max Length attribute. | |||||||||
Small Integer | This is numeric field type. Size of the data stored – two bytes. | int2 | The value specified should not exceed this range: [-32768 ... +32767]. | |||||||||
String | This field type is physically implemented as a string 255 symbols length. In SimpleOne interface, it is displayed as a text input field.
| varchar | This field can contain all kinds of symbols. If the string length is not set, then it is limited up to 255 symbols; otherwise, a limit may be well above. | |||||||||
Text | This field type is physically implemented as a lengthless text string. The memory is allocated dynamically when processing the field. In SimpleOne interface, it is displayed as a textarea.
| text | This field can contain all kinds of symbols, and it is lengthless until not limited by the Max Length attribute. | |||||||||
Translated Text | This field type allows the same field to display different content based on the user's chosen language.
| varchar | This field can contain all kinds of symbols, and it is lengthless until not limited by the Max Length attribute. | |||||||||
URL | This field type is used to store a URL. | varchar | This field can contain all kinds of symbols. The length is limited up to 2048 symbols. |
Choice-like Fields
Field types that offer choices to a user and can be filled by selecting a value.
Field Type | Description | Scalar Type | Length or Example, validation criteria | |||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Boolean | This field type implements binary logic (True or False, 1 or 0). In SimpleOne interface, it is displayed as a checkbox. You can change its default value to TRUE or FALSE by checking or unchecking it. | boolean | true false | |||||||||||||||||||||||
Choice | This field type implements the choices functionality. In SimpleOne interface, it is displayed as a drop-down list.
| varchar | This field can contain all kinds of symbols. If the string length is not set, then it is limited up to 80 symbols. | |||||||||||||||||||||||
Color | This field type is intended to keep and share information about the system color or the color of an interface element. This field type is used, for example, in the Style Rules. | varchar | This field can contain either 4 or 7 symbols (concise or full RGB record) starting with the hash sign (#). Allowed symbols are: numbers, English letters (A to F) and the hash sign. Example: #B80000 | |||||||||||||||||||||||
Conditions | This field type is used to build AND/OR filters. In SimpleOne interface, it is displayed as a filter configuration widget. It stores JSON conditions.
| text | The validation criteria are:
| |||||||||||||||||||||||
Date | This field type stores the date in the following format: YYYY-MM-DD to within 1 day and not specifying the time of the day. Size of the data stored is 4 bytes. In SimpleOne interface, it is displayed as an input field with a date picker.
| date | A date must have the ISO 8601 format:
Date elements are validated to meet the following criteria:
Available symbols in this field:
| |||||||||||||||||||||||
Date/Time | This field type stores the timestamp measured in seconds. In SimpleOne interface, it is displayed as an input field with a date and time picker.
| timestamp | The datetime can be written in the ISO 8601 format as shown below: YYYY-MM-DD hh:mm:ss Datetime elements are validated to meet the following criteria:
| |||||||||||||||||||||||
Date Time Specific | This field type stores the timestamp measured in seconds. In SimpleOne interface, it is displayed as an input field with a date and time picker. This field type is mainly used in Schedules. In contrast to the Date Time field type, this field type uses the UTC offset parameter defined in the system timezone.
| timestamp | The datetime can be written in the ISO 8601 format like shown below: YYYY-MM-DD hh:mm:ss Datetime elements are validated to meet the following criteria:
| |||||||||||||||||||||||
Document ID | This field type is used to store various IDs. Physically they are stored as UUID.
| uuid | The validation criteria are listed below:
| |||||||||||||||||||||||
Field Name | This field type is used to store a reference to column in the table and contains a list of columns in a referenced table. To specify a reference, please complete the steps below:
| int8 | An input string is validated that it is a string value. | |||||||||||||||||||||||
Image | This field type is used to store uploaded image files. In SimpleOne interface, it is displayed as a file upload modal window. | int8 | The value specified should not exceed this range: [9223372036854775807 ... 9223372036854775806]. | |||||||||||||||||||||||
List | This field type is physically implemented as a lengthless text string. It stores IDs of the records of the specified table, comma-separated. It is displayed as a list of record values (which are the references to the record edit page). It provides you the functionality of adding, previewing, and deleting records.
| text | The validation criteria are listed below:
| |||||||||||||||||||||||
Record Class | This field type is meant to signify the table to which the specified record relates.
| int8 | The value specified should not exceed this range: [100000000000000000 .. 999999999999999999]. | |||||||||||||||||||||||
Reference | This field type works like an external key and stores the ID of a record of the specified table. This table must be specified in the Reference ID. It is physically stored as Big Integer.
| int8 | You can use whole big integer range for your purposes: [-9223372036854775808 … 9223372036854775807] | |||||||||||||||||||||||
Template | This field type allows storing a set of column names and their values in JSON format for all tables. Nested JSON format is used. On the first nesting level, the element numbers starting from 1 are used as keys. Because the field type stores data pairs: column name ↔ value, it is commonly used on template forms. The field allows applying stored data to records created from templates. The elements are objects in following format:
This type of field requires populating the Dependent On Column field in the Type Specification tab with the appropriate table. | json |
| |||||||||||||||||||||||
Time | This field type is used as a time storage. Timezone is not taken into account. The date is not stored. Size of the stored data – 8 bytes.
| time | The time can be written in the ISO 8601 format as shown below: HH:MM:SS Time stamp elements are validated to meet the following criteria:
The allowed symbols are numbers and a colon ( : ). |
Table of Contents | ||
---|---|---|
|
No Bound Choices
Field types that do not offer to a user any choices to select from.
Big Integer
It's a numeric field type used for the storage of the very huge numbers. Size of the data stored is 8 bytes.
In SimpleOne, it is displayed as an input field with a numeric value.
- In SimpleOne, this range is used for record IDs: [100000000000000000 …
999999999999999999] - You can use whole big integer range for your purposes: [-9223372036854775808 … 9223372036854775807]
Days of week
This field is displayed as a drop-down list with checkboxes presenting days of weeks: Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday. One or more options can be selected.
Technically, the field stores a numeric value or a sum of values. Size of data is 2 bytes. Each day of week is assigned with a value:
Monday = 1
Tuesday = 2
Wednesday = 4
Thursday = 6
Friday = 16
Saturday = 32
Sunday = 64
For example, if Tuesday (2) and Wednesday (4) are selected, the field value is 6.
Minimum value is 0 (days are not selected).
Maximum value of the field is 127 (all days selected).
Decimal
Duration
The validation processing:
- The input string is categorized by datetime parts (days, hours, minutes, seconds).
- It converts into a total milliseconds amount and saved as a Big Integer number.
Encrypted Password
This field type is used to provide secure password storage in the database, with the decoding ability (2-way encryption).
Tip |
---|
See the Password columns article to learn more. |
Float
Validation criteria:
- Only numbers, a comma and a dot are allowed.
- Maximum string length is 14 symbols.
- Maximum fraction size is 12 symbols (after a delimiter which can be a comma or a dot, depending on a user preferences).
HTML
This field type is implemented as a rich text widget. It has various settings which are displayed as HTML tags in the database.
When this field is read-only, the data is displayed as HTML; otherwise, it is displayed as text that can be edited and transformed.
Info |
---|
When using this field type, there are two modes: rich text editor and source editor. You can enter the source editor by clicking the Source button on the panel.
|
Changes made in one of modes are displayed in another, and vice versa.
Integer
This is a numeric field type. Size of the stored data – 4 bytes.
Journal Input
This field type is used to operate with the comment widget. It is implemented as a text area with a placeholder or the field title. When comments are added, they are stored in the Activities Stream Fields (sys_activities_stream_field) and in the Activity Feed Items (sys_activity_feed_item) tables.
The Activities Stream Fields (sys_activities_stream_field) table stores comments from Activity Feeds that are working within UI formatter.
The Activity Feed Items (sys_activity_feed_item) table stores comments for the widget that can be configured via <activityFeed> SimpleTag.
Tip |
---|
See the Text columns article to learn more. |
Info |
---|
If async after business rules run, you can work with the field values of the Journal Input type in the same way as you do within after rules, when referring to the current context. |
JSON
This field type is physically stored as JSON.
Tip |
---|
See the Text columns article to learn more. |
Field content example:
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
{"name": "White", "color": "#ffffff", "policy": "Open", "sys_id": 158462172516422349, "application_id": 155931135900000002, "sys_created_at": "2020-03-19 12:42:05", "sys_created_by": 155931135900000001, "sys_updated_at": "2020-03-19 12:42:05", "sys_updated_by": 155931135900000001} |
Fields of a JSON type are validating as if they contain a string structured in a JSON way. To learn more about this, please refer to official JSON documentation.
Password
This field stores passwords. It is displayed as an input field.
Tip |
---|
See the Password columns article to learn more. |
Percent Complete
Field validation criteria:
- May contain numbers [0..100].
- Maximum fraction size is 2 symbols.
- Maximum length is 6 symbols.
Phone
This field stores a phone number.
In SimpleOne interface, it is displayed as an input field with the phone number.
Tip |
---|
See the Text columns article to learn more. |
Phone validation criteria:
- May contain: (+-), spaces and numbers.
- Maximum length is 15 symbols.
Script
This field type is physically implemented as a lengthless text string.
In SimpleOne interface, it is displayed as a CodeMirror widget (JS component that provides ability of the code editing in a browser).
Tip |
---|
See the Text columns article to learn more. |
Small Integer
This is numeric field type. Size of the data stored – two bytes.
String
This field type is physically implemented as a string 255 symbols length.
In SimpleOne interface, it is displayed as a text input field.
Tip |
---|
See the Text columns article to learn more. |
Text
This field type is physically implemented as a lengthless text string. The memory is allocated dynamically when processing the field.
In SimpleOne interface, it is displayed as a textarea.
Tip |
---|
See the Text columns article to learn more. |
This field can contain all kinds of symbols, and it is lengthless until not limited by the Max Length attribute.
Translated Text
This field type allows the same field to display different content based on the user's chosen language.
Tip |
---|
See the Translated Text columns article to learn more. |
URL
This field type is used to store a URL.
Choice-like Fields
Field types that offer choices to a user and can be filled by selecting a value.
Boolean
This field type implements binary logic (True or False, 1 or 0).
In SimpleOne interface, it is displayed as a checkbox. You can change its default value to TRUE or FALSE by checking or unchecking it.
true
false
Choice
This field type implements the choices functionality.
In SimpleOne interface, it is displayed as a drop-down list.
Tip |
---|
See the Choice fields article to learn more |
title | More Info... |
---|
For this, supporting fields in the sys_db_column column were implemented. Configuration settings of the items to be selected are located in the sys_choice table. The following types of Choices are available (they vary by Choice Type setting on the column creation form):
- 'None'
- Drop-down with 'None'
- Drop-down without 'None' (must specify a default value).
Tip |
---|
When creating a column you can specify Choice Table and Choice Column. In this case, the Choice Column values will be the options for the values of the specified table in the Choice Table. |
This field can contain all kinds of symbols. If the string length is not set, then it is limited up to 80 symbols.
Color
This field type is intended to keep and share information about the system color or the color of an interface element. This field type is used, for example, in the Style Rules.
This field can contain either 4 or 7 symbols (concise or full RGB record) starting with the hash sign (#). Allowed symbols are: numbers, English letters (A to F) and the hash sign.
Example: #B80000
Conditions
This field type is used to build AND/OR filters.
In SimpleOne interface, it is displayed as a filter configuration widget. It stores JSON conditions.
Tip |
---|
See the Condition columns article to learn more. |
The validation criteria are:
- This field can contain any symbols.
- This field should have the Dependent on column attribute set.
- This field should contain Condition Operators to be a valid condition.
Date
This field type stores the date in the following format: YYYY-MM-DD to within 1 day and not specifying the time of the day. Size of the data stored is 4 bytes.
In SimpleOne interface, it is displayed as an input field with a date picker.
Tip |
---|
See the Date and datetime columns article to learn more. |
A date must have the ISO 8601 format:
- YYYY-MM-DD
Date elements are validated to meet the following criteria:
Element | Range | Comment |
---|---|---|
Day | [01..31] | The value specified should not exceed this range. |
Month | [01..12] | The value specified should not exceed this range. |
Year | [0001..9999] | The value specified should not exceed this range. |
Available symbols in this field:
- Numbers
- Slash ( / )
- Hyphen ( - )
- Dot ( . )
Date/Time
This field type stores the timestamp measured in seconds.
In SimpleOne interface, it is displayed as an input field with a date and time picker.
Tip |
---|
See the Date and datetime columns article to learn more. |
The datetime can be written in the ISO 8601 format as shown below:
YYYY-MM-DD hh:mm:ss
Datetime elements are validated to meet the following criteria:
Element | Range | Comment |
---|---|---|
Second | [00..59] | The value specified should not exceed this range. |
Minute | [00..59] | The value specified should not exceed this range. |
Hour | [00..23] | The value specified should not exceed this range. |
Day | [01..31] | The value specified should not exceed this range. |
Month | [01..12] | The value specified should not exceed this range. |
Year | [1900..2099] | The value specified should not exceed this range. |
Date Time Specific
This field type stores the timestamp measured in seconds.
In SimpleOne interface, it is displayed as an input field with a date and time picker.
This field type is mainly used in Schedules. In contrast to the Date Time field type, this field type uses the UTC offset parameter defined in the system timezone.
Tip |
---|
See the Date and datetime columns article to learn more. |
The datetime can be written in the ISO 8601 format like shown below:
YYYY-MM-DD hh:mm:ss
Datetime elements are validated to meet the following criteria:
Element | Range | Comment |
---|---|---|
Second | [00..59] | The value specified should not exceed this range. |
Minute | [00..59] | The value specified should not exceed this range. |
Hour | [00..23] | The value specified should not exceed this range. |
Day | [01..31] | The value specified should not exceed this range. |
Month | [01..12] | The value specified should not exceed this range. |
Year | [1900..2099] | The value specified should not exceed this range. |
Document ID
This field type is used to store various IDs. Physically they are stored as UUID.
Expand | ||
---|---|---|
| ||
UUID is written as a sequence of hex numbers in lowercase, divided by a minus sign into several groups like this:
It is 32 digits and 128 bits total. When placing on a form, the field of this type is displayed as a reference field. It should contain a reference on a specified column in a specified table. To specify a reference, click on a string or on a magnifier button and select a table and a column.
|
The validation criteria are listed below:
- An input value is validated that its a string value.
- After that, validation is performed according to a predefined pattern like described in a Description column.
Expand | ||
---|---|---|
| ||
0229fa8a-bcbe-1f54-0163-45785d8a0001 |
Field Name
This field type is used to store a reference to column in the table and contains a list of columns in a referenced table.
To specify a reference, please complete the steps below:
- Add this field on the form using the Form Layout functionality.
- Right-click on the field title and select Configure field item.
- Scroll down to the Type Specification tab and specify the referencing table column in the Dependent on Column field.
- Click Save or Save and Exit to save changes.
Image
This field type is used to store uploaded image files.
In SimpleOne interface, it is displayed as a file upload modal window.
List
This field type is physically implemented as a lengthless text string. It stores IDs of the records of the specified table, comma-separated. It is displayed as a list of record values (which are the references to the record edit page). It provides you the functionality of adding, previewing, and deleting records.
Tip |
---|
See the Reference columns article to learn more. |
The validation criteria are listed below:
- All elements must be separated by a comma.
Record Class
This field type is meant to signify the table to which the specified record relates.
Tip |
---|
See the Record Class article to learn more. |
999999999999999999].
Reference
This field type works like an external key and stores the ID of a record of the specified table. This table must be specified in the Reference ID. It is physically stored as Big Integer.
Tip |
---|
See the Reference columns article to learn more. |
Info |
---|
In order to limit the output when referencing to a field, please use Reference Qualifiers. |
Template
This field type allows storing a set of column names and their values in JSON format for all tables. Nested JSON format is used. On the first nesting level, the element numbers starting from 1 are used as keys.
Because the field type stores data pairs: column name ↔ value, it is commonly used on template forms. The field allows applying stored data to records created from templates.
The elements are objects in following format:
- 'key' − the column ID in the Columns (sys_db_column) dictionary
- 'value' − the column value.
This type of field requires populating the Dependent On Column field in the Type Specification tab with the appropriate table.
Code Block | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
// following columns of user dictionary are used: username, active, locked_out
{
"1":
{
"156943341303994936": "new_user"
},
"2":
{
"156943341308746896": "1"
},
"3":
{
"155931135900001086": "0"
}
} |
Time
This field type is used as a time storage. Timezone is not taken into account. The date is not stored. Size of the stored data – 8 bytes.
Tip |
---|
See the Date and datetime columns article to learn more. |
The time can be written in the ISO 8601 format as shown below:
HH:MM:SS
Time stamp elements are validated to meet the following criteria:
Element | Range | Comment |
---|---|---|
Second | [00..59] | The value specified should not exceed this range. |
Minute | [00..59] | The value specified should not exceed this range. |
Hour | [00..23] | The value specified should not exceed this range. |
The allowed symbols are numbers and a colon ( : ).
Table of Contents | ||
---|---|---|
|