Select to view content in your preferred language

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

109
1
a week ago
WilliamSteinley
New Contributor

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("\n", ${tree_number}, "|") + join("\n", ${dbh}) + join("\n", ${height}, '|')
0 Kudos
1 Reply
abureaux
MVP Regular Contributor

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("\n", ${join_tree_num}, "|", "\n", ${join_dbh}, "\n", ${join_height}, "|")

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

abureaux_0-1719250927572.png

 

0 Kudos