No
Bound Choicesbound choices
Field types that do not offer to a user any choices choice options to select from.
| Field Typetype | Description | Scalar Typetype | Value type in script | Length, example, or Example, validation criteria | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Big Integer | It's This is a numeric field type used for the storage of the very huge to store large numbers. Size The size of the data stored is 8 bytes. In SimpleOne, it is displayed as an input field with a numeric value. | int8 | number |
| |||||||||||||||
Days of Week | This field is displayed as a | Days of week | This field is displayed as a drop-down list with checkboxes presenting the days of the week: Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday. Several options can be selected. Technically, the field stores a numeric value or a sum of values. The size of data is 2 bytes. Each day of the week is assigned a value: Monday = 1 For example, if Tuesday (2) and Wednesday (4) are selected, the field value is 6. | int2 | number | Minimum value is 0 (no days are selected). Maximum value of is 127 (all days are selected).
| |||||||||||||
Decimal | This field type implements number implements numbers with up to two digits after the decimal points (for example, 12.34)point. | decimal | number |
| |||||||||||||||
Duration | This | Duration | This field type is used to provide a calculate the duration between two events in milliseconds. It stores an integer number. | int8 | number | The validation Validation processing:
| |||||||||||||
Encrypted Password | This field type is used to provide to provide secure password storage in the a database, with the decoding ability ability (2two-way encryption). Tip | After entering a password and saving the record, the field becomes empty, the password is no longer available on the record form. | varchar | string | This field can contain any characters. The length is limited to 255 characters.
| ||||||||||||||
Float | This field type implements a floating point floating-point number. | float4 | number | Validation criteria:
| |||||||||||||||
HTML | This field type is implemented as a rich text widget. It has various settings which are There are various settings displayed as HTML tags in the a 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 anotherthe other, and vice versa. | text | string | This field can contain any characters and is lengthless unless limited by the Max length attribute.
| |||||||||||||||
Integer | This is a numeric field type. Size of The size of the stored data – 4 is 4 bytes. | int4 | number | The value specified should not exceed this range: [-2147483648 ... +2147483647].
| |||||||||||||||
Journal Input | This field type is used to operate with the comment widget. Due to its featuresspecifics, the field cannot be be read - only. It is implemented as a text area with a placeholder or the a 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. TheThere are two ways to leave a comment using the Journal Input column type:
When comments are added, they are stored in two tables:
Tip |
| text | string | This field can be used to submit any characters and is lengthless unless limited by the Max length attribute. In the database, a journal input column always contains an empty string:
| ||||||||||||||
JSON | jsonb | string | JSON type fields are validated as if they contain a string structured in a JSON way. To learn more about this, please refer to official JSON documentation.
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 | Password | This field stores passwords. It is displayed as an input field. After entering a password and saving the record, the field becomes empty, the password is no longer available on the record form. | varchar
| varchar | string | This field can contain any characters. The length is limited to 255 characters.
| ||||||||||||
Percent Complete | This field type is used to display a task completion rate. | decimal | number | Field validation Validation criteria:
| |||||||||||||||
Phone | This field stores phone numbers | Phone | This field stores a phone number. In the SimpleOne interface, it it is displayed as an input field with the phone number.
| varchar |
| varchar | string | Validation criteria:
| |||||||||||
Script
| This field type is physically implemented as a lengthless text string. In the | Script | This field type is physically implemented as a lengthless text string. In SimpleOneinterface, it is displayed as a CodeMirror widget (JS component that provides ability of the code editing in a browser).
| text | string | This field can contain any characters and is lengthless. It can be limited by the Max length attribute. Automatic script validation during form submission is configured for some fields of the script type.
| |||||||||||||
Small Integer | This is a numeric field type. Size The size of the data stored – two is 2 bytes. | int2 | number | The value specified should not exceed this range: [-32768 ... +32767].
| |||||||||||||||
String | This field type is physically implemented as a string 255 symbols lengthcharacters long. In SimpleOnethe interface, it is displayed as a text input field.
| varchar | stringvarchar | This field can contain any characters and is lengthless. It can be limited by the Max length attribute.
| |||||||||||||||
Text | This field type is physically | Text | This field type is physically textimplemented as a lengthless text string. The memory is allocated dynamically when processing the field. In SimpleOnethe interface, it is displayed as a textarea.
| text | string | This field can contain any characters and is lengthless. It can be limited by the Max length attribute.
| |||||||||||||
Translated Text | This field type allows the | Translated Text | This field type allows the same field to display different content based on the user's chosen language.
| varchar | string | This field can contain any characters and is lengthless. It can be limited by the Max length attribute.
| |||||||||||||
URL | This field type is used to store a URL. | varchar | string | This field can contain any characters. The length is limited to 1024 characters.
|
Choice-like
Fieldsfields
Field types that offer choices choice options to a user and can be filled by selecting a value.
| Field Typetype | Description | Scalar Typetype | Value type in script | Length, example, or Example, validation criteria | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
BooleanTrue/False | This field type implements binary logic (True true or Falsefalse, 1 or 0). In SimpleOne the interface, it is displayed as a checkbox. You can change its default value to TRUE or FALSE by checking or unchecking it. | boolean | to true or false by selectiong or clearing it. | boolean | boolean |
true false | ||||||||||||||||||||||||||||
Choice | This field type implements the choices choice functionality. In SimpleOne the interface, it is displayed as a drop-down list.
| varchar | string | This field can contain any characters. If the string length is not set, it is limited to 80 characters.
| ||||||||||||||||||||||||||||||
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 | string | 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.
| ||||||||||||||||||||||||||||||
Conditions | This field type is used to build AND/OR filters. In SimpleOne interfacethe interface, it is displayed as a filter configuration widget. It stores JSON conditionsJSON conditions. | text
| text | string | The validation criteria are:
| |||||||||||||||||||||||||||||
Date | This field type stores the date in the following format: YYYY-MM-DD to format, within 1 one day, and does not specifying specify the time of the day. Size The size of the data stored is 4 bytes. In SimpleOne the interface, it is displayed as an input field with a date picker.
| date | string | A date must be in the ISO 8601 format:
Date elements are validated to meet the following criteria:
Available characters in this field:
| ||||||||||||||||||||||||||||||
Date/Time | This | Date/Time | This field type stores the timestamp measured in seconds. In SimpleOne the interface, it is displayed as an input field with a date and time picker.
| timestamp | string | 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 the interface, it is displayed as an input field with a date and time picker. This field type is mainly used in Schedulesschedules. In contrast to the Date/Time field type, this field type uses the UTC offset parameter defined in the system timezone.
| timestamp | string | The datetime can be written in 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 UUIDvarious IDs as universally unique identifiers (UUID).
| uuid | string | The validation Validation criteria :
| ||||||||||||||||||||||||||||||
Field Name | This field type is used to store a reference to a column in the a particular table and contains a list of columns in a the referenced table. To specify a reference, please complete the steps below:
| int8 | string | An The input string is validated to ensure that it is a string value.
| ||||||||||||||||||||||||||||||
Image | This field type is used to store uploaded image files in the following formats: .jpeg, .png, .gif, .webp, .bmp, .svg, .ico. In SimpleOne the interface, it is displayed as a file a file upload modal window. | int8 | string | The value specified should not exceed this range: [9223372036854775807 ... 9223372036854775806].
| ||||||||||||||||||||||||||||||
List | This field type is physically implemented as a lengthless can contain a text string of unlimited length. It stores record IDs of the records of the specified table , comma-separated. It and is displayed as a list of record values (which are the references to the record edit pageform). It provides you with the functionality of adding, previewing, and deleting records.
| text | string | The validation Validation criteria :
| Record Class |
| Tip |
|---|
See the Record Class article to learn more. |
- by a comma.
| Panel | ||
|---|---|---|
| ||
166807095216015872,166608269714919765 |
Record Class
This field type is used to label the table to which the specified record is related.
The Record Class field is created for a table once a newly inherited table is created for it. Initially, when creating a new root table (without any parents), the table will not have this field. Type of the stored data is ID. The size of the stored data is 8 bytes.
The value specified should not exceed this range: [100000000000000000 ..
999999999999999999].
Example of usage:
- The Task table and its child table, the Incident table, have several records.
- When you look through a task list, you can find incidents among the mass of the tasks.
- For your purposes, you need to find incidents while being in the Task table context.
- To do this, you can filter these records based on the Record Class field.
- The Record Class field is a system field. It is always read-only and inaccessible for editing.
| Panel | ||
|---|---|---|
| ||
155931135900000084 |
Reference
| Anchor | ||||
|---|---|---|---|---|
|
999999999999999999].
This field type works like an external key and stores the record ID of a record of the specified table. This table must be specified in the Reference IDthe Reference field. It is physically stored as Big Integer.
.
infoIn order to limit the output when referencing
toa field, use the reference qualifiers.
| Tip |
|---|
See the Reference Fields article to learn more please use Reference Qualifiers. |
You can
use this range of whole big
integers: [-9223372036854775808 … 9223372036854775807]
| Panel | ||
|---|---|---|
| ||
155931135900000001 |
Template
This field type allows for 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 in template forms. You can use a range of whole bug integers if required. The field allows for applying stored data to records created from templates.
The elements are objects in the 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 | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
// the following columns of user dictionary are used: username, active, locked_out
{
"1":
{
"156943341303994936": "new_user"
},
"2":
{
"156943341308746896": "1"
},
"3":
{
"155931135900001086": "0"
}
} |
Empty field value:
| Panel | ||
|---|---|---|
| ||
[] |
Time
This field type is used as a time storage. Timezone The timezone is not taken into account. The date is not stored. Size The size of the stored data – 8 is 8 bytes.
| Tip |
|---|
See the the Date and datetime columnsTime 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 ( : ).
| Panel | ||
|---|---|---|
| ||
11:00:54 |
| Table of Contents | ||
|---|---|---|
|