CONCATENATE

Returns the concatenation of multiple values.

Description

NOTE: This can only be used on fields that store the values as a string. Fields like choice fields and classification sets store the values in an array. Please refer this example for combining arrays.

Parameters

var_args_values String (required) - Strings to append in sequence.

Returns

String

Examples

CONCATENATE("This ", "is ", "a ", "sentence.")

// returns "This is a sentence."
CONCATENATE(42, 31, 1)

// returns "42311"
CONCATENATE("Age ", "is ", 42)

// returns "Age is 42"

 

Did this page help you?