Good afternoon!
We regularly use ODK surveys from Excel to collect farmer group member data. This works really well except for the repeat function.
For example, one of the questions is, 'how many members of your household are in the same group?' If the answer is 2, then the next question is on repeat and asks for the details of each household member. Some will have no members, some will have 9. This functions well but for me the time-consuming part is then matching up the index numbers with the other household members when the data is downloaded on Excel.
These results are in a separate Excel sheet and one by one, I have to look at who answered ýes' to the initial question, scroll to the far right, fiind the index number and then search for those repeat household members on the other sheet, go back to the previous and match those names with others on the initial sheet. This is to be clear about doublecounting of households.
Now, to take this example one step further, I want to do an agribusiness survey of those group members and a nutrition survey for each woman of reproductive age and child aged 6-23 months in their households. So on the initial survey, the question will be, do you have any women aged between 15-49 in your household. If yes, then the number will be entered. Same for the children. And then the names which will be on repeat, depending on teh previous answer. Which will then link to an extra Excel sheet with index numbers in the results.
Then there are nutrition surveys for each woman and each child. The problem is that I can see no way of linking these surveys, so each time a woman starts a nutrition survey, we have to ask the same questions in the agribusiness survey, name, age, group name, location etc etc. And then the name of their household group member so we can match the 2 together.
If I make the repeat function for those surveys, then I will have the task of matching up the indexes of the agribusiness survey with each of the women's surveys and the answers to the women's surveys will be displayed vertically rather than horizontally on the second sheet, meaning it will be very difficult to extract the data from them.
Is there any way to extend a survey based on what was entered at the start so that the results from that second survey are not linked with an index number and a separate Excel sheet?
Oh, this question is hard to describe! My apologies, and many thanks to anyone who is able to unpack it!