Page tree
Skip to end of metadata
Go to start of metadata

_concatenateStrings

Use the following syntax to concatenate field values with other text strings. For example, inserting a field value into a sentence.

Syntax

$formula(concat("x",$field,"z",...))

The variables may be text strings, field variables, or other formulas and variables.

Text strings must be surrounded in "double quotes" while variables and formulas do not.

Often, a shorthand can be used to combine variables and strings, provided the first piece is a string.

"x"+$variable+"z"+...

Examples

Example formulaOutput
$formula(concat("Your account representative is ",$account_rep,"."))Your account representative is Hector Gomez.
$formula(concat($company_name," Support Contract"))
Agiloft Support Contract.
""+$field1*$field2+" Total"2,142 Total

CONTENTS
  • No labels