Fields of text type store various kinds of characters. The exception is Phone type which allows spaces, numbers,  '+' and '-'.

Column types

Journal Input


Description

This field type is used to operate with the comment widget for communicating with responsible users, callers, and followers. It is implemented as a text-area with a placeholder.

Due to its features, the Journal Input field type cannot be read-only.

By default, the Journal Input field is an empty string. When a comment is added, the field value saves the following data to the Activities Stream Fields (sys_activities_stream_field) table:

  • ID of the commented record
  • reference to the table containing this field
  • reference to the journal input column record
  • the comment value
  • name of the user who left the comment
  • field name.

After the comment is saved, the field value becomes an empty string again.

You cannot create, edit, or delete records in the Activities Stream Fields (sys_activities_stream_field) table. Only users with the admin role can read them.

Scalar Typetext
Max LengthNot set
Validation CriteriaThis field can contain all kinds of symbols.

You can limit the maximum number of symbols with the Max Length attribute. 

There are two ways to leave a comment using the Journal Input column type:

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

    4. Click Send.

After that, the message will appear in the Activity Feed module.

See the Activity Feed article to learn more.

To create a journal input field, perform the steps described in Creating a column section of this article.

JSON


Description

This field type is physically stored as JSON.

Scalar Typejsonb
Max LengthNot set
Validation CriteriaFields 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.

To create a JSON field, perform the steps described in Creating a column section of this article.

Phone


Description

This field stores a phone number. It is displayed as an input field with the phone number.

Scalar Typevarchar
Max Length15 symbols
Validation Criteria

The field can contain:

  • '+'
  • '-' 
  • round brackets
  • spaces
  • numbers.

To create a phone field, perform the steps described in the Creating a Column article.


Script


Description

This field type is physically implemented as a text string. In SimpleOne, it is displayed as a JS component that provides ability to edit the code in a browser.

Scalar Typetext
Max LengthNot set
Validation Criteria

The script is validated according to the ECMA standard.


You can limit the maximum number of symbols with the Max Length attribute. 

To create a script field, perform the steps described in the Creating a Column article.

String


Description

This field type is physically implemented as a string. In SimpleOne interface, it is displayed as a text input field.

Scalar Typevarchar
Max Length255
Validation Criteria

This field can contain all kinds of symbols.

You can limit the maximum number of symbols or extend it with the Max Length attribute

To create a string field, perform the steps described in the Creating a Column article.

Text


Description

This field type is physically implemented as a text string. Memory is allocated dynamically when processing the field. In SimpleOne interface, it is displayed as a text area.

Scalar Typetext
Max LengthNot set
Validation Criteria

This field can contain all kinds of symbols.

You can limit the maximum number of symbols with the Max Length attribute. 

To create a text field, perform the steps described in the Creating a Column article.

  • No labels