Hoping I can maybe get some help with brainstorming here...I am working on a survey design but having some issues with how to populate the information into the report template.
I have a repeat that the users will enter information in as they collect data in the field, so it would be safe to assume they will be entered in chronological order. However, in the final report template, these answers need to be grouped in a way that isn't chronological, so it's not as simple as just printing out the repeat data into a table.
Here's an example of the table - you can see that the order in which they were collected (green numbers) are different than the order they are printed. They are grouped so that there is a background and a compliance measurement for each water column strata (bottom, mid-depth, and surface). This is done usually three times a day (so 18 table rows total) but could potentially be much more so I need to allow for that in the survey.
One idea I had was to try reformatting the survey schema so that each repeat record had questions for the background measurement and compliance measurement, and then the user would just have to navigate to that record in the repeat when they wanted to fill out the rest of it. However, I need coordinates for both points, and I can't have two geopoint questions in a single repeat...
I know that's a lot, but....any ideas are appreciated! Not opposed to using a JS function, but still need to think things through a bit.
Best,
Katie
“The goal is not simply to ‘work hard, play hard.’ The goal is to make our work and our play indistinguishable.”
- Simon Sinek