Can't create a select_multiple question based on a list generated by responses

Hello,

I am building a survey in XLS and I’m trying to create a question type where the user selects multiple options from a list based on responses they gave in a previous repeated section.

The respondent provides information on household members (names, occupation, etc). We then ask another question asking if any household members have worked for a specific business we are collaborating with in our research project. If they answer yes, we want the respondent to identify which one(s).

The question type code I was using was “select_multiple${NameHH}” which is the question name in the repeated section that collects hh member names. However, when I upload the form to kobotoolbox, those question types get an error. Is it possible to do this? Or should I try another solution?

thanks @tboswellut, Welcome to community,
Please share a xlsform so the community can help you.

@tboswellut, were you refering to this which has been discussed in our previous post:

This was the solution I was trying to adapt from. Although, in our project, we would like respondents to be able to select_multiple rather than just select_one. So if the respondent is prompted to indicate “which family members work or formerly worked at x business?” They would be able to check the boxes next to the names. Does the solution work with “select_multiple” in kobotoolbox? As I have it now it doesn’t work.

begin_repeat hh_members ${F1_1}
text F2_01 yes Household member name
select_one relation F2_02 yes Relationship to head of household
select_one sex horizontal-compact F2_03 yes Sex
integer horizontal-compact F2_04 yes Age
end_repeat hh_members
select_one yes_no_dk horizontal-compact F2_16 yes Does anyone in the household currently work at the the mill?
select_multiple${F2_01} F2_17 yes ${F2_16} = ‘1’ Select household member(s) from list
select_one yes_no_dk horizontal-compact F2_18 yes ${F2_16} = ‘0’ or ${F2_16} = ‘99’ Has anyone in the household ever worked at the mill?
select_multiple${F2_01} F2_19 yes ${F2_18} = ‘1’ Select household member(s) from list

thanks @tboswellut @Kal_Lam
@tboswellut
Apparently the feature “select_multiple from repeat group” is not available yet
But if we expect the maximum number of choices, we can overcome the issue with an alternative solution

Book1.xlsx (11.3 KB)

Hello all,

I’ve followed the responses given here and I feel my challenge is an even simpler one yet quite a pickle to figure out.

I am equally building a survey in XLS and I’d like the selected responses from a multi-select question to be the only one’s appearing in the next multi-select question.

For example;

q1 Of the following fruits, which ones do you know?
Apple
Banana
Mango
Orange
Kiwi

Respondent selects Apple, Mango and Kiwi, then the following question (q2) only includes in its select-one/multi-select options what was selected in q1

q2 From among the fruits you selected, which ones are your favourite?
Apple
Mango
Kiwi

In what ways can I go about this?

Answer found, thank you

https://support.kobotoolbox.org/cascading_select.html#adding-cascading-question-sets-in-xlsform-option-2

Here we are in 2025 , and this thing has helped me so much :grinning_face: