1. What is the issue? Please be detailed.
We have launched a survey with several loops, but when the data comes into the Google sheets, the loops are spread across multiple tabs. I either need to fix this to where all data comes into one tab, according to the parent key ID or I need to figure out how to merge data across tabs when there are more than one entry per parent key on the various tabs.
Ex: one person has multiple children and we create a child loop with data entered on each child. I need all of that data to be on the one line of the main survey tab.
Is there a way to download the data from ODK into one sheet/tab or code it in the form to do so? Or, I can't seem to find a way to get the data (from merging queries) all on one tab without duplicate entries for loops having the same parent key/ID.
2. What steps can we take to reproduce this issue?
3. What have you tried to fix the issue?
4. Upload any forms or screenshots you can share publicly below.