This function returns values from an array, a table, or a multiple-choice field one after the other separated by a comma in a text field or a text variable. It’s used to reflect the selected options of a multiple-choice field as a running text, for example in forms or print layouts.
It’s often used for intermediate steps within a script.
concat('Last name', 'First name')
Result: Böhmer, Frank (with Last name = Böhmer and First name = Frank)
join, which returns a string of all items of a given string array by a given separator.
Do you want to dive deeper into the topic? Take a look at the corresponding part of our video tutorial.