nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

XLSform Summary of Repeats

WilliamSteinley

Hello everyone,

I'm attempting to make a summary section for my repeat and I'd like it to be similar to the below example. As surveyors add trees and data into the repeat they need an easy way of seeing what they have already collected.

I've tried in XLSform to use the functions, count(${tree_number}), sum, and others and cant seem to make a solution work. count works for 1 question but I cant make the field count multiple questions like I thought.

any advice?

Screenshot 2024-06-20 133747.png

Vind meer berichten getagd met

Accepted answers

All comments

dougbrowning

I do it using a grid and join. See this post https://community.esri.com/t5/arcgis-survey123-questions/getting-two-previously-entered-values-to-display/m-p/1402256

Hope that is what you mean

WilliamSteinley

thanks for the help, its got me much closer to solving this problem.

my issue now is that once I try to add a second repeat form, the previously copied concat info disappears.

not sure how to make the join solution work?

Screenshot 2024-06-20 141300.png Screenshot 2024-06-20 141311.png

Screenshot 2024-06-20 141616.png

dougbrowning

Move that concat inside the repeat then a field outside the repeat using join on that concat field.

WilliamSteinley

Almost there. thanks so much for your help thus far!

do you know how i can get the numbers to display horizontally like the original example in my first post?

Screenshot 2024-06-20 143259.png

WilliamSteinley

Almost there. thanks so much for your help thus far!
do you know how i can get the numbers to display horizontally like the original example in my first post?

WilliamSteinley

I've tried all kinds of combinations to get the output as a horizontal column format, can I use the join function twice without applying math formulas to it?

I tried this with no success.

join("\n", ${tree_number}, "|") + join("\n", ${dbh}) + join("\n", ${height}, '|')

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.