Capturing 'relevant negatives' in 'choose all that apply' MCQs | Community
Skip to main content
Answered

Capturing 'relevant negatives' in 'choose all that apply' MCQs


Hi everyone,

 

My Typeform includes several MCQs that ask users to ‘Choose all that apply’.

 

My objective is to capture relevant negatives as ‘False’ or ‘No’.

 

For example:

 

Q: Which colors do you like?

(choose all that apply)

A - red

B - Blue

C - Green

D - None of these

 

Answer: D

 

I want to be able to capture results as 

Red: No 

Blue: No

Green: No

None of these: Yes

 

Is there a way to do this? I don’t want to go towards asking a matrix of True/False questions if possible because this has worse UX for questions with lots and lots of options (e.g. A-G).

 

Many thanks

 

Best answer by john.desborough

@Reformr - here’s one way but it’s a bit of a pain:

  • create a variable for each possible answer ie v_1_red =np, v_1_blue=no, v_1_green = no v_1_none=no
    • sets the default value of the variable to be ‘no’ 
  • use logic rule to change the selected variable to ‘yes’ ie 
    • if q1 = D replace v_1_none with yes

you would have to do that with each question - each answer would have a corresponding variable 

the variables get submitted with the yes/no values as well as the selected answer

it would be a pain but would work

you could also connect the typeform to a google sheet and create extra columns for each question option and have the arrayformula() function include the calculation of the yes/no for each column (ie q1-red, q1-blue, q1-green, q1-none, etc) so that the yes/no would display in the sheet. That would reduce the variable creation in Typeform .. 

 

a couple of options but not as elegant you might want

des

View original

3 replies

john.desborough
Forum|alt.badge.img+6
  • Certified Partner & Champion
  • 5281 replies
  • Answer
  • March 25, 2023

@Reformr - here’s one way but it’s a bit of a pain:

  • create a variable for each possible answer ie v_1_red =np, v_1_blue=no, v_1_green = no v_1_none=no
    • sets the default value of the variable to be ‘no’ 
  • use logic rule to change the selected variable to ‘yes’ ie 
    • if q1 = D replace v_1_none with yes

you would have to do that with each question - each answer would have a corresponding variable 

the variables get submitted with the yes/no values as well as the selected answer

it would be a pain but would work

you could also connect the typeform to a google sheet and create extra columns for each question option and have the arrayformula() function include the calculation of the yes/no for each column (ie q1-red, q1-blue, q1-green, q1-none, etc) so that the yes/no would display in the sheet. That would reduce the variable creation in Typeform .. 

 

a couple of options but not as elegant you might want

des


  • Author
  • Explorer
  • 3 replies
  • March 26, 2023

Thank you Des, I will give these a go and let you know how it works!

 

Luke


Liz
Community Team
Forum|alt.badge.img+5
  • Tech Community Advocate
  • 14946 replies
  • March 27, 2023

Let us know how it goes, @Reformr !


Reply