Version: 1.23.3

Column Types

No bound choices

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.

Scalar type: int8

Value type in script: number

Length, example, or validation criteria:

In SimpleOne, this range is used for record IDs: [100000000000000000 … 999999999999999999]
You can use the following big integer range: [-9223372036854775808 … 9223372036854775807]

Field content example:

166674708111757858

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 Tuesday = 2 Wednesday = 4 Thursday = 8 Friday = 16 Saturday = 32 Sunday = 64

For example, if Tuesday (2) and Wednesday (4) are selected, the field value is 6.

Scalar type: int2

Value type in script: number

Length, example, or validation criteria: Minimum value is 0 (no days are selected). Maximum value of is 127 (all days are selected).

Field content example:

Decimal

This field type implements numbers with up to two digits after the decimal point, for example, 12.34.

Scalar type: decimal

Value type in script: number

Length, example, or validation criteria:

Field content example:

12.33

Duration

Use this field type to calculate the duration between two events in milliseconds. It stores an integer number.

Scalar type: int8

Value type in script: number

Length, example, or validation criteria:

The input string is categorized by the date and time parts (days, hours, minutes, seconds).
The value is converted into a total number of milliseconds and saved as a Big Integer number.

Field content example:

Encrypted Password

Use this field type to provide secure password storage in a database, with the decoding ability (two-way encryption). Beginning with version 1.23.0, the encryption standard changed from AES-128 to AES-256.

After entering a password and saving the record, the field becomes empty, the password is no longer available on the record form.

note

If you import a SOP file with a previous version of a record or restore a version of a record with the AES-128 encryption, you need to specify the password again and save the record to enable the AES-256 encryption.

Scalar type: varchar

Value type in script: string

Length, example, or validation criteria: This field can contain any characters. The length is limited to 255 characters.

Field content example:

0YATXJjpWt5wFPL6FiKxQA==

Float

This field type implements a floating point number.

Scalar type: float4

Value type in script: number

Length, example, or validation criteria:

Only numbers, a comma and a dot are allowed.
Maximum value length is 14 characters.
Maximum fraction length is 12 digits (after a delimiter that can be a comma or a dot, depending on user preferences).

Field content example:

0.333

HTML

This field type is implemented as a rich text widget. There are various settings 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.

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 in one modes are displayed in the other, and vice versa.

Scalar type: text

Value type in script: string

Length, example, or validation criteria: This field can contain any characters and is lengthless unless limited by the Max length attribute.

Field content example:
<html><head><title></title></head><body><h3>Email body:</h3><p><code>&quot;Hello world!&quot;</code></p></body></html>

Integer

This is a numeric field type. The size of the stored data is 4 bytes.

Scalar type: int4

Value type in script: number

Length, example, or validation criteria: The value specified should not exceed this range: [-2147483648 ... +2147483647].

Field content example:

1211345967

Journal Input

Use this field type 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:

via a journal input field:
1. Enter the text in the field.
2. Click Save or Save and exit.
via the Activity Feed widget:
1. Click the Activity Feed widget.
2. Select the tab representing the message type you need (Work notes or Discussion).
3. Enter your message and send it.

When comments are added, they are stored in two tables:

Activities Stream Fields (sys_activities_stream_field) – comments from Activity Feeds that act as the user interface formatter.
Activity Feed Items (sys_activity_feed_item) – comments for the widget that can be configured via the <activityFeed> SimpleTag.

note

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.
Reports do not support the use of the the Journal Input fields.

Scalar type: text

Value type in script: string

Length, example, or validation criteria: 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:

Field content example:

""

JSON

The fields of this type store data in the JSON format.

Scalar type: jsonb

Value type in script: string

Length, example, or validation criteria: JSON type fields are validated as if they contain a string structured in a JSON way. To learn more about this, refer to official JSON documentation.

Field content example:
{"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}

Password

Use this field type to store 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.

Scalar type: varchar

Value type in script: string

Length, example, or validation criteria: This field can contain any characters. The length is limited to 255 characters.

Field content example:
$2y$13$MtP.z1mkGN.SdrzhzBQQ7.XaXgg58IS/qm2/wwQSeT/B58fxNMQGK

Percent Complete

Use this field type to display a task completion rate.

Scalar type: decimal

Value type in script: number

Length, example, or validation criteria:

May contain numbers [0..100].
Maximum fraction length is 2 digits.
Maximum length is 4 digits.

Field content example:

99.90

Phone

Use this field type to store phone numbers.

In the SimpleOne interface, it is displayed as an input field with the phone number.

Scalar type: varchar

Value type in script: string

Length, example, or validation criteria:

May contain: a (+) plus sign and digits.
Maximum length is 15 characters.

Field content example:

+74951818520

Script

This field type represents 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).

Scalar type: text

Value type in script: string

Length, example, or validation criteria: 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.

Field content example:

// console.log()

Small Integer

This is a numeric field type. The size of the data stored is 2 bytes.

Scalar type: int2

Value type in script: number

Length, example, or validation criteria: The value specified should not exceed this range: [-32768 ... +32767].

Field content example:

String

represents a string 255 characters long by default

In the interface, it is displayed as a text input field.

Scalar type: varchar

Value type in script: string

Length, example, or validation criteria: By default the string contains 255 characters, but you can limit it to any number, both smaller and bigger if you set it in the Max length attribute.

Field content example:
john.doe12

Text

This field type represents a lenghless text string. The memory is allocated dynamically when processing the field value.

Scalar type: text

Value type in script: string

Length, example, or validation criteria: This field can contain any characters and is lengthless. It can be limited by the Max length attribute.

Field content example:
Email body:\n"Hello world!"

Translated Text

This field type allows the same field to display different content based on the user's selected language. Find more information in the Translated Text Fields article.

Scalar type: varchar

Value type in script: string

Length, example, or validation criteria: This field can contain any characters and is lengthless. It can be limited by the Max length attribute.

Field content example:

Send email

URL

Use this field type to store a URL.

Scalar type: varchar

Value type in script: string

Length, example, or validation criteria: This field can contain any characters. The length is limited to 1024 characters.

Field content example:
https://example.simpleone.ru/portal

Choice-like fields

Field types that offer choice options to a user and can be filled by selecting a value.

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.

Scalar type: boolean

Value type in script: boolean

Field content example:

true

Choice

This field type implements the choice functionality.

In the interface, it is displayed as a drop-down list.

See the Choice Fields article to learn more.

Scalar type: varchar

Value type in script: string

Length, example, or validation criteria: This field can contain any characters. By default the length is limited to 80 characters.

Field content example:

Changed

Color

This field type is intended to keep and share information about the system color or the color of an interface element. Use this field type, for example, in the Style Rules.

Scalar type: varchar

Value type in script: string

Length, example, or validation criteria: 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.

Field content example:

#db3e00

Conditions

Use this field type to build AND/OR filters.

In the interface, it is displayed as a filter configuration widget. The condition data is stored in the JSON format.

Scalar type: text

Value type in script: string

Length, example, or validation criteria:

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.

Field content example:
(active=true)

Time

Use this field type 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.

See the Date and datetime columns article to learn more.

Scalar type: time

Value type in script: string

Length, example, or validation criteria: The time can be written based on the ISO 8601 standard.

Field content example:
11:00:54

Date

This field type stores the date in the following YYYY-MM-DD format, and does not specify the time. The size of the data stored is 4 bytes.

In the interface, it is displayed as an input field with a date picker.

See the Date and datetime columns article to learn more.

Scalar type: date

Value type in script: string

Length, example, or validation criteria: A date must be based on the ISO 8601 standard.

Field content example:
2022-11-15

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.

See the Date and datetime columns article to learn more.

Scalar type: timestamp

Value type in script: string

Length, example, or validation criteria: The datetime can be written based on the ISO 8601 standard.

Field content example:
2022-11-15 11:01:34

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.

See the Date and datetime columns article to learn more.

Scalar type: timestamp

Value type in script: string

Length, example, or validation criteria: The datetime can be written based on the ISO 8601 standard.

Field content example:
2022-11-15 13:59:53

Document ID

Use this field type to store various IDs as universally unique identifiers (UUID).

A UUID consists of 32 hexadecimal characters separated by hyphens into five groups in an 8-4-4-4-12 pattern:

8-digit group
three groups of 4 digits each
12-digit group.
It is 32 digits and 128 bits total.

On a form, the field of this type is displayed as a reference field. This field type is used to store a reference to a column in a particular table and contains a list of columns of the referenced table. It should contain a reference to a specified column in a specified table. To specify a reference, click the string or the magnifier icon and select a table and a column.

Scalar type: uuid

Value type in script: string

Length, example, or validation criteria:

An input value is validated to be a string value.
After that, validation is performed according to a predefined pattern as described in a Description column.

Field content example:
022c7bf5-6eb7-09f0-0244-bd40328f5f0f

Field Name

Use this field type to store a reference to a column in a particular table and contains a list of columns in the referenced table.

Scalar type: int8

Value type in script: string

Length, example, or validation criteria: The input string is validated to ensure that it is a string value.

Field content example:

165062848110459919

Image

Use this field type 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.

Scalar type: int8

Value type in script: string

Length, example, or validation criteria: The value specified should not exceed this range: [9223372036854775807 ... 9223372036854775806].

Field content example:

166851128418198961

List

This field type can contain an unlimited text string. It stores record IDs of the specified table and is displayed as a list of record values that you can click to preview the record form.

See the Reference Fields article to learn more.

Scalar type: text

Value type in script: string

Length, example, or validation criteria: All elements must be separated by a comma.

Field content example:
166807095216015872,166608269714919765

Record Class

Use this field type 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.

Scalar type: int8

Value type in script: string

Length, example, or validation criteria: 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 the task list, you can find incidents among the mass of the tasks.
You need to find some incidents while being in the Task table context.
To do so, 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.

Field content example:

155931135900000084

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.

See the Reference Fields article to learn more.

Scalar type: int8

Value type in script: string

Length, example, or validation criteria: You can use this range of big integers: [-9223372036854775808 … 9223372036854775807]

Field content example:

155931135900000001

Template

With this field type, you can store a set of column names and their values in JSON format for all tables. This format supports nesting. On the first nesting level, the element numbers starting from 1 are used as keys.

Since the field type stores data pairs column name ↔ value, it is commonly used in template forms. You can use a range of big integers if required. The records created from the templates get completed with the stored information automatically if there are corresponding fields on the form.

The elements are objects in the following format:

key − the column ID in the Columns (sys_db_column) dictionary.
value − the column value.

Scalar type: json

Value type in script: string

Length, example, or validation criteria:

Template:
// the following columns of user dictionary are used: username, active, locked_out
 
{
  "1":
  {
    "156943341303994936": "new_user"
  },
  "2":
  {
    "156943341308746896": "1"
  },
  "3":
  {
    "155931135900001086": "0"
  }
}

Field content example:

[]

No bound choices​

Big Integer​

Days of Week​

Decimal​

Duration​

Encrypted Password​

Float​

HTML​

Integer​

Journal Input​

JSON​

Password​

Percent Complete​

Phone​

Script​

Small Integer​

String​

Text​

Translated Text​

URL​

Choice-like fields​

True/False​

Choice​

Color​

Conditions​

Time​

Date​

Date/Time​

Date/Time Specific​

Document ID​

Field Name​

Image​

List​

Record Class​

Reference​

Template​

No bound choices

Big Integer

Days of Week

Decimal

Duration

Encrypted Password

Float

HTML

Integer

Journal Input

JSON

Password

Percent Complete

Phone

Script

Small Integer

String

Text

Translated Text

URL

Choice-like fields

True/False

Choice

Color

Conditions

Time

Date

Date/Time

Date/Time Specific

Document ID

Field Name

Image

List

Record Class

Reference

Template