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

    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.

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 lengthIn 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:

  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.

FieldMandatoryDescritpion
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.

Note
  1. The script must be preliminary created in the Dynamic Default Values (sys_default_value_dynamic) dictionary; otherwise, you will be not able to choose it.
  2. You can choose only active scripts (the Active attribute is equal to Yes).



Table of Contents
absoluteUrltrue
classfixedPosition
printablefalse