topic Re: Survey 123 Pull Repeat data to Report Template in ArcGIS Survey123 Questions

Survey 123 Pull Repeat data to Report Template

MatthewYuen — Thu, 09 May 2019 23:18:31 GMT

Hi,

I want to pull specific data out of the repeat option for the word template, but it looks like it pulls every row at the moment.

For example, if have 3 repeats, it will pull photo description for all 3 loop.

${#Photograph}

${photo_description}

${/Photograph}

Lets say each description has a value, and the value is test1, test2, test3

In this case, if I used the command above, I would get this as return

test1

test2

test3

What I want is to only pull the value of test 2. I want to be able to pull specific data I wanted on a specific loop. No calculation, just values.

What I have right now is a bunch of photo and photo description in a repeat, and I want to be able to pull the pictures 1 at a time so I can setup the word template neatly. Does that make sense? Not sure if this is possible with survey123 template management at the moment.

Thanks,

Matthew

Re: Survey 123 Pull Repeat data to Report Template

ChrisMontague-Breakwell — Fri, 10 May 2019 16:13:28 GMT

Hi Matthew,

I'm not sure how to pull individual datum from one of a set of repeats, but if you're trying to format repeat photos neatly in a report see my attached template as an example. (One difference from yours, I think,: I didn't include the "photo description" in the survey as my staff prefer to type that in once they get the word document report, but there's no technical reason it couldn't be done.)

Chris

Re: Survey 123 Pull Repeat data to Report Template

Anonymous User — Fri, 10 May 2019 20:09:46 GMT

One thing that might help is to add within your repeat a photo question for each of the photos; in your case Photo1, Photo2, and Photo3, as this is will start the name of the photo with each of those names.

Then within the Custom Report Template you might be able to use a conditional statement for where you want each of the photo1, photo2, and photo3 is placed within the template. You could even add in some coding to keep or force the size of the photo within each of the boxes or area that you would like to have the photos placed. Then underneath each of the photos you could pull your description.

Hope this helps you out!

Cheers,

Mike

Re: Survey 123 Pull Repeat data to Report Template

JamesTedrick — Fri, 10 May 2019 20:13:17 GMT

Hi Matthew,

One possibility would be to use a conditional statement to only show the data of a repeat when there is a certain value - refer to teh conditional elements section in Feature report templates—Survey123 for ArcGIS | ArcGIS . If you're wanting to get something like 'the second repeat', that is a bit harder - you would want to have a hidden field with a calculation of once(count(${q}) + 1) where ${q} is a question in the repeat - that will let you store an index of the repeat.

Re: Survey 123 Pull Repeat data to Report Template

JenniferK — Tue, 14 Jan 2020 14:26:56 GMT

Hi James,

Once I have the once(count()+1) set up, what is the syntax to reference a specific count in my report?

Thank you!

Jen

Re: Survey 123 Pull Repeat data to Report Template

JamesTedrick — Tue, 14 Jan 2020 18:53:16 GMT

Hi Jennifer,

You would access it using whatever field name it is in the report, just like any other field - it works the same as every other field/question.

Re: Survey 123 Pull Repeat data to Report Template

JenniferK — Tue, 14 Jan 2020 21:05:52 GMT

Sorry James, my question was overly ambiguous.

Currently I have my feature report set up to pull from my repeats as ${#Survey_1}${field_name}${/Survey_1} but the output I get there is all 40 of the repeat answers for field_name. I'm trying to pull out the information for repeat 1, then repeat 2, then repeat 3, etc to create a report that reads consecutively across each repeat rather than an aggregate of all 40 repeats in each field.

I implemented the once(count()+1) row that you suggested above, and I can see the row works perfectly in the exported xlsx but can't figure out how to use it to reference the fields from the rest of that row of data for the feature report. Can you provide an example of the syntax I would use to do this?

Re: Survey 123 Pull Repeat data to Report Template

JamesTedrick — Fri, 17 Jan 2020 19:45:56 GMT

Hi Jennifer,

It sounds like you want to make the repeat section larger than just one field at a time. Within the ${#Survey_1}${/Survey_1} section you can have whatever formatting you want, allowing you to create a mini-section within the report that includes multiple fields, tables, etc. You can also use the repeat section at the start/end of a table row to print the repeats in a table.

Re: Survey 123 Pull Repeat data to Report Template

JenniferK — Fri, 24 Jan 2020 22:20:02 GMT

Hi James,

Yes, my repeat section is larger than one field. What I have currently in my survey is a set of non-repeat questions, and then repeats:

select_one District

eval_date

begin repeat Survey_1

testrep

autofill once(count(${testrep})+1)

field_1

field_2

field_3

end repeat

That section has a count of 40 to repeat across 40 assessment areas. What I'm trying to accomplish is a feature report template that can be auto-generated by Integromat once the 40th count is completed. I need the report to present the data in each individual assessment, so if the answers at assessment #1 are Spruce, healthy, 100%, and the answers at assessment #2 are Pine, diseased, 20%, I want to have a feature report that says

Sample Assessment in District 5

Date: 1/24/2020

Sample 1: Spruce

Status: Healthy

Intact Bark: 100%

Sample 2: Pine

Status: diseased

Intact Bark: 20%

When I set my template up, it looks like this:

Sample Assessment in ${District}

Date: ${eval_date}

Sample ${autofill}: ${#Survey_1}${field_1}${/Survey_1}

Status: ${#Survey_1}${field_2}${/Survey_1}

Intact Bark: ${#Survey_1}${field_3}${/Survey_1}

Sample ${autofill}: ${#Survey_1}${field_1}${/Survey_1}

Status: ${#Survey_1}${field_2}${/Survey_1}

Intact Bark: ${#Survey_1}${field_3}${/Survey_1}

But my output looks like this:

Sample Assessment in District 5

Date: 1/24/2020

Sample 1 2: Spruce Pine

Status: Healthy diseased

Intact Bark: 100% 20%

Sample 1 2: Spruce Pine

Status: Healthy diseased

Intact Bark: 100% 20%

I'm having an easy enough time finding the data using the query function with ${field_1} where ${autofill}=2, so it seems possible, I just can't get the syntax right to pull it into a feature report for automation.

Re: Survey 123 Pull Repeat data to Report Template

JamesTedrick — Fri, 31 Jan 2020 21:13:45 GMT

Hi Jennifer,

Taking the template code you posted above as a sample, here's how I would alter to produce what your are specifying:

----------------------------------------

Sample Assessment in ${District}

Date: ${eval_date}

${#Survey_1}

Sample ${autofill}: ${field_1}

Status: ${field_2}

Intact Bark: ${field_3}

${/Survey_1}

----------------------------------------

Note that the repeat section is treated more like a block of text, with multiple fields specified within it.

Re: Survey 123 Pull Repeat data to Report Template

LiudmilaMaslova — Tue, 15 Sep 2020 14:42:51 GMT

Hello, James
How would I pull specific repeat out of my printed responses? Because right now, it pulls every row to the form. Is there any conditional statement I can use to show one repeat or the other? I have used ${if select_one yes_no | selected:"Yes"} or ${if select_one yes_no | selected:"No"} finishing repeat with ${/}to try to separate both repeats, did not work.

Thank you

Re: Survey 123 Pull Repeat data to Report Template

JenniferK — Tue, 15 Sep 2020 17:11:53 GMT

Hi Liudmila,

I ended up figuring it out for my survey thus:

${#repeat_name}$${/repeat_name}

Hopefully that helps you, too!

-Jennifer

Re: Survey 123 Pull Repeat data to Report Template

Tiff — Thu, 27 Apr 2023 14:03:53 GMT

Hi @JamesTedrick, is there something similar for only obtaining the most recent repeat and generating a report? Say, for inspections that are done periodically, our use case is when our team conducts inspections, an email notification is generated for that one repeat record and sent to those who manage the asset. Right now as others stated, we would not want all repeats to be put into one report, and don't want to accidentally send out the wrong one either.

In addition, what makes it more complicated is that we don't only have one photo question, we have a dozen photo questions and respective questions to assess violations/compliance/guidelines etc. It will likely be a fairly long report for just one related record.

Please let me know if you have any suggestions!

Re: Survey 123 Pull Repeat data to Report Template

Raul — Fri, 23 Jun 2023 20:57:14 GMT

I think I've found a solution to the OP. This took me a while because I wanted to display ONLY the last repeat and not the nth repeat collected.

For my solution, I'm keeping track of how many repeat records are being collected in survey123, my sheet looks something like this:

type	name	label	...	calculation	bind::esri:fieldType	bind::esri:parameters	bind::type

...	...	Other fields in main FeatureClass

begin repeat	my_repeat	My Repeat I				query allowAdds=true
image	my_repeat_image	Image relevant to this collection
text	comment_my_repeat	Comments
end repeat

calculate	repeat_count	total_repeat_count		count(${my_repeat})	esriFieldTypeInteger	calculationMode=always	int

query AllowAdds=true was used because this repeat is accessed via inbox, this prevents users from deleting previous collections in the repeat. You may nod need it if you're not using an inbox.

Then for my report template I used something like:

${#my_repeat} ${if ($feature|getValue:"position") == $layers[idx].repeat_count} ${my_repeat_image | size:200:200} ${comment_my_repeat} ${/} ${/my_repeat} // Where idx is the index of the main layer, usually 0.

In OPs case, tracking the last submitted repeat record isn't even required, you could do something like:

${#my_repeat} ${if ($feature|getValue:"position") == 2} // Display the fields you want ${/} ${/my_repeat}

Re: Survey 123 Pull Repeat data to Report Template

AnthonyJonesRSK — Fri, 16 May 2025 17:29:52 GMT

Hi Raul, I just wanted to say a big thanks for posting your solution, it was a life saver for me for an issue that I raised on the forums a couple of years ago. In my case I was trying to filter my repeats to the latest one using the orderByFields option on my objectid or creation date fields and then limiting it to one record using resultRecordCount. Unfortunately, the orderByFields seemed to cause an error so your workaround of counting the repeats in a field in the form and then using that in an if statement has worked a treat. Cheers