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.