topic Re: Report Export formatted like spreadsheet for multiple survey responses in ArcGIS Survey123 Questions

Report Export formatted like spreadsheet for multiple survey responses

Re: Report Export formatted like spreadsheet for multiple survey responses

Re: Report Export formatted like spreadsheet for multiple survey responses

Re: Report Export formatted like spreadsheet for multiple survey responses

Re: Report Export formatted like spreadsheet for multiple survey responses

littlebluepenguinnz — Fri, 22 Oct 2021 23:17:26 GMT

Hi there,

I am wanting to export out a report that lists each survey response by row, rather than individual reports.

This is an example of what I mean. Normally, the survey results are exported as a pdf from an Excel spreadsheet.

Is this possible? There will be rows and rows of these responses.

elpinguino — Sat, 23 Oct 2021 08:50:01 GMT

Screenshot 1 shows the progress I've made so far by reading this documentation. I want the records to continue listing rather than the header section appearing each time.

Screenshot 2 is of the Survey123 website in the data section. I'd like to have it exported similar to that. I've also attached my latest template.

elpinguino — Sat, 23 Oct 2021 21:03:02 GMT

I'm almost there, but was wondering if someone who understands code a bit more could point out what I'm doing wrong here. I've attached my template. This is the error I'm getting.

DeonLengton — Mon, 25 Oct 2021 07:14:00 GMT

We had a similar requirement and I have a solution in my head that I still need to put into reality:

If you create a dummy "main" feature layer and capture your records into a repeat (related table) then you could get this to work using the repeat reporting functionality...

But like i say i havent done it yet

Survey response

First name

Contact Type

Stakeholder Group

elpinguino — Mon, 25 Oct 2021 18:41:55 GMT

Thanks Deon. I am using a related table, so that could work for me. Could you show me how I'd write that out though to capture the operation name and date? I'm not so good with code. I have the template attached in the original post.

For now, I'm exporting it as a word doc, and then the user will have to manually open up in word and change those lines.