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 Type | Description | Scalar Type | Length | Validation 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:
|
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). | text | Not set | This 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. | varchar | 255 symbols | This 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. | text | Not 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. | text | Not set | This field can contain all kinds of symbols |
Create a text type column
| 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.
|
