syntax to use multiple join() functions in one calculation cell

Question

I'm trying to use join multiple times in once calculation cell. using the code below applies a math formula to it. what syntax should i use?

join("
", ${tree_number}, "|") + join("
", ${dbh}) + join("
", ${height}, '|')

abureaux · Answer

That's not how join() works. See Formulas.

join(separator, question)

Concatenates all answers to a given question in a repeat, separated by the given separator.

join(',', ${question_in_repeat})

You should have three separate calculates for those three joins. Then, use concat() to combine all of the joins and plain text. General example:

concat("
", ${join_tree_num}, "|", "
", ${join_dbh}, "
", ${join_height}, "|")

Also, don't mix quotes. Use either single or double.