Per boss's request, I need to make a survey that is broken into 3 different Test Well sections, where each Test Well has an associating list of Monitoring Wells. Basically, field tech will choose the Test Well 1 and fill out a few sections of different field measurements. After they fill out that info, they need to go to each Monitoring Well associated with Test Well 1 and fill out more field measurements. So which Test Well they are working on determines what Monitoring Wells will appear in the survey.
Originally, I thought about just creating 3 separate groups within one survey (Test Well 1, Test Well 2, Test Well 3) and then within each group will be its respective Monitoring Well options, but I am worried about how that may export to AGOL and Excel (I wouldn't want one long, continuous row of data each time the survey is submitted, I would want the excel sheet breaking it up into 3 separate rows or sheets.
I was trying to figure out a way to use pulldata() or begin repeat or if, then statements to set this survey up, but I haven't been able to figure out how to have a select_one TestWell lead to select_one Monitoring Well respective to that Test Well and not all 3 Test Wells.
Is the best way just to do 3 separate surveys and then do begin repeat with pulldata() from an excel file?