TEXTJOIN Function

From Planfix
Revision as of 13:36, 14 May 2024 by Aliona (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

TEXTJOIN() Function combines values in a list with a predefined delimiter.

Format

TEXTJOIN (delimiter;ignore_empty;multiplied_variable)

Where:

  • ignore_empty — valid values are 1 (yes) and 0 (no).

Example

%%%TEXTJOIN("; ";1;{{Task.Assignee.Name}})%%%

The result will be a string in which the elements from the variable are stored through the delimiter:

Robot 2; Tomas

Important

You can pass the result of the UNIQUE() function to the TEXTJOIN() function:

%%%TEXTJOIN(" + ";1;UNIQUE({{Data tag.Actual working time.Employee.Name}}))%%%

Result:

Mike + Peter

Go To