XLSform Summary of Repeats
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?
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?
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?
No this is not the way. You have the field listed in there twice. Think of it as filling a box then stacking the boxes.
Inside the repeat you could have concat(all your fields).
Then outside the repeat it would be join("\n", ${the concat field above}).
In your example that last line should just be join("\n", ${totals}) No need to have the fields twice like that.
You can get a little fancier with it also so it lines up better using Grid.
Like this. So you skip the whole concat thing and just do a join on each field - one in each grid cell with a \n. Since they are in order they just magically line up. It will probably look nicer.
Try both and see which you like.
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?
