I must carry out a household survey with ODK Collect. My problem lies in relationships one to many.I must register each member of the household with information about it. But I noticed that on the kobotoolbox.org server we can not retrieve information about household members. I would like to have help to solve this type of problem. thank you in advance
Design your household roster questionnaire in the survey tab using the following simple example sourced from http://xlsform.org
|integer||num_hh_members||Number of household members?|
Note: You will see your household roster data in a different sheet while downloading the dataset (xls format) after data collection.
I think, the questions are on the necessary unique ID relations between different data levels/modules: HH // HH Roster // Individual questions for each or selected members:
- How the (repeating) roster data will be related to the HH
- And how further individual data, will be related to members of the roster (1 :: 0…1) …
We posted a similar topic
Structure and navigation for KoBoCollect (HH Roster, Individual questionnaires, etc.)
I have responded to the issue on the other forum component you had indicated. This is a repeat of the same though.
When you need to do a complete household roster with all the functionalities mentioned above, this could be one of the work arounds.
If you intend to create a household roster with with a lot of dependency constraints, then the repeat groups may not be the best option
You may have to create a first question that determines the number of household members and ensure that the subsequent questions appear only if the household member threshold meets what you expect.
You need to create a number of questions for each variable e.g. age1 age2 age3 age4 etc and make it relevant for the preceding one
You then need to be able to reference your questions as needed.
See the example in this link HouseholdListingRandomSelection.xls (36 KB)