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 '-'.
Info |
---|
You can limit the maximum number of symbols with the Max Length attribute. |
Journal Input
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.
Info |
---|
You can limit the maximum number of symbols with the Max Length attribute. |
By default, journal input fields have the NULL value. When a comment is added, the field value saves the following data to the the Activities Stream Fields (sys_activities_stream_field) table:
- reference to the commented record
- reference to the table containing this field
- the comment itself
- commentator's name (of the user who added left the comment)
- field name.
After the comment is saved, the field value becomes NULL again.
There are two ways to leave a comment using the Journal Input column type:
via the journal input field:enter
Enter the text
in the field
.
Click Save or Save and Exit.
Section Image Modified
- 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.
Phone
This field stores a phone number. It is displayed as an input field with the phone number.
Scalar type is varchar. Maximum number of characters is 15 symbols.
The field can contain:
- '+'
- '-'
- round brackets
- spaces
- numbers.
Script
This field type is physically implemented as a lengthless text string. In SimpleOne interface, it is displayed as a CodeMirror widget (JS component that provides ability of the code editing in a browser).
Scalar type is text. Maximum number of characters is not set.
Info |
---|
You can limit the maximum number of symbols with the Max Length attribute. |
String
This field type is physically implemented as a string 255 symbols length. In SimpleOne interface, it is displayed as a text input field.
Scalar type is varchar. Maximum number of characters is 255 symbols.
Info |
---|
You can limit the maximum number of symbols with the Max Length attribute. |
Text
This field type is physically implemented as a lengthless a text string. The memory is allocated dynamically when processing the field. In SimpleOne interface, it is displayed as a textarea.
Scalar type is text. Maximum number of characters is not set.
Info |
---|
You can limit the maximum number of symbols with the Max Length attribute. |
Creating a text type column
To create a column of text type, perform the following steps:
- Navigate to System Definition → All Columns.
- Click New and fill in the fields.
- Click Save or Save and Exit to apply changes.
Tabs specific for the text type columns.
Field | Mandatory | Descritpion | ||
---|---|---|---|---|
Type Specification tab | ||||
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 | ||||||
---|---|---|---|---|---|---|
|