TextJoin Function

Description

Join strings in an array and insert the specified delimiter between each string value to be joined. The array returns an empty string if there are no elements.

The function takes three arguments.

• Argument 1: Specify the delimiter (string). If you want the strings to be contiguous without separating them, specify the empty string “”.
• Argument 2: Specify if empty elements in the array should be ignored. “YES” or “TRUE” means to ignore; otherwise, do not ignore them.
• Argument 3: Specify an array of strings to join.

Usage Examples

The following example joins the item names selected in the Checkbox field, separated by commas.

= textjoin(",", "no," Checkbox)

関連記事

• Merge Results of Fields with Multiple Values, such as Checkboxes
• Setting Checkbox Items to Multiple String Lines with a New Line
• Storing Table Values Outside the Table for Improved Readability in List View
• How to Get Records That Match Any of the Specified Conditions
• How to Set up Auto-Ranking Based on Input Data