Hi all,
I am currently building an XLSForm. Attached is a subset of the current form.
In our survey, we have three main parts. For each household that we survey, we want a different member to answer each of the three parts. For example, Member 1 answers the first part, Member 2 answers the second part, and Member 3 answers the third part.
We enter the names of the household members inside a repeat group. Then, we pull all of the names that are entered into the repeat group using a calculate question type with an indexed-repeat function.
At the beginning of each different part of the survey, we want the enumerator to select who, among the household members, will be taking that part of the survey. We would like it to be a select_one question type to reduce potential enumerator error with entering the name of the respondent again.
Since each household will have different amounts of members, I have set up the form to pull 30 names that are entered. This also means that for the select_one question at the end of the form, there will be 30 options to choose. If the enumerator only inputs 5 names, then 5 names will show up on the select_one question, with 25 blank options. The enumerator will still be able to select a blank option, which is bad.
I want to limit the number of options available for the select_one question, based on how many household members' names are inputted, but still allow for a (virtually) unlimited amount of names to be inputted. For example, in House 1, there are 7 members, so only 7 options will show up on the select_one question. But, in House 2, there are 13 options. The enumerator will still be able to enter in 13 names, and have 13 options show for the select_one question.
I hope this makes sense. Thanks in advance for your help.test_people.xlsx (18.9 KB)