[Form Logic] Choice Filter

Support
1

Form attached below.

Issue:

  • In Row 14 of "survey" tab, I have a question where I want the options for that question to be based on the answer in the previous question.
  • If in Row 13, user selects "primary" then I want options 1 & 2 visible; If user selects "both" I want 2 & 3 visible.

Right now all 3 options are visible regardless of what I choose in row 13.

Please let me know what fix is required. Thanks in advance!

Elementary Mentoring Form - May 2023.xlsx (191.5 KB)

2

Hi @susheevar ,

please find below a working example. There are other solutions but this one works fine.
Add a filter (name it as you want) ins the choices sheet and fill it for your "totalclasses" choices, then use it in the choice_filter column of your survey sheet.

Elementary Mentoring Form - May 2023.xlsx (147,1 Ko)

You can check the documentation here :
https://docs.getodk.org/form-logic/#filtering-options-in-select-questions
and a tutorial here :

1 Like
3

Thank you so much Mathieu!