How can I concatenate from a repeat into the parent?

[MichelleWilliamsERM]

I have a related table, the child is a photo with a comment text field.

As an inspection is complete there might be 3 photos with 3 text fields populated, I'd like to concatenate all three comments into one answer into the parent. 

Instead of concat(value1, value2, …)

I'd like to concat(${repeat}) - I tried this and I only get the last comment

Does anyone have any ideas???

[jcarlson]

For concatenating strings in a repeat, try the join function. From the S123 docs:

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

So you could use join(${photo_comment}, ', ') to get them all in one string of text.

[MichelleWilliamsERM · Accepted solution]

Thank you @jcarlson, the code you gave me didn't quite work in the new version of Connect, but I was able to find another version that did work; join(', ', ${PhotoComment}).    

I couldn't have found it without your help. I will use this all the time!!!