Thursday, 23 of February of 2012

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 semi colons are used as line breaks. The result:


Leave a comment

You need to be loged to make a comment