Fields of text type store various kinds of characters. 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, the caller, 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.
- via the Activity Feed module:
- Click on the Activity Feed module.
- Select the tab representing the message type you need (in the example below, Work Notes, Additional Comments, Message).
Enter the text.
- 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 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.
Phone
| 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.
Script
| 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.
String
| 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.
Text
| 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.
