How can I concatenate from a repeat into the parent?

Question

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???

MichelleWilliamsERM · Accepted Answer

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!!!