_concatenateStrings
The concatenate strings command allows you to combine field values with text strings, field variables, or other formulas that use variables. For example, if you use $formula(concat("x",$field_name,"z",...)), the " It can also be used when inserting a Choice field value, if the value is rendered as code such as 1@2 rather than the text of the value. To do so, enter the value as the only parameter. The variables may be text strings, field variables, or other formulas and variables. Text strings must be surrounded in double quotation marks (""), while variables and formulas do not. If the first piece is a text string, you can use shorthand to combine variables and strings, but $formula() is still required in email templates:x
" and "z
" placeholders are where you insert text strings, field variables, or formulas.Syntax
$formula(concat("x",$field,"z",...))
$formula("x"+$variable+"z"+...)
Examples
Example formula Output $formula(concat("Your account representative is ",$account_rep,"."))
Your account representative is Hector Gomez. $formula(concat($company_name," Support Contract"))
$formula(""+$field1*$field2+" Total")
2,142 Total $formula(concat($contract_start_date," to ",$contract_end_date))
09/01/19 to 08/31/2020