So recently I have been working on a new project and I have had to filter options based on the choice of previous answer, well, it isn’t as simple as I’m explaning, but let me eleborate.
I have the question 1, " Q1 - Select the camp or cc " with options : Op1, Op2 … Op6.
In the next question, I have " Q2 -Select the camp letter " with the options ," A, B, C , … X"
No, I want the second question’s options to be filtered based on the Q1 answer, knowing that some of the options of Q1 may have the same options of Q2. Ex:
The Op1 and Op2 and Op3 and Op4 from the Q1 should see the options “A, B, C, D” from Q2.
So I couldn’t use the normal filter, because I want each option from Q1 to so see specific options from Q2…
As you can see in this pic, if the option Op1 from cctype list had been selected I want the filter Op1 to apply to the list “csector_letter”, if the Op2 is the one been selected in cctype I want the filter list Op2 to show up in the list “csector_letter”
You can just combine the expressions with and/or in the choice_filter column of the survey sheet refering to the column names in the choices sheet of your XLSForm. Also, an if clause should work
You can also include a reference to the name column of the choice_list.
Hint: A disadvantage with dynamic choice filters is that they are not active when you print out an empty XLSForm, so the choice list may appear empty. Some workaround would be to rename the choice_filter column in the survey sheet temporarily for the printing (e.g. XXchoice_filter).