1. Column type Text

    Article: AN0001617Updated: 09.10.2018

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


    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.

    '{#}' - 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;