In a formula column, the CONCAT() function concatenates the content of several columns, with the option to insert free text.
-
Name of the text function:
CONCAT()
Syntax
CONCAT(item_1, item_2, ...)
Calling function parameters in TimeTonic:
- $field_name = field (link, linked table column, number, selection, formula, text...).
- "free text" = free text to add between quotation marks.
- do not use quotation marks for numbers.
Parameters
| Parameter | Description |
|---|---|
item_1, item_2, ... |
The columns and/or free-text strings to assemble, in the desired order. Free text goes between quotation marks. |
Example
To assemble a first name and a last name separated by a space:
CONCAT($First name, " ", $Last name)
Result: "Marie Dupont"
Return type
The function returns a text string.
The output format of the result can be configured in the output field options of the formula editor. For more details, see Output format options in the Formula column article.
Business use case
CONCAT() builds readable labels from several fields: full name, assembled reference (type + year + number), single-line address.
Best practice
Mind the separators: explicitly insert spaces, dashes or commas between fields, otherwise the values will run together.
Result