You are viewing an old version of this page. View the current version.
Compare with Current View Page History
« Previous Version 142 Next »
No bound choices
Field types that do not offer choice options to select from.
Field Type | Description | Scalar Type | Value length or example, validation criteria |
---|---|---|---|
Big Integer | It 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 |
|
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 | Minimum value of the field is 0 (days not selected). Maximum value of the field is 127 (all days selected). |
Decimal | This field type implements numbers with up to two digits after the decimal point (for example, 12.34). | decimal | |
Duration | This field type is used to calculate the 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 a database, with the decoding ability (two-way encryption). Before saving, the password is encoded based on one of the encryption algorithms and a random string. The password must be encoded before it can be used. | varchar | This field can contain all kinds of symbols. The value length is limited 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. 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. There are two modes to use in this field: rich text editor and source editor. You can enter the source editor by clicking Source on the panel. Changes made to one of the modes are displayed in another mode, and vice versa. | text | This field can contain all kinds of symbols, and its length is unlimited until explicitly specified with the Max Length attribute. |
Integer | This is a numeric field type. The size of the stored data is 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. Due to its specifics, the field cannot be read-only. It is implemented as a text area with a placeholder or a field title. There are two ways to leave a comment using the Journal Input column type:
When comments are added, they are stored in two tables:
If async after business rules are 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. | text | This field can contain all kinds of symbols, and its length is unlimited until explicitly specified with the Max Length attribute. |
JSON | This field type stores values in JSON. | jsonb | Field content example: JSON { "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 the JSON type are validated in the same way as fields containing JSON strings. To learn more about this, refer to the 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 value length is limited to 255 symbols. |
Percent Complete | This field type is used to display the work progress in percent. | decimal | Field validation criteria:
|
Phone | This field stores phone numbers. In the SimpleOne interface, it is displayed as an input field with the phone number. | varchar | Phone validation criteria:
|
Script | This field type can contain a text string of unlimited length. In the SimpleOne interface, it is displayed as a CodeMirror widget (JavaScript component that provides the ability to edit code in a browser). | text | This field can contain all kinds of symbols, and its length is unlimited until explicitly specified with the Max Length attribute. |
Small Integer | This is a numeric field type. The size of the data stored is 2 bytes. | int2 | The value specified should not exceed this range: [-32768 ... +32767]. |
String | This field type can contain a string with the minimum length of 255 symbols. 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, it is limited to 255 symbols; otherwise, the limit can be higher or lower. |
Text | This field type contain a text string of unlimited length. The mеmory is allocated dynamically when processing the field. | text | This field can contain all kinds of symbols, and its length is unlimited until explicitly specified with the Max Length attribute. |
Translated Text | This field type allows the same field to display different content based on the user's chosen language. See the Translated Text Fields article to learn more. | varchar | This field can contain all kinds of symbols, and its length is unlimited until explicitly specified with the Max Length attribute. |
URL | This field type is used to store a URL. | varchar | This field can contain all kinds of symbols. The value length is limited to 2048 symbols. |
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 length or example, validation criteria | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Boolean | This field type implements binary logic (True or False, 1 or 0). In the SimpleOne interface, it is displayed as a checkbox. You can change its default value to true or false by selecting or clearing it. | boolean | true false | |||||||||||||||||||||
Choice | This field type implements the choice functionality. In the SimpleOne interface, it is displayed as a drop-down list. See the Choice Fields article to learn more. For this type of fields, supporting fields were created in the sys_db_column table. Configuration settings of the items to be selected are located in the sys_choice table. The following types of choice options are available (they vary by the Choice Type field setting on the column creation form):
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. | varchar | This field can contain all kinds of symbols. If the string length is not set, it is limited 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, when configuring 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 the 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, within one day and without specifiying the time. The size of the data stored is 4 bytes. In the SimpleOne interface, it is displayed as an input field with a date picker. | date | A date must be in 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 the 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 the 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 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 as universally unique identifiers (UUID). A UUID is described as a series of 32 hexadecimal characters separated by hyphens into five groups in an 8-4-4-4-12 pattern:
It is 32 digits and 128 bits total. When appears 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 a string or the magnifier icon | uuid | Validation criteria:
0229fa8a-bcbe-1f54-0163-45785d8a0001 | |||||||||||||||||||||
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 | 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 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 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. See the Reference Fields article to learn more. | text | The validation criteria are listed below:
| |||||||||||||||||||||
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 | 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. See the Reference Fields article to learn more. In order to limit the output when referencing a field, use Reference Qualifiers. | int8 | 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:
This type of field requires populating the Dependent On Column field on the Type Specification tab with the appropriate table. | json |
Template Expand source
// the 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. The timezone is not taken into account. The date is not stored. The size of the stored data is 8 bytes. | time | The time can be written in 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 ( : ). |
- No labels