No Bound Choices

Field types that do not offer a user any choice to select from.

Field TypeDescriptionScalar TypeValue length or example, validation criteria

Big Integer

It is a numeric field type used to store huge numbers. The size of the data stored is 8 bytes.

In SimpleOne, it is displayed as an input field with a numeric value.

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

Days of week

This field is displayed as a drop-down list with checkboxes presenting 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 with 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.

int2

Minimum value is 0 (days are not selected).

Maximum value of the field is 127 (all days selected).

Decimal

This field type implements number with up to two digits after the decimal points (for example, 12.34).decimal

Duration

This field type is used to provide a duration between two events in milliseconds. It stores an integer number.int8

The validation processing:

  1. The input string is categorized by date and time parts (days, hours, minutes, seconds).
  2. It converts into a total millisecond amount and is saved as a Big Integer number.

Encrypted Password

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

Before saving, the password is encoded based on one of the encryption algorithms and a random string. The password is decoded before using it.

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

  • Only numbers, a comma or a dot are allowed.
  • Maximum string length is 14 symbols.
  • Maximum fraction size is 12 symbols (after a delimiter which can be a comma or a dot, depending on user preferences).

HTML

This field type is implemented as a rich text widget. There are various settings which are 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 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 in one of the modes are displayed in another, and vice versa.

textThis field can contain all kinds of symbols, and it is lengthless until not limited by the Max Length attribute. 

Integer

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

int4The 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 features, the field cannot be read-only. It is implemented as a text area with a placeholder or 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 module:
    1. Click on the Activity Feed module.
    2. Select the tab representing the message type you need (in the example below, Work Notes, Additional Comments, Message).

    3. Enter the text. 

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

  • Activities Stream Fields (sys_activities_stream_field) – comments from Activity Feeds that are working within UI formatter
  • Activity Feed Items (sys_activity_feed_item) – comments for the widget that can be configured via <activityFeed> SimpleTag. 

If async after business rules 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.


textThis field can contain all kinds of symbols, and it is lengthless until it is not limited by the Max Length attribute. 

JSON

This field type stores values in JSON.

jsonb

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}

Fields of the JSON type are validating as if they contain a string structured in a JSON way. To learn more about this, refer to the official JSON documentation.

Password

This field stores passwords. It is displayed as an input field.

varcharThis 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 progress of working on a task in percent.decimal

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.

varchar

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

textThis field can contain all kinds of symbols, and it is lengthless until not limited by the Max Length attribute. 

Small Integer

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

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

String

This field type is physically implemented as a string 255 symbol length.

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

varcharThis field can contain all kinds of symbols. If the string length is not set, then it is limited to 255 symbols; otherwise, a limit may be well above.

Text

This field type is physically implemented as a lengthless text string. Меmory is allocated dynamically when processing the field.

text

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.

See the Translated Text columns article to learn more.


varcharThis field can contain all kinds of symbols, and it is lengthless until not limited by the Max Length attribute.

URL

This field type is used to store a URL.

varcharThis field can contain all kinds of symbols. The value length is limited to 2048 symbols. 


Choice-like Fields

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

Field TypeDescriptionScalar TypeValue length or example, validation criteria

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.

boolean

true

false

Choice

This field type implements the choice functionality.

In 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 choices are available (they vary by Choice Type field setting on the column creation form):

  • 'None'
  • Drop-down with 'None'
  • Drop-down without 'None' (must specify a default value).

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, then it is limited up 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 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 to within 1 day, and does not specify the time of the day. The size of the data stored is 4 bytes.

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

date

A date must be in the ISO 8601 format:

  • YYYY-MM-DD

Date elements are validated to meet the following criteria:

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

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:

ElementRangeComment
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 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 the ISO 8601 format like shown below:

YYYY-MM-DD hh:mm:ss

Datetime elements are validated to meet the following criteria:

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


Document ID

This field type is used to store various IDs. Physically they are stored as 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:

  • 8-digit group
  • three groups of 4 digits each
  • 12-digit group.

It is 32 digits and 128 bits total.

When 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 on a string or on the magnifier icon and select a table and a column.


uuid

Validation criteria:

  1. The input value is validated that it is a string value.
  2. The validation is then performed according to a predefined pattern as described in the Description column.


0229fa8a-bcbe-1f54-0163-45785d8a0001


Field Name

This field type is used to store a reference to a column in the table and contains a list of columns in a referenced table.

To specify a reference, complete the steps below:

  1. Add this field to the form using the Form Layout functionality.
  2. Right-click on the field title and select Configure field item.
  3. Scroll down to the Type Specification tab and specify the referencing table column in the Dependent on Column field.
  4. Click Save or Save and Exit to save changes.
int8The input string is validated 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 SimpleOne interface, it is displayed as a file upload modal window.

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

List

This field type is physically implemented as a lengthless text string. It stores record IDs of the specified table. It 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 columns article to learn more.


text

The validation criteria are listed below:

  • All elements must be separated by a comma.

Record Class

This field type is meant to signify the table to which the specified record relates.

The Record Class field is created for the table at the moment when the newly inherited one is created. Initially, when creating a new root table (without any parents), the table will not have this field. Type of the stored data – ID. The size of the stored data – 8 bytes.

int8

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 physically stored as Big Integer.

See the Reference columns article to learn more.


In order to limit the output when referencing to a field, use Reference Qualifiers.


int8You can use whole big integer range for your purposes: [-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 whole big integer range for your purposes The field allows for applying stored data to records created from templates. 

The elements are objects in the following format:

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

This type of field requires populating the Dependent On Column field in the Type Specification tab with the appropriate table.




json


// 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. Timezone is not taken into account. The date is not stored. The size of the stored data – 8 bytes.

time

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:

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

The allowed symbols are numbers and a colon ( : ).