Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
No
Bound Choicesbound choices
Field types that do not offer to a user any choices choice options to select from.
Field |
---|
type | Description | Scalar |
---|
type | Value type in script | Length, example, or |
---|
validation criteria |
---|
Big Integer |
This is a numeric field type used |
to store large numbers. |
The size of the data stored is 8 bytes. In SimpleOne |
, it is displayed as an input field with a numeric value |
. | int8 |
Char
This field type is used for storing symbolic data (for example, hash, ID, UUID, etc.). Size of the data stored is 32 bytes.
In SimpleOne interface, it is displayed as an input field with the symbolic value in it.
Decimal
number |
| ||||||||
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 numbers with up to two digits after the decimal |
point. | decimal | number |
| |||||
Duration | This field type is used to |
calculate the duration between two events |
in milliseconds. It stores an integer number |
. | int8 |
number | Validation processing:
|
|
|
| |||||
Encrypted Password | This field type is used |
to provide secure password storage in |
a database, with the decoding |
ability ( |
two-way encryption). |
Before saving, password encodes basing on one of the encryption algorithm and a random string. Before usage, decoding performs.
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
| |||||
Float | This field type implements a floating-point number. | float4 | number |
Validation criteria:
|
|
|
|
|
|
| |||||
HTML | This field type is implemented as a rich text widget. |
There are various settings displayed as HTML tags in |
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 |
modes are displayed in |
the 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 stored data – 4 bytes.
| |||||
Integer | This is a numeric field type. The size of the stored data is 4 bytes. | int4 | number | The value specified should not exceed this range: [-2147483648 ... +2147483647]. |
Journal Input
| |||||
Journal Input | This field type is used to operate with the comment widget |
. Due to its specifics, the field cannot be read only. It is implemented as a text |
area with a placeholder |
or a field title. |
Expand | ||
---|---|---|
| ||
As a rule, it has the NULL value. When a comment is being added, the field value saves the following data to the sys_activities_stream_field table:
After the comment is saved the field value becomes NULL again. |
JSON
Field content example:
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
{"name":"John", "age":30, "cars": {"car1":"Ford", "car2":"BMW", "car3":"Fiat" } } |
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
Displayed as an input field with password type.
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.
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).
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.
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.
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. To learn more about this field type, please refer to the Translated Text field article.
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.
There are two ways to leave a comment using the Journal Input column type:
When comments are added, they are stored in two tables:
| 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 | This field type is physically stored as 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.
| |||||||||||
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 | 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 | Validation criteria:
| |||||||||||
Phone | This field stores phone numbers. In the SimpleOne interface, it is displayed as an input field with the phone number.
| varchar | string | Validation criteria:
| |||||||||||
Script
| This field type is physically implemented as a lengthless text string. In the interface, 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. The size of the data stored 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 characters long. In the interface, it is displayed as a text input field.
| varchar | string | This field can contain any characters and is lengthless. It can be limited by the Max length attribute.
| |||||||||||
Text | This field type is physically implemented as a lengthless text string. The memory is allocated dynamically when processing the field. In the 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 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 fields
Field types that offer choice options to a user and can be filled by selecting a value.
Field type | Description | Scalar type | Value type in script | Length, example, or validation criteria | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
True/False | This field type implements binary logic (true or false, 1 or 0). In the interface, it is displayed as a checkbox. You can change its default value to true or false by selectiong or clearing it. | boolean | boolean |
| ||||||||||||||
Choice | This field type implements the choice functionality. In 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 the interface, it is displayed as a filter configuration widget. It stores JSON conditions. | text | string | The validation criteria are:
| ||||||||||||||
Date | This field type stores the date in the following YYYY-MM-DD format, within one day, and does not specify the time. The size of the data stored is 4 bytes. In the |
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.
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.
See Choice fields article to learn more.
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 (concised 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.
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.
A date can be written in three different ways:
- YYYY-MM-DD (ISO 8601 format)
- DD.MM.YYYY
- MM/DD/YYYY
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.
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. |
Date Time Specific
This field type stores the timestamp measured in seconds.
In SimpleOneinterface, it is displayed as an input field with a date |
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.
date | string | A date must be in the ISO 8601 format:
|
Date 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.
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. You can see it on the record create/edit page. It is displayed as a text input field with a dictionary button. When pressed, a modal window with two fields is shown:
|
Available characters in this field:
| ||||||||||||||||||||||||||||||||
Date/Time | This field type stores the timestamp measured in seconds. In 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 the 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 | 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:
|
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 | ||
---|---|---|
| ||
00000000-0040-0000-0000-000000000008 |
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 Dictionary 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 the adding, previewing, and deleting records.
The validation criteria are listed below:
- All elements must be separated by a comma.
- The values specified should not exceed this range: [9223372036854775808 ... 9223372036854775807].
Record Class
This field type is meant to signify the table to which the specified record relates.
For more information, please refer to the Record Class article.
|
|
|
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.
Info |
---|
In order to limit the output when referencing to a field, please use Reference Qualifiers. |
| ||||||||||||||||||||||
Document ID | This field type is used to store various IDs as universally unique identifiers (UUID).
| uuid | string | Validation criteria:
| ||||||||||||||||||
Field Name | This field type is used to store a reference to a column in a particular table and contains a list of columns in the referenced table. To specify a reference, complete the steps below:
| int8 | string | 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 the interface, it is displayed as a file upload modal window. | int8 | string | The value specified should not exceed this range: [9223372036854775807 ... 9223372036854775806].
| ||||||||||||||||||
List | This field type can contain a text string of unlimited length. It stores record IDs of the specified table and is displayed as a list of record values (which are the references to the record form). It provides you with the functionality of adding, previewing, and deleting records.
| text | string | Validation criteria:
| ||||||||||||||||||
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. | int8 | string | The value specified should not exceed this range: [100000000000000000 .. Example of usage:
| ||||||||||||||||||
Reference
| This field type works like an external key and stores the record ID of the specified table. This table must be specified in the Reference field. It is stored as Big Integer. In order to limit the output when referencing a field, use the reference qualifiers.
| int8 | string | You can use this range of whole big integers: [-9223372036854775808 … 9223372036854775807]
| ||||||||||||||||||
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 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:
| json | string |
Empty field value:
|
Time | This field type is used as a time storage. |
The timezone is not taken into account. The date is not stored. |
The size of the stored data |
time | string | 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 | ||
---|---|---|
|