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:
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 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 the 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 to edit the code 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. Memory is allocated dynamically when processing the field. In SimpleOne interface, it is displayed as a text area. |
---|---|
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.
- No labels