https://community.esri.com/t5/arcgis-survey123-questions/is-join-function-available-in-report-summary/m-p/1154084#M41331 <P>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.</P><P>The summary report includes a summary section that includes fieldwork date ranges and total subsurface tests&nbsp;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. <STRONG>Excavators:</STRONG> Bob Smith, Sally Jones, etc.).</P><P>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.</P><P>Thank you all very much in advance!</P> Tue, 15 Mar 2022 22:16:26 GMT archeomason 2022-03-15T22:16:26Z https://community.esri.com/t5/arcgis-survey123-questions/is-join-function-available-in-report-summary/m-p/1154084#M41331 <P>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.</P><P>The summary report includes a summary section that includes fieldwork date ranges and total subsurface tests&nbsp;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. <STRONG>Excavators:</STRONG> Bob Smith, Sally Jones, etc.).</P><P>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.</P><P>Thank you all very much in advance!</P> Tue, 15 Mar 2022 22:16:26 GMT https://community.esri.com/t5/arcgis-survey123-questions/is-join-function-available-in-report-summary/m-p/1154084#M41331 archeomason 2022-03-15T22:16:26Z https://community.esri.com/t5/arcgis-survey123-questions/is-join-function-available-in-report-summary/m-p/1569453#M60550 <P><a href="https://community.esri.com/t5/user/viewprofilepage/user-id/526507">@archeomason</a>&nbsp;did you ever find a workaround for returning a comma separated list in the report template?</P> Tue, 17 Dec 2024 18:27:51 GMT https://community.esri.com/t5/arcgis-survey123-questions/is-join-function-available-in-report-summary/m-p/1569453#M60550 JJ_Reyes 2024-12-17T18:27:51Z