Monthly Archives: October 2011

Tips and Tricks #9

Scripting multi-line descriptions

You can easily get multi-lined descriptions by doing it the manual way by right clicking on the column name, going to properties, and changing the alternative column title:

But how do you script this action? Try using the following format:

DEFINE FIELD SaleType2 COMPUTED
AS "Sale;Type"
SUBSTR(ltrim(SaleType),1,1)

Of course, your expression will be different than ours, but the key is the second line where the semicolons are used as line breaks. The result: