You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

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

You can limit the maximum number of symbols with the Max Length attribute. 

Field TypeDescriptionScalar TypeLengthValidation criteria

Phone

This field stores a phone number.

In SimpleOne interface, it is displayed as an input field with the phone number.

varchar

15 symbols

Phone validation criteria:

  • May contain: (+-), spaces and 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).

textNot setThis field can contain all kinds of symbols.

String

This field type is physically implemented as a string 255 symbols length.

In SimpleOne interface, it is displayed as a text input field.

varchar255 symbolsThis field can contain all kinds of symbols.

Text

This field type is physically implemented as a lengthless text string. The memory is allocated dynamically when processing the field.

In SimpleOne interface, it is displayed as a textarea.

textNot set

This field can contain all kinds of symbols

Journal Input

This field type is used to operate with the comment widget for the intermediate data storage when the comments are being added. It is implemented as a text-area with a placeholder of the field title.

As a rule, it has the NULL value. When a comment is being added, the field value saves the following data to the sys_activities_stream_field table:

  • reference to the commented record
  • reference to the table containing this field
  • the comment itself
  • commentator's name (the user who has added the comment)
  • field name.

After the comment is saved the field value becomes NULL again.

textNot setThis field can contain all kinds of symbols

Create a text type column

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.

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


  • No labels