Tips and Tricks
Joins an unknown number of values together, and separates each with one or more specified characters. This is useful for creating lists from a data set, commonly these would be comma separated.
For example, consider a data set containing a list of countries. The Join() function can convert that data set into a comma separated list, or a list divided into separate paragraphs for creating a bullet list in the document.
Join( s, r )
The Separator is used to separate the items in the second parameter.
This is a reference to a question in a repeating page, repeating section or multiple row data source
The example below creates a comma separated list of countries.
Design Format Formula