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"
Updated 11 months ago