Answered

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

  • 25 March 2023
  • 3 replies
  • 24 views

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

 

icon

Best answer by john.desborough 25 March 2023, 05:14

View original

3 replies

Userlevel 7
Badge +6

@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

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

 

Luke

Userlevel 7
Badge +5

Let us know how it goes, @Reformr !

Reply