Column Types

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

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.

Minimum value is 0 (no days are selected).

Maximum value of is 127 (all days are selected).

Validation processing:

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

This field type is used to provide secure password storage in a database, with the decoding ability (two-way encryption).

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

This field can contain any characters. The length is limited to 255 characters.

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).

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.

This field can contain any characters and is lengthless unless limited by the Max length attribute.

The value specified should not exceed this range: [-2147483648 ... +2147483647].

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:

• 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.

  3. Enter text. 
     

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.

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:

This field type is physically stored as JSON.

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.

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.

This field can contain any characters. The length is limited to 255 characters.

Validation criteria:

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

This field stores phone numbers.

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

Validation criteria:

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

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).

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.

The value specified should not exceed this range: [-32768 ... +32767].

This field type is physically implemented as a string 255 characters long.

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

This field can contain any characters and is lengthless. It can be limited by the Max length attribute.

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.

This field can contain any characters and is lengthless. It can be limited by the Max length attribute.

This field type allows the same field to display different content based on the user's chosen language.

This field can contain any characters and is lengthless. It can be limited by the Max length attribute.

This field can contain any characters. The length is limited to 1024 characters.

This field type implements the choice functionality.

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

This field can contain any characters. If the string length is not set, it is limited to 80 characters.

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.

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.

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.

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 interface, it is displayed as an input field with a date picker.

A date must be in the ISO 8601 format:

• YYYY-MM-DD

Date elements are validated to meet the following criteria:

Available characters in this field:

• Numbers
• Slash ( / )
• Hyphen ( - )
• Dot ( . )

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.

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:

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.

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:

This field type is used to store various IDs as universally unique identifiers (UUID).

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 in a Description column.

The input string is validated to ensure that it is a string value.

The value specified should not exceed this range: [9223372036854775807 ... 9223372036854775806].

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.

Validation criteria:

• All elements must be separated by a comma.

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:

1. The Task table and its child table, the Incident table, have several records.
2. When you look through a task list, you can find incidents among the mass of the tasks.
3. For your purposes, you need to find incidents while being in the Task table context.
4. To do this, you can filter these records based on the Record Class field.
5. The Record Class field is a system field. It is always read-only and inaccessible for editing.

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.

You can use this range of whole big integers: [-9223372036854775808 … 9223372036854775807]

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

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.

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 ( : ).