formulamerge
TEMPLATE
,
RESULT

The formulamerge statement merges data into a template.


Parameters

This statement has two parameters:

template – Text of template.

result – Output text (each formula has been replaced by its value).


Description

This statement merges data into a template. Within the template you can place formulas inside { and } characters.

This example assumes that the database has fields named Name, City and State (or that there are variables with these names).

local Letter
formulamerge "Dear {Name},"+cr()+cr()+
    "I am planning a visit to you in {sandwich("",City,", ")+State} next week.",Letter

The end result will be in the Letter variable, and will look something like this:

Dear John Watson,

I am planning a visit to you in San Francisco, CA next week.

If there is an error in the template the result will be:

FormulaMerge Error “error message” Template “template”.

See Also


History

VersionStatusNotes
10.0No ChangeCarried over from Panorama 6.0.