How to filter out choices (in Q2) if something is selected in Q1 and include all the choices in Q2 if refused, don't know or have not decided is selected in Q1?

User Support Form Building
, , , ,
1

Hi Team, please here is my question:

Lets assume I have name of candidates as options include refused, don’t know, I have not decided as options. For Example: Q1 select the candidate you like most? and option are:

  1. Alex
  2. Brown
  3. Mary
  4. Refused
  5. Don’t Know
  6. I have not decided.

So in question 2. Who are you likely to support during is campaign?

  1. Alex
  2. Brown
  3. Mary
  4. Refused
  5. Don’t Know
  6. I have not decided.

So my question is: if I select any of the candidates in q1, I don’t want candidate’s name to appear in Q2 but if i select any options 4-6, i want to see then in question 2 including all the names of the candidate from question 1.

I hope you understand?

I will be waiting for your response.

Thank you.

2

@Adebayoadek, is Q1 and Q2 both select_multiple or are they both select_one?

3

Single select

1 Like
4

@Adebayoadek, you could do this as outlined in the image shared below:

In the survey tab of your xlsform:

Image 1
Image 11127×153 6.81 KB

In the choices tab of your xlsform:

Image 2

Data entry screen as seen in Enekto: when nothing is selected

Image 3
Image 3623×585 12.1 KB

Data entry screen as seen in Enekto: when either refused is selected

Image 4
Image 4636×701 16.7 KB

Data entry screen as seen in Enekto: when Alex is selected

Image 5
Image 5633×698 15.2 KB

Reference xlsform:

choice_filter.xlsx (53.7 KB)

1 Like