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 |
|---|
Scalar type is text. Maximum number of characters is not set.
. |
By default, journal input fields |
have the NULL value. 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 NULL again. | |
| Scalar Type | text |
|---|---|
| Max Length | Not set |
| Validation Criteria | This field can contain all kinds of symbols. |
| Info |
|---|
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.
Section 
- 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.
Section 
- 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 Creating a column section of this 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 | This field can contain all kinds of symbols. |
| Info |
|---|
You can limit the maximum number of symbols with the Max Length attribute. |
To create a script field, perform the steps described in Creating a column section of this 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. |
| Info |
|---|
You can limit the maximum number of symbols with the Max Length attribute. |
To create a string field, perform the steps described in Creating a column section of this 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. |
| Info |
|---|
You can limit the maximum number of symbols with the Max Length attribute. |
To create a text field, perform the steps described in Creating a column section of this article.
Creating a column Anchor creating a text type column creating a text type column
| creating a text type column | |
| creating a text type column |
To create a column of text type, complete the following steps:
- Navigate to the System Definition → All Tables.
- Open the table for which you want to create a column.
- Scroll down to the Related Lists area and click on the Columns tab.
- Click New and fill in the fields.
- Click Save or Save and Exit to apply changes.
| Info |
|---|
You can also create a column this way:
Please note that in this case, you will need to fill in the Table field manually. |
Tabs specific for the text type columns
| Type Specification tab | ||||
|---|---|---|---|---|
| Field | Mandatory | Descritpion | ||
Max Length | N | Specify a maximum value length for this column. The value length cannot exceed allowed length for the specified data type. Fill in this field for the columns that have a String or Text type. | ||
| Default Value | ||||
| Use Dynamic Default | Select this checkbox if you want to generate the default value dynamically. | |||
Default Value | N | Specify a default value that will be populated automatically to the field when creating a new record. This field may be specified by a Javascript scenario as well. | ||
Dynamic Default | N | This field appears only when the Use Dynamic Default attribute is set to 'true'. Select the script from the Dynamic Default Values (sys_default_value_dynamic) dictionary, so its execution result will be automatically calculated and entered into this field; this value will be the default value for the column specified.
| ||
| Table of Contents | ||||||
|---|---|---|---|---|---|---|
|