Skip to main content
Version: 1.28.0

Column Types

No bound choices​

These field types do not offer any pre-configured choice options to the user.

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.

You can specify if the digit group separators should be used for the field values in the enable_grouping_separator column extra attribute. If the attribute is not specified, the displaying of the digit group separator is defined by the value of the simple.number.enable_grouping_separator system property.

Scalar type: int8

Value type in script: number

Length, example, or validation criteria:

  • The range 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 representing 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: The minimum value is 0 (no days are selected). The maximum value is 127 (all days are selected).

Field content example:
8

Decimal​

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

Decimal separator changes with the language. You can specify if the digit group separators should be used for the field values in the enable_grouping_separator column extra attribute. If the attribute is not specified, the displaying of the digit group separator is defined by the value of the simple.number.enable_grouping_separator system property.

Scalar type: decimal

Value type in script: number

Length, example, or validation criteria:

  • Possible value range: [-9999999999.99 ... 9999999999.99].
  • Up to 13 symbols are allowed: 10 in the whole part, 1 separator, and 2 in the fractional part of the number.
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.
  • Range of possible values: [-9223372036854775808 ... 9223372036854775807].
Field content example:
3600000

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. SimpleOne supports all encodings available for the PostgreSQL database, including emojis. You can configure the Max length in the corresponding field.

Field content example:
0YATXJjpWt5wFPL6FiKxQA==

Float​

This field type stores floating point numbers.

Decimal separator changes with the language. You can specify if the digit group separators should be used for the field values in the enable_grouping_separator column extra attribute. If the attribute is not specified, the displaying of the digit group separator is defined by the value of the simple.number.enable_grouping_separator system property.

Scalar type: float4

Value type in script: number

Length, example, or validation criteria:

  • Only numbers and a dot are allowed.
  • Maximum value length is 14 characters.
  • Maximum fraction length is 12 digits (after the point).
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. SimpleOne supports all encodings available for the PostgreSQL database, including emojis.

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.

You can specify if the digit group separators should be used for the field values in the enable_grouping_separator column extra attribute. If the attribute is not specified, the displaying of the digit group separator is defined by the value of the simple.number.enable_grouping_separator system property.

Scalar type: int4

Value type in script: number

Length, example, or validation criteria:

  • Only numbers are allowed.
  • Range of possible values: [-2147483648 ... +2147483647].
Field content example:
1211345967

Journal Input​

Use this field type to interact with the comment widget. Due to its specifics, the field cannot be read-only. It is implemented as a text area with a placeholder and a field title.

There are two ways to leave a comment in a Journal Input column:

  • 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 the 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 the async after business rules are running, you can work with the field values of the Journal Input type in the same way as you do with the after rules, when referring to the current context.
  • Reports do not support 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. SimpleOne supports all encodings available for the PostgreSQL database, including emojis. 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 fields of String type containing values structured in JSON. 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. On a form, 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. SimpleOne supports all encodings available for the PostgreSQL database, including emojis. You can specify the Max length in the corresponding attribute.

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

Percent Complete​

Use this field type to display task completion rate.

Decimal separator changes with the language. You can specify if the digit group separators should be used for the field values in the enable_grouping_separator column extra attribute. If the attribute is not specified, the displaying of the digit group separator is defined by the value of the simple.number.enable_grouping_separator system property.

Scalar type: decimal

Value type in script: number

Length, example, or validation criteria:

  • Only numbers and separators are allowed.
  • Range of possible values: [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, spaces and digits.
  • Maximum length is 15 characters.
Field content example:
+74951818520

Script​

This field type represents a 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 by default. It can be limited by the Max length attribute. SimpleOne supports all encodings available for the PostgreSQL database, including emojis. 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.

You can specify if the digit group separators should be used for the field values in the enable_grouping_separator column extra attribute. If the attribute is not specified, the displaying of the digit group separator is defined by the value of the simple.number.enable_grouping_separator system property.

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:
12

String​

In the interface, this field is displayed as a text input field. If a numeric value is specified, it is interpreted as such by the system, and the decimal and digit group separators specified for the selected language are applied to it.

Scalar type: varchar

Value type in script: string

Length, example, or validation criteria: The field can contain any symbols. SimpleOne supports all encodings available for the PostgreSQL database, including emojis. 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 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 by default. It can be limited by the Max length attribute. SimpleOne supports all encodings available for the PostgreSQL database, including emojis.

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 by default. It can be limited by the Max length attribute. SimpleOne supports all encodings available for the PostgreSQL database, including emojis.

Field content example:
Send email

URL​

Use this field type to store URLs.

Scalar type: varchar

Value type in script: string

Length, example, or validation criteria: This field can contain any characters. SimpleOne supports all encodings available for the PostgreSQL database, including emojis. You can specify the Max length in the corresponding field.

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

WYSIWYG​

Use this field type to store text and graphic information with the formatting created with the tools available in this field.

To assign a field value in the script specified in the Use dynamic default field, use the JSON.parse method that accepts a JSON string, and returns an object.

Scalar type: jsonb

Value type in script: string

Length, example, or validation criteria: The display value is presented in the WYSIWYG widget with its formatting. The database value must be presented in the JSON format the following keys:

  • display_value – the field content in the text form without formatting.
  • lexical_json_value – the field content in the WYSIWYG-JSON format based on the Lexical library.
caution
  • It is not recommended to generate the content of the lexical_json_value key via scripts since the key structure may change with every system update. But if you need to, use the JSON.stringify() to convert a string.
  • Since version 1.24 the Rich Text data type is deleted in the "out-of-the-box" solution. Change it to the WYSIWYG data type for existing columns.
Field content example:
{
    "display_value": "1234",
    "lexical_json_value": {
        "root": {
            "children": [{
                    "children": [{
                            "detail": 0,
                            "format": 0,
                            "mode": "normal",
                            "style": "",
                            "text": "1234",
                            "type": "text",
                            "version": 1
                        }
                    ],
                    "direction": null,
                    "format": "",
                    "indent": 0,
                    "type": "paragraph",
                    "version": 1,
                    "textFormat": 0,
                    "textStyle": ""
                }
            ],
            "direction": null,
            "format": "",
            "indent": 0,
            "type": "root",
            "version": 1
        }
    }
}

Choice-like fields​

Field types that offer choice options to a user and can be filled in 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 used to store 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 condition builder.

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

The Dependent on column attribute must be configured for this field type, where you need to specify a reference column of the Table. The column should have the table_id name and reference to the Table dictionary to build conditions. You can specify extended condition operators in the extra attributes. Read more in the Create columns article.

Scalar type: text

Value type in script: string

Length, example, or validation criteria:

  • This field can contain any symbols.
  • 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 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 date and timestamp up to seconds. The timezone is not taken into account.

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 date and timestamp up to seconds with connection to a specific timezone.

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 record IDs as universally unique identifiers (UUID). The difference between this field type and other reference types (Reference, List) lies in the ability to refer to any record from any table, while other reference fields only allow to select records from a specific table.

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 where the user can specify the table and 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:

  1. An input value is validated to be a string value.
  2. After that, validation is performed according to a predefined pattern as described above.
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. The field contains a list of columns in the referenced table. The field itself contains column ID but the form displays a drop-down list in which the user can select from the columns of the specified table.

The Dependent on column attribute must be configured for this field type, where you need to specify a reference column of the Table. The column should have the table_id name and reference to the Table dictionary.

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. The field accepts digits only and contains a column ID.

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.

You can limit the size of uploaded image with extra attributes. Read more in the Create columns article.

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 contains ID of the image record on the instance. The range of possible values: [0 ... 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.

Use Reference Qualifier to limit the table records available in the field dictionary.

See the Reference Fields article to learn more.

Scalar type: text

Value type in script: string

Length, example, or validation criteria: The field contains record IDs separated by commas.

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 a new root (without any parents) table is created, it does 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: Range of possible values: [100000000000000000 .. 999999999999999999].

Example of usage:

  1. The Task table and its child table, the Incident table, have several records.
  2. When you look through the task list, you can find incidents among the mass of the tasks.
  3. You need to find some incidents while being in the Task table context.
  4. To do so, filter these records based on the Record Class field.
  5. The Record Class field is a system field. It is always read-only.
Field content example:
155931135900000084

Reference​

This field type works like an external key and stores the record ID of the table specified in the Reference field. It is stored as Big Integer.

Use Reference Qualifier to limit the table records available in the field dictionary.

See the Reference Fields article to learn more.

Scalar type: int8

Value type in script: string

Length, example, or validation criteria: Possible value range of big integers: [-9223372036854775808 … 9223372036854775807]. You can configure the Max length in the corresponding field.

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.

The Dependent on column attribute must be configured for this field type, where you need to specify a reference column of the Table. The column should have the table_id name and reference to the Table dictionary.

Scalar type: json

Value type in script: string

Length, example, or validation criteria: The field must contain column IDs and their values for the autocompletion structured as showed in the example. You can configure the Max length in the corresponding field.

Field content example:
// 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:
[]