Page History

Fields of text type store various kinds of characters. Exception is Phone type which allows spaces, numbers,  '+' and '-'.

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.

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

  1. Enter the text

  you want to send

  1. in the field

  and click

  1. .

  2. Click Save or Save and Exit.

     Section
     Image Modified

     
     

• via the Activity Feed module:
  1. Click
  click
  1. on the Activity Feed module
  , click on
  1. .
  2. Select the tab representing the message type
  , enter the text you want to send and click
  1. you need (in the example below, Work Notes, Additional Comments, Message).
  2. Enter the text.
  3. 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.

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.

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.

Creating a text type column

To create a column of text type, perform the following steps:

1. Navigate to System Definition → All Columns.
2. Click New and fill in the fields.
3. Click Save or Save and Exit to apply changes.

Tabs specific for the text type columns.