Multi-line-Text Columns
Using Multi-line Text Columns you may enter data containing a long description, for instance, project notes, customer address, product description etc.
If a column comprises the data that don't look or behave the way you want, you may edit column General Properties and the properties defined by the column type.
General Properties:
Properties defined by the column type:
Configuring the Specific Properties you may set the number of data lines, specify the form of data entry and select an appropriate text format.
Multi-line Text Options |
|
Column Property |
Description |
Lines to edit |
This property allows a user to set the number of data lines that will be presented in the multi-line text field. By setting the Lines to edit value a user specifies the display height of the column cell; at that the number of characters entered in the field is not restricted. Please note that this field is required. |
Lines to display |
This property allows a user to set the number of data lines that will be presented in the table or on the form, the other lines will be hidden. For instance, you can display only two lines, to review the other lines, you need to click on the More… button.
|
Data Entry |
This property allows a user to specify the form of data entry:
|
Format |
For example, you want to add and view the following data in the “Notes” Text-Multiline column.
The Format property allows a user to select an appropriate text format for displaying data in the Text-Multiline columns.
If the Simple text option is set, the “Notes” data can be displayed in the following way
If the Preformatted option is set, the “Notes” data can be displayed in the following way
If the Markup option is set, the “Notes” data can be displayed in the following way
|
Help |
When the Help text property is filled in, the question mark is displayed near the field name on the View/Edit form. If you point to this question mark, the pop-up with a tip or a help text message will be shown. |
There may be times when you find out some incorrect values stored in the Append Only (or the Prepend Only) Text-Multiline column, but you are not able to correct them in a simple way. To edit the mistakes you can temporarily change the Data Entry mode to Type-In , correct the mistakes and then revert it back to the Append Only (or the Prepend Only) property.
How to update Append/Prepend multi-line-text columns by assignments
The Append/Prepend option is in effect only for the user mode. Therefore assignments added to custom buttons and workflow actions always overwrite all the content of a multi-line-text field. To avoid this, the following simple workaround can be helpful:
In the assignment you should concatenate a new value with an existing value of the multi-line-text field. For example:
List("\n", "Prepend", [Multiline Text])
-- or --
List("\n", [Multiline Text], "Append")
The bold timestamp line used in a Append/Prepend multi-line-text column is just another line of text which is enclosed in brackets and has a time part formatted in a special way. Here is the formula allowing to build such timestamp line:
"[" & Replace(XMLFormat(ToTimestamp(Today(),ToTimeOfDay(Now()))), "+00:00", "Z") & " " & UserToName(User()) & "]"
For example, if you need to prepend some text to a multi-line-text column via assignment, you can use the following formula:
List("\n", "[" & Replace(XMLFormat(ToTimestamp(Today(),ToTimeOfDay(Now()))), "+00:00", "Z") & " " & UserToName(User()) & "]", "text to prepend", [Multiline Text])
In case you need to append some text to a multi-line-text column via assignment, you can use this formula:
List("\n", [Multiline Text], "[" & Replace(XMLFormat(ToTimestamp(Today(),ToTimeOfDay(Now()))), "+00:00", "Z") & " " & UserToName(User()) & "]","text to append")
Next: Numeric Columns