TEXTJOIN Function: Difference between revisions

From Planfix
Jump to: navigation, search
Line 30: Line 30:


== Go To ==
== Go To ==
*[[Функции]]
*[[Standard functions|Formulas]]

Revision as of 08:24, 8 May 2024

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 [UNIQUEFunction|UNIQUE()]] function to the TEXTJOIN() function:

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

Result:

Mike + Peter

Go To