ObjectGears Help

Forum   ObjectGears (Version:

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


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

This website is using cookies files to provide services and analyse visits. You agree with that by using this website.     Further information