Column type Text

This type is used for text storing. Max. text length can be defined for the column (property Max. text length and default value 255 characters). When no length is defined, it is considered that as a text of a maximum length which is cca 2^31-1 bytes (2 GB).

Properties

Common properties for all three column types. 

Name	Description
Use as a reference	When checked off column name in the detaild form will work as a link. URL, to which the user will be redirected, will be created from the from the value of this column and Link format.
Link format	Link format (see hereinafter).
Name of window for the link	The link is opened to the same window by default, in which current page is displayed. When filling in this value, the link will be opened into another window.
Enable opening the link in a list	After setting text in the list of records will work as a link.
Min. text length	After setting record cannot be changed, if it does not have a defined minimal number of characters.
Max. text length	After setting record cannot be changed, if it does not have a defined maximal number of characters.
Enable sequences	After setting a numeric sequence is generated in the column. User cannot changed a generated value.
Sequence format	Format for the appearance of the generated sequence.
Enable for global search	When enabled column will be searched at global search.
Regular expression	Regular expression for validation of the input value.
Error message from regular expression	Error message that is displayed if the input value does not correspond with Regular expression.

 Properties of a long text

Name	Description
As HTML	After setting text can edited as HMTL including font formatting (colours, sizes), inserting tables, links and indents...HTML editor is displayed.
Css content class	CSS class for using specific text styles. It enables to set formatting in editor. This function is used e.g. in the model Knowledge Base.
Url of the file with styles	Url to the file with css styles.
Mode of added comments	Mode, when only a new comment can be added to the text. This text is appended to an already existing text. This means "step-by-step commenting", when the original text cannot be altered. Each comment is introduced with a name of the user and time of the comment creation.

Link format

It determines, wheather values in the column will be interpreted as a whole link and its part only.

Example:
'{#}' - value from the column represents the whole link
'http://www.company.com/index.aspx?text={#}' - value from the column represents part of the link only

Text {#} is replaced by the value from the column.

Value in the column is an expression. Therefore, functions like e.g. Column can be used and also values from other columns can be inserted in the link. This behaviour is suitable especially in queries, where you can create URL for navigation to another page.

Name of window for the link

You can use whatever text or standard names (HTML definition) as a name:

 

Name	Description
_blank	new window or a new tab
_top	highest frame window
_parent	superior frame
_self	same frame

Mode of added comments

In this mode you users can only append a new text (comment) in the text column. User cannot changed an already appended text. Each comment is introduced with a name of the user and time of the comment creation.

Regular expression

By means of regular expression you can set check of the input text. Format of the regular expression corresponds to the definition by Microsoftu.

You can find couple of examples here https://msdn.microsoft.com/en-us/library/ff650303.aspx.

Example of the control

The picture shows 1) a single line text field, 2) a multi line text field, 3) column with set indication Mode of added comments, 4) column with set indication As HTML

Editing source html code

Html editor enables the user to edit also html code. If you want to prevent that, you can hide the button for source code editing by a script in the class detail. Below example hides the button for the column with code new_text.

Script for data detail:

function OnPreRender()
{
   OGColumns['new_text'].ColumnUI.ShowSourceButton = false;
}