Exporting Multiple Lines Text Fields to HTML

From SmartWiki
Revision as of 09:45, 30 April 2013 by Arthur Lathrop (talk | contribs)

Jump to: navigation, search

If you wish to include a Multiple Lines Text field in a report that will be displayed or exported to HTML, the line breaks will not be displayed.

The line breaks stored in the Multiple Lines Text field can be converted to a line break that will be displayed in HTML (<br />) by including the following in the Calculated Value of the field:

REPLACE([this],CHAR(13,10),"<br />")