Is Join() function available in report summary section?

03-15-2022 03:16 PM
New Contributor III

I am working to create a formatted summary report for archeological field data. There were four field archeologists who collectively generated ~200 subsurface test records in a Survey123 field form. I'd like to include a comma-separated list of the surveyors' names in the report's summary.

The summary report includes a summary section that includes fieldwork date ranges and total subsurface tests so the summary aggregate functions seem to be working. I can't figure out how (or if it's possible) to code a comma-separated list of string values for the data's ${Excavator} field (e.g. Excavators: Bob Smith, Sally Jones, etc.).

I saw a reference to a Join(',', {Question}) function in the forums for the data entry form, but can't find anything on the report side of things. Does anyone have any experience with something like this? I can't imagine I'm the only one who's looking for a comma-separated list of returned string values.

Thank you all very much in advance!

0 Kudos
0 Replies