What answer did they select? | Community
Skip to main content
Answered

What answer did they select?


I have run a survey which included a multi-choice question in the form of a Matrix. All respondents were forced to answer it.

Each row was a question and the columns are where respondents enter their answer.

There were five possible answer options (columns) per question (row). The answers ranged from “Strongly disagree” (option 1) to “Strongly agree” (option 5). The problem is that the middle three options are not labelled. This is intuitive for the respondent as they can see where the midpoint is and know what the non-labelled options mean.  

In the Summary tab under Results I can see all these options have been captured and I can see the overall distribution of answers across the five options.

But when I come to downloading and analysing the Responses, I can see those who have replied “Strongly disagree” or “Strongly agree”, but I have no way of working out what the remaining options are. In other words, I can’t tell the difference between option 2, 3 and 4.

I’ve re-labelled the survey but it doesn’t seem to apply to the results. I’ve tried to isolate each respondent and then look at the Summary tab, but I can’t seem to do that.

Have I lost all this data?

Best answer by john.desborough

@jlqn - if you connect your form to GoogleSheets, the data should show what ‘choice’ was made .. see the example below. 

 

note that i have two ends labeled but not the middle 3

 

 

and the output to google sheets shows which ‘blank’ column they selected

 

 

and what i see in the Results tab is below

here’s the sample quiz if you want to try it.. 

 

des

View original

3 replies

Liz
Community Team
Forum|alt.badge.img+5
  • Tech Community Advocate
  • 14899 replies
  • July 26, 2023

Hi @jlqn Thanks for stopping by the community! I’m afraid if those questions weren’t labeled, you wouldn’t exactly be able to see the answers in the report. 

@mathio there isn’t a way to do this via the API, right? Or is there?


john.desborough
Forum|alt.badge.img+6
  • Certified Partner & Champion
  • 5268 replies
  • Answer
  • July 26, 2023

@jlqn - if you connect your form to GoogleSheets, the data should show what ‘choice’ was made .. see the example below. 

 

note that i have two ends labeled but not the middle 3

 

 

and the output to google sheets shows which ‘blank’ column they selected

 

 

and what i see in the Results tab is below

here’s the sample quiz if you want to try it.. 

 

des


  • Author
  • Explorer
  • 1 reply
  • July 27, 2023

Thank you @Liz and @john.desborough .

The results in the Google sheets are the same as those downloaded into xls. 

The problem (that I didn’t explain above, apologies) is that I removed the labels for each column by deleting them. So in your example above they are titled “Col 2”, “Col 3” and “Col 4”. Mine didn’t have these. 

If I can’t download the data, I was wondering if there’s a way of selecting just one respondent at a time and then looking at their answers on the “Response summary” tab?


Reply