Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
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. |
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 the Creating a column section of this 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 | 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 the Creating a column section of this 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. |
Info |
---|
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 section of this 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. |
Info |
---|
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 section of this article.
Creating a columnTip |
---|
Role required: admin. |
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
Max Length
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
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.
Image Removed
Dynamic Default
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.
Column article.
Table of Contents | ||||||
---|---|---|---|---|---|---|
|