Fields of text type store various kinds of characters. Exception is Phone type which allows for using spaces, numbers, '+' and '-'.
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 of the field title. By default, journal input field is empty string. When a comment is added, the field value saves the following data to the Activities Stream Fields (sys_activities_stream_field) table:
After the comment is saved, the field value becomes empty string again.
| |
---|---|---|
Scalar Type | text | |
Max Length | Not set | |
Validation Criteria | This 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 a journal input field:
Enter the text in the field.
Click Save or Save and Exit.
Enter the text.
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.
Description | This field type is physically stored as JSON. ![]() |
---|---|
Scalar Type | jsonb |
Max Length | Not set |
Validation Criteria | 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. |
To create a JSON field, perform the steps described in Creating a column section of this article.
Description | This field stores a phone number. It is displayed as an input field with the phone number. ![]() |
---|---|
Scalar Type | varchar |
Max Length | 15 symbols |
Validation Criteria | The field can contain:
|
To create a phone field, perform the steps described in the Creating a Column article.
Description | This field type is physically implemented as a text string. In SimpleOne, it is displayed as a JS component that provides ability of the code editing in a browser. ![]() |
---|---|
Scalar Type | text |
Max Length | Not 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.
Description | This field type is physically implemented as a string. In SimpleOne interface, it is displayed as a text input field. ![]() |
---|---|
Scalar Type | varchar |
Max Length | 255 |
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.
Description | This field type is physically implemented as a text string. The memory is allocated dynamically when processing the field. In SimpleOne interface, it is displayed as a textarea. ![]() |
---|---|
Scalar Type | text |
Max Length | Not 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.