CONCAT

Use CONCAT to join two or more text values into one text value.

Use

CONCAT( text1, [text2], ...)
Joins several text items into one text item

Parameter	Required	Description
text1	Yes	The first item to join. The item can be a text value, number, or cell reference.
text2, ...	No	Additional text items to join.

Returns

'Text'

Examples

Combining Name Fields for an Activity

This is a common use case for Input Mapping formulas, where you take separate data items collected in a previous step and merge them to display on a form for a reviewer.

• Formula: CONCAT(@LocateCustomer.out.Forename, " ", @LocateCustomer.out.Surname)
• Logic: This formula joins the output data @LocateCustomer.out.Forename, a literal space " ", and the output data @LocateCustomer.out.Surname.
• Result: If the forename is "Jane" and the surname is "Blogs", the function returns the text value "Jane Blogs".

Joining Literal Text Strings

You can use CONCAT with literals (exact values enclosed in double quotes) to build specific strings or messages within your approval logic.

• Formula: CONCAT("The Sun", " ", "is Shining")
• Logic: This formula joins three separate text literals into one continuous string.
• Result: The function returns the text item "The Sun is Shining".

Pro Tip: You can also use the ampersand (&) operator as a shortcut for concatenation. For example, the expression "North" & "wind" would result in "Northwind".