Using the answers to a multiple-select question to filter the choices of another question

AlfredBaldenweck

I'm looking at making a cascading choice list in which the question to filter the choices by is multi-select.

For example (pivoted for readability):

Fruit	Relevant choices
Apple	Red Delicious, Yellow Delicious
Grape	Merlot, Concord
Blueberry	Ivanhoe, Patriot, Violetta

 

If I were to select both "Apple" and "Grape", I would want "Red Delicious", "Yellow Delicious", "Merlot", and "Concord" to all show up as options in the next question.

I thought I had seen somewhere that it was possible by using selected() in the choice filter, but that appears to require specific choices be named.

Is this possible?

Thanks!

dougbrowning

I tried using selected-at and it worked.  You would need to write out enough select-at to cover the max number of choices.  See attached but your choice filter would be.

selected(selected-at(${fruit}, 0), fruit) or selected(selected-at(${fruit}, 1), fruit) or selected(selected-at(${fruit}, 2), fruit)

 

That said I think the data you got from this would be really hard to analyze later.  You would have so many long strings of comma separated values with all the fruits and types intermixed.  Any time I have to use a select multiple I pull them back apart into rows later in script.  Not sure the use case here.  Also select multiple cannot have spaces in the values.

Hope that helps.

Form 2.xlsx