Please, how can I filter options that appear in the next question based on what's was selected in the previous question. I'm using select_multiple and the choice list are same for all questions.
For instance,
Q1. What we're you trained on?
English
Maths
Biology
Economics
Q2. Which course we're you trained free of charge?
Only those selected in Q1 appear
Q3. Which course did you pay a fee?
Only those selected in Q1 appear. OR only those not selected in Q2 appear.
Please help.
See this example: example_dynamicfilter_courses.xlsx (12.5 KB)
+-------------------------+--------------+------------------------------------------------+----------+------------------------------------------------------------------------+
| type | name | label | required | choice_filter |
+-------------------------+--------------+------------------------------------------------+----------+------------------------------------------------------------------------+
| select_multiple courses | trained_on | What were you trained on? | yes | |
| select_multiple courses | trained_free | Which course we're you trained free of charge? | yes | selected(${trained_on}, name) |
| select_multiple courses | trained_paid | Which course did you pay a fee? | yes | selected(${trained_on}, name) and not(selected(${trained_free}, name)) |
+-------------------------+--------------+------------------------------------------------+----------+------------------------------------------------------------------------+
Also see this thread:
Great question @rigs !
The answer lies in the choice_filter column.
In your example, for question B, put the following in the choice_filter column:
selected(${know_carbrand}, name)
For question C, put the following in the choice_filter column:
not(selected(${like_carbrand}, name)) and selected(${know_carbrand}, name)
To be more clear, I've attached the example here:
example_dynamicfilter_cars.xlsx (16.9 KB)
Thanks!
Janna
PS. Let me know if that's what you were looking for, or if there w…