Skip to main content

Search

Let us guide you!

CONCAT() : concatenate text (combine fields)

Updated on

In a formula column, the CONCAT function combines the content of several columns, with the option to insert free text, and 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.

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
1 item_1, item_2, ... The columns and/or free-text strings to assemble, in the desired order. Free text goes between quotation marks.

Examples

Combine a first name and a last name

To assemble a first name and a last name separated by a space:

CONCAT($First name, " ", $Last name)

Result: "Marie Dupont"

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.

Go further

CONCAT_URL

The specialized variant: combine and turn the result into a clickable URL.

Read more →

Or continue with

Formula glossary

All available operators and functions, sorted by category.

Read more →