TEXTJOIN Function: Difference between revisions

From Planfix
Jump to: navigation, search
No edit summary
No edit summary
 
Line 8: Line 8:


== Format ==
== Format ==
'''TEXTJOIN('''delimiter;ignore_empty;multiplied_variable''')'''
'''TEXTJOIN ('''delimiter;ignore_empty;multiplied_variable''')'''


Where:  
Where:  

Latest revision as of 13:36, 14 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 UNIQUE() function to the TEXTJOIN() function:

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

Result:

Mike + Peter

Go To