No Bound Choices

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

Field TypeDescriptionScalar TypeValue Type in ScriptLength, Example, or Validation Criteria

Big Integer

This is a numeric field type used for storing very large numbers. The size of data stored is 8 bytes.

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

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

166674708111757858

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. One or more options can be selected.

Technically, the field stores a numeric value or a sum of values. Data size for each option 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 is 127 (all days are selected).

Field content example:

8

Decimal

This field type implements number with up to two digits after the decimal point.decimalnumber
Field content example:

12.33

Duration

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

Validation processing:

  1. The input string is categorized by datetime parts (days, hours, minutes, seconds).
  2. The value is converted into a total number of milliseconds and saved as a Big Integer number.
Field content example:

3600000

Encrypted Password

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

See the Password columns article to learn more.

varcharstring

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

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

When using 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 the panel. 

Changes made in one mode are displayed in the other, and vice versa.

textstring

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 data stored is 4 bytes.

int4number

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

Field content example:

1211345967

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 the field title.

When comments are added, they are stored in the Activities Stream Fields (sys_activities_stream_field) and in the Activity Feed Items (sys_activity_feed_item) tables.

The Activities Stream Fields (sys_activities_stream_field) table stores comments from Activity Feeds that are working within UI formatter. 

The Activity Feed Items (sys_activity_feed_item) table stores comments for the widget that can be configured via <activityFeed> SimpleTag.

See the Text columns article to learn more.

  • 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.
  • Reports do not suuport the use of 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:

Field content example:

""

JSON

This field type is physically stored as JSON.

See the Text columns article to learn more.

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.

Field content example:

{"abc": 123}

Password

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

See the Password columns article to learn more.

varcharstring

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

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

99.90

Phone

This field stores a phone number.

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

See the Text columns article to learn more.

varcharstring

Validation criteria:

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

+74951818520

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

See the Text columns article to learn more.

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.

Field content example:

// console.log()

Small Integer

This is numeric field type. The size of data stored is two bytes. 

int2number

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

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

See the Text columns article to learn more.

varcharstring

This field can contain any characters. If the string length is not set, it is limited to 255 characters; otherwise, a limit may be higher or lower.

Field content example:

abc123

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.

See the Text columns article to learn more.

textstring

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

See the Translated Text columns article to learn more.

varcharstring

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

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

Field content example:

https://sandbox-01.simpleone.ru/portal

Choice-like Fields

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

Field TypeDescriptionScalar TypeValue Type in ScriptLength or Example, 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 checking or unchecking it.

booleanboolean
Field content example:

true

Choice

This field type implements the choices functionality.

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

See the Choice fields article to learn more


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

When creating a column you can specify Choice Table and Choice Column. In 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.

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

varcharstring

This field can contain either 4 or 7 characters (concise or full RGB record) starting with the hash sign (#). Allowed characters are: numbers, English letters (A to F) and the hash sign.

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

See the Condition columns article to learn more.

textstring

Validation criteria:

Field content example:

(active=true)

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

datestring

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 characters in this field:

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

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

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

2022-11-15 13:59:53

Document ID

This field type is used to store various IDs. Physically they are stored as UUID.

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.

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

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

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

Field Name

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

To specify a reference, please 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 changes.
int8string

An input string is validated that it is a string value.

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

Field content example:

166851128418198961

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 adding, previewing, and deleting records.

See the Reference columns article to learn more.

textstring

The validation criteria are listed below:

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

166807095216015872,166608269714919765

Record Class

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

See the Record Class article to learn more.

int8string

The value specified should not exceed this range: [100000000000000000 ..
999999999999999999].

Field content example:

155931135900000084

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.

See the Reference columns article to learn more.


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

int8string

You can use the whole big integer range for your purposes: [-9223372036854775808 … 9223372036854775807]

Field content example:

155931135900000001

Template

This field type allows 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 on template forms. The field allows 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.




jsonstring
Template 
// following columns of User [user] dictionary are used: username, active, locked_out

{
  "1":
  {
    "156943341303994936": "new_user"
  },
  "2":
  {
    "156943341308746896": "1"
  },
  "3":
  {
    "155931135900001086": "0"
  }
}

Empty field value:

Field content example:

[]

Time

This field type is used as a time storage. Timezone is not taken into account. The date is not stored. The size of data stored is 8 bytes.

See the Date and datetime columns article to learn more.

timestring

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 characters are numbers and a colon ( : ).

Field content example:

11:00:54

  • No labels

© 2019-2023, SimpleOne

https://simpleone.ru