Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

No

Bound Choices

bound choices


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

Field
Type
typeDescriptionScalar
Type
typeValue type in scriptLength, example, or
Example,
validation criteria

Big Integer

It's

This is a numeric field type used

for the storage of the very huge

to store large numbers.

 Size

The size of the data stored is 8 bytes.

In SimpleOne

interface

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

in it

.

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

Char

This field type is used for storing symbolic data (for example, hash, ID, UUID, etc.). Size of the data stored is 32 bytes. 

In SimpleOne interface, it is displayed as an input field with the symbolic value in it.

charThis field can contain all kinds of symbols; the length is limited up to 2 symbols.

Decimal

This field type implements number
number
  • In SimpleOne, this range is used for record IDs: [100000000000000000 …
    999999999999999999]
  • You can use the following big integer range: [-9223372036854775808 … 9223372036854775807]
Panel
titleField 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.

int2number

Minimum value is 0 (no days are selected).

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

Panel
titleField content example:

8


Decimal

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


Panel
titleField content example:

12.33


Duration

This field type is used to
provide a
calculate the duration between two events
specified
in milliseconds. It stores an integer number
inside
.int8
The validation
number

Validation processing:

  1. The input string is categorized by
datetime
  1. the date and time parts (days, hours, minutes, seconds).
It converts
  1. The value is converted into a total number of milliseconds
amount
  1. and saved as a Big Integer number.
Panel
titleField content example:

3600000


Encrypted Password

This field type is used

to provide

to provide secure password storage in

the

a database, with the decoding

ability 

ability (

2

two-way encryption).

Before saving, password encodes basing on one of the encryption algorithm and a random string. Before usage, decoding performs.

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

varcharstring
varchar

This field can contain

all kinds of symbols

any characters. The length is limited

up

to

128 symbols

255 characters.

Float

This field type implements a floating point number.
Panel
titleField content example:

0YATXJjpWt5wFPL6FiKxQA==


Float

This field type implements a floating-point number.float4number
float4

Validation criteria:

  • Only numbers, a comma and a dot are allowed.
  • Maximum
string
  • value length is 14
symbols
  • characters.
  • Maximum fraction

size
  • length is 12

symbols
  • digits (after a delimiter

which
  • that can be a comma or a dot, depending on

a
  • user preferences).

Panel
titleField content example:

0.333


HTML

This field type is implemented as a rich text widget.

It has various settings which are

There are various settings displayed as HTML tags in

the

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.

Info
When using

There are two modes to use in this field

type, there are two modes

: rich text editor and source editor. You can enter the source editor by clicking

the

Source

button on

 on the panel.

Image Modified

Changes made in one

of

modes are displayed in

another

the other, and vice versa.

textstring

This field can contain

all kinds of symbols, and it

any characters and is lengthless

until not

unless limited by

the

the Max

Length attribute

length attribute.

 

Integer

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

int4
Panel
titleField 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.

int4number

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

Journal Input

This field
Panel
titleField content example:

1211345967


Journal Input

This field type is used to operate with the comment widget

for the intermediate data storage when the comments are being added

. Due to its specifics, the field cannot be read only. It is implemented as a text

-area with

area with a placeholder

of the

or a field title.

Expand
titleMore Info...

As a rule, it has the NULL value. When a comment is being added, the field value saves the following data to the sys_activities_stream_field table:

  • reference to the commented record;
  • reference to the table containing this field;
  • the comment itself;
  • commentator's name (the user who has added the comment);
  • field name.

After the comment is saved the field value becomes NULL again.

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

JSON

This field type is physically stored as JSON.jsonb

Field content example:

Code Block
languagepy
themeEclipse
titleJSON
{"name":"John", "age":30, "cars": {"car1":"Ford", "car2":"BMW",     "car3":"Fiat"   }  }

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

Password

Displayed as an input field with password type.

varcharThis field can contain all kinds of symbols; the length is limited up to 255 symbols.

Percent Complete

This field type is used to display a task completion rate.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 numeric field type. Size of the data stored – two bytes. 

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

String

This field type is physically implemented as a string 255 symbols 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 up to 255 symbols; otherwise, a limit may be well above.

Text

This field type is physically implemented as a lengthless text string. The memory is allocated dynamically when processing the field.

In SimpleOne interface, it is displayed as a textarea.

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. To learn more about this field type, please refer to the Translated Text field article.

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 length is limited up to 2048 symbols. 

Choice-like Fields

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

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.
      Image Added

  • via the Activity Feed widget:
    1. Click the Activity Feed widget.
    2. Select the tab representing the message type you need.
    3. Enter text. 
      Image Added

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


textstring

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:

Panel
titleField content example:

""


JSON

This field type is physically stored as JSON.

Image Added

jsonbstring

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.

Panel
titleField 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

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.

varcharstring

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

Panel
titleField content example:

$2y$13$MtP.z1mkGN.SdrzhzBQQ7.XaXgg58IS/qm2/wwQSeT/B58fxNMQGK


Percent Complete

This field type is used to display a task completion rate.decimalnumber

Validation criteria:

  • May contain numbers [0..100].
  • Maximum fraction length is 2 digits.
  • Maximum length is 4 digits.
Panel
titleField content example:

99.90


Phone

This field stores phone numbers.

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

Image Added

varcharstring

Validation criteria:

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

+74951818520


Script 
Anchor
script
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).

Image Added

textstring

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.

Panel
titleField content example:

// console.log()


Small Integer

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

int2number

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

Panel
titleField content example:

12


String

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

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

Image Added

varcharstring

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

Panel
titleField content example:

john.doe12


Text

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.

Image Added

textstring

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

Panel
titleField 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 chosen language.

Tip

See the Translated Text Fields article to learn more.


varcharstring

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

Panel
titleField content example:

Send email


URL

This field type is used to store a URL.

varcharstring

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

Panel
titleField 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.

Field typeDescriptionScalar typeValue type in scriptLength, example, or validation criteria

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.

booleanboolean


Panel
titleField content example:

true


Choice

This field type implements the choice functionality.

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

Tip

See the Choice Fields article to learn more.


Expand
titleMore Info...

Supporting fields are created for this field type in the sys_db_column table. The choice options for such columns are located in the sys_choice table. The following types of Choices are available (they vary by Choice Type setting on the column creation form):

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

When creating a column you can specify Choice Table and Choice ColumnIn this case, the Choice Column values are the options for the values of the specified table in the Choice Table.



varcharstring

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

Panel
titleField 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. This field type is used, for example, in the Style Rules.

varcharstring

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.

Panel
titleField content example:

#db3e00


Conditions

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.


textstring

The validation criteria are:

Panel
titleField content example:

(active=true)


Date

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

Field TypeDescriptionScalar TypeLength 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 choices functionality.

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

Expand
titleMore Info...

For this, supporting fields in the sys_db_column column were implemented. 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 setting on the column creation form):

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

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.

See Choice fields article to learn more.

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, in the Style Rules.

varchar

This field can contain either 4 or 7 symbols (concised 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 not specifying the time of the day. 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 can be written in three different ways:

  • YYYY-MM-DD (ISO 8601 format)
  • DD.MM.YYYY
  • MM/DD/YYYY

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

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. 

timestampThe datetime can be written in the ISO 8601 format like shown below:

Image Added

Tip

See the Date and datetime columns article to learn more.


datestring

A date must be in the ISO 8601 format:

  • YYYY-MM-DD
HH:MM:SS
Datetime

Date elements are validated to meet the following criteria:

ElementRangeComment
Second
Day[
00
01..
59
31]The value specified should not exceed this range.
Minute
Month[
00
01..
59
12]The value specified should not exceed this range.
Hour
Year[
00
0001..
23
9999]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.

Expand
titleMore Info...

UUID is written as a sequence of hex numbers in lowercase, divided by a minus sign into several groups like this:

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

It is 32 digits and 128 bits total.

You can see it on the record create/edit page. It is displayed as a text input field with a dictionary button. When pressed, a modal window with two fields is shown:

  • a drop-down list with the tables
  • a table entry selection field.

Available characters in this field:

  • Numbers
  • Slash ( / )
  • Hyphen ( - )
  • Dot ( . )
Panel
titleField 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.

Image Added

Tip

See the Date and Time Columns article to learn more.


timestampstring

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.


Panel
titleField 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.

Tip

See the Date and Time Columns article to learn more.


timestampstring

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:

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]
uuid

The validation criteria are listed below:

  1. An input value is validated that its a string value.
  2. After that, validation is performed according to a predefined pattern like described in a Description column.
Expand
titleMore Info...

00000000-0040-0000-0000-000000000008

Field Name

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

To specify a reference, please complete the steps below:

  1. Add this field on the form using the Form Layout functionality.
  2. Right-click on the field title and select Configure Dictionary 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.
int8An input string is validated that it is a string value.

Image

This field type is used to store uploaded image files.

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 IDs of the records of the specified table, comma-separated. It is displayed as a list of record values (which are the references to the record edit page). It provides you the functionality of the adding, previewing, and deleting records.

text

The validation criteria are listed below:

  • All elements must be separated by a comma.
  • The values specified should not exceed this range: [9223372036854775808 ... 9223372036854775807].

Record Class

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

For more information, please refer to the Record Class article.

int8
The value specified should not exceed this range
: [9223372036854775807
.
Month[01..
. 9223372036854775806]
12]The value specified should not exceed this range.

Reference

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

Info

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

Year[1900..2099]The value specified should not exceed this range.


Panel
titleField content example:

2022-11-15 13:59:53


Document ID

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

Expand
titleMore Info...

A UUID is written 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.

On a form, the field of this type is displayed as a reference field. It should contain a reference to a specified column in a specified table. To specify a reference, click the string or the magnifier icon Image Addedand select a table and a column.

Image Added


uuidstring

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.
Panel
titleField content example:

022c7bf5-6eb7-09f0-0244-bd40328f5f0f


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:

  1. Add this field to the form using the form layout functionality.
  2. Right-click 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 the changes.
int8string

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

Panel
titleField content example:

165062848110459919


Image

This field type is used 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.

int8string

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

Panel
titleField content example:

166851128418198961


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.

Tip

See the Reference Fields article to learn more.


textstring

Validation criteria:

  • All elements must be separated by a comma.
Panel
titleField content example:

166807095216015872,166608269714919765


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.

int8string

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.
Panel
titleField content example:

155931135900000084


Reference 
Anchor
reference type
reference type

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.

Tip

See the Reference Fields article to learn more.


int8string

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

Panel
titleField content example:

155931135900000001


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:

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




jsonstring


Code Block
languagejs
themeEclipse
titleTemplate
linenumberstrue
collapsetrue
// 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:

Panel
titleField content example:

[]

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


Time

This field type is used as a time storage.

Timezone

The timezone is not taken into account. The date is not stored.

Size

The size of the stored data

– 8

is 8 bytes.

Image Added

Tip

See the Date and Time Columns article to learn more.


timestring

The time can be written in the ISO 8601 format as shown below:

HH

hh:

MM

mm:

SS

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

Panel
titleField content example:

11:00:54



Table of Contents
absoluteUrltrue