Google Sheet Headers Not Showing Questions, Just Matrix Row | Community
Skip to main content
Answered

Google Sheet Headers Not Showing Questions, Just Matrix Row


jsteed

Hi - I’ve done a few typeforms now and have everything integrated into Google Sheets nicely. I am going to give more info than necessary just so you get the full picture:

  • I have a multi-day event for which we have to collect evaluations for each day, and each day has several sessions. Each session must be rated on 5 things, plus additional yes/no questions and comments.
  • I was shared a survey that was built in the new builder, but I have the old builder, so I have been editing the shared “quiz” in the new builder.
  • My survey now says “quiz” on it, but it didn’t before I started editing.
  • I ended up removing all logic and using question groups because I needed the full survey completed at once (the original typeform was set up so someone would have to choose which thing they were going to rate instead of rating them all, i.e. a full day of session ratings vs. selecting one session to rate at a time). I have the question groups by session, with the first question being a matrix of 5 rows/4 columns to rate different aspects, followed by two y/n questions and an optional comments field.
  • I took the survey after creating a Google Sheet for it. My results show up, but the headers just say the row text from the matrix questions instead of the question text so i don’t know which session they’re rating (i.e., “Content” but not “Lecture title: Content”).

What am I doing wrong? How should I go about creating an evaluation where I need a matrix for each session, and I need my Google Sheet to say which session they’re rating?

 

Here’s an example of what I need evaluated (the lecture title and speaker needs to show up in my results):

Keynote: The Influence of Biomechanics on My Practice - Dr. First Last

 

1 = Poor

2 = Fair

3 = Good

4 = Excellent

Content

 

 

 

 

Objectives

 

 

 

 

Delivery

 

 

 

 

Quality

 

 

 

 

Effectiveness

 

 

 

 

Was there an absence of commercial bias?    Yes     No

Did this lecture inspire you to learn and use that knowledge in your practice?    Yes     No

Comments:

Best answer by john.desborough

@jsteed - welcome back to the community.. 

 

try this demo

I just created this to try out your little logic scenario. A couple of things from the logic perspective i did to get the results:

  • i created this demo with a multiple choice of 4 sessions for the day, pick as many as you want
  • i created a question group for each of the sessions with the first question in each being the matrix question
  • i created a series of text variables called event1 event2 event3 and event4 and set the default to no
  • basic logic works as follows:
    • on the MC question: 
      • if q1=A jumpto q2 (qgroup for keynote)
      • if q1=B jumpto q3 (qgroup for roundtable)
      • if q1=C jumpto q4 (qgroup for breakout)
      • if q1=D jumpto q5 (qgroup for wrapup)
    • in q2 - question group - which user sees only if they select A as one of their choices
      • on the second question in the qgroup, i add logic rule to change value of event1 to ‘keynote’ (if event1 = no then replace event1 with keynote)
      • on the comments question (last question in the group) i put in the following logic rules:
        • if q1=B jumpto q3
        • if q1=C jumpto q4
        • if q1=D jumpto q5
        • anything else, jump to S1
    • if the user had selected B in Q1
      • on the second question in the qgroup, i add logic rule to change value of event2 to ‘roundtable’ (if event2 = no then replace event2 with roundtable)
      • on the comments question (last question in the group) i put in the following logic rules:
        • if q1=C jumpto q4
        • if q1=D jumpto q5
        • anything else, jump to S1
    • if the user had selected C in Q1
      • on the second question in the qgroup, i add logic rule to change value of event3 to ‘breakout’ (if event3 = no then replace event3 with breakout)
      • on the comments question (last question in the group) i put in the following logic rules:
        • if q1=D jumpto q5
        • anything else, jump to S1
    • if the user had selected D in Q1
      • on the second question in the qgroup, i add logic rule to change value of event4 to ‘wrapup’ (if event4 = no then replace event4 with wrapup)
      • on the comments question (last question in the group) i put in the following logic rules:
        •  jump to S1

 

after creating all this, i then created the connection to Google Sheet 

i entered in a series of ‘evals’ and you can see in the first column, which is the answer string from the MC question that there may be multiple entries 

in the image above you can see i selected a variety of combos and they are listed here

the matrix responses are laid out to the right in series ie qgroup 1 through 4 in order

you should be able to see some staggering of the data entries (Col I is the last col for qgroup 1 - see the blanks for the last row of data where qgroup2 data is absent based on event choices)

i use the eventX variable as a check on which ones were submitted: 

the list of eventname and no cells is what i use to cross check that the data is there from the questions

if you want to try this out and check out the google sheet:

https://docs.google.com/spreadsheets/d/1vPSRPVjr3l2MOPZkMyUXhA-H9Fbxl72Cov4gK1P67Jw/edit?usp=sharing

 

I hope this goes part way to solving some of the problem

if you need access to the new builder and don’t have it yet go to this link and request it: it is much easier to do in the new builder than the old one

 

enjoy

des

View original

john.desborough
Forum|alt.badge.img+6

@jsteed - welcome back to the community.. 

 

try this demo

I just created this to try out your little logic scenario. A couple of things from the logic perspective i did to get the results:

  • i created this demo with a multiple choice of 4 sessions for the day, pick as many as you want
  • i created a question group for each of the sessions with the first question in each being the matrix question
  • i created a series of text variables called event1 event2 event3 and event4 and set the default to no
  • basic logic works as follows:
    • on the MC question: 
      • if q1=A jumpto q2 (qgroup for keynote)
      • if q1=B jumpto q3 (qgroup for roundtable)
      • if q1=C jumpto q4 (qgroup for breakout)
      • if q1=D jumpto q5 (qgroup for wrapup)
    • in q2 - question group - which user sees only if they select A as one of their choices
      • on the second question in the qgroup, i add logic rule to change value of event1 to ‘keynote’ (if event1 = no then replace event1 with keynote)
      • on the comments question (last question in the group) i put in the following logic rules:
        • if q1=B jumpto q3
        • if q1=C jumpto q4
        • if q1=D jumpto q5
        • anything else, jump to S1
    • if the user had selected B in Q1
      • on the second question in the qgroup, i add logic rule to change value of event2 to ‘roundtable’ (if event2 = no then replace event2 with roundtable)
      • on the comments question (last question in the group) i put in the following logic rules:
        • if q1=C jumpto q4
        • if q1=D jumpto q5
        • anything else, jump to S1
    • if the user had selected C in Q1
      • on the second question in the qgroup, i add logic rule to change value of event3 to ‘breakout’ (if event3 = no then replace event3 with breakout)
      • on the comments question (last question in the group) i put in the following logic rules:
        • if q1=D jumpto q5
        • anything else, jump to S1
    • if the user had selected D in Q1
      • on the second question in the qgroup, i add logic rule to change value of event4 to ‘wrapup’ (if event4 = no then replace event4 with wrapup)
      • on the comments question (last question in the group) i put in the following logic rules:
        •  jump to S1

 

after creating all this, i then created the connection to Google Sheet 

i entered in a series of ‘evals’ and you can see in the first column, which is the answer string from the MC question that there may be multiple entries 

in the image above you can see i selected a variety of combos and they are listed here

the matrix responses are laid out to the right in series ie qgroup 1 through 4 in order

you should be able to see some staggering of the data entries (Col I is the last col for qgroup 1 - see the blanks for the last row of data where qgroup2 data is absent based on event choices)

i use the eventX variable as a check on which ones were submitted: 

the list of eventname and no cells is what i use to cross check that the data is there from the questions

if you want to try this out and check out the google sheet:

https://docs.google.com/spreadsheets/d/1vPSRPVjr3l2MOPZkMyUXhA-H9Fbxl72Cov4gK1P67Jw/edit?usp=sharing

 

I hope this goes part way to solving some of the problem

if you need access to the new builder and don’t have it yet go to this link and request it: it is much easier to do in the new builder than the old one

 

enjoy

des


john.desborough
Forum|alt.badge.img+6

@jsteed - did you get a chance to look at the demo? any questions?? 

 

des


Gabriel
Ex–Typefomer
Forum|alt.badge.img+5
  • Community Team
  • June 10, 2021

That response was just jaw-dropping, @john.desborough. We’ll write a DM to @jsteed to make sure he read it. 


john.desborough
Forum|alt.badge.img+6
Gabriel wrote:

That response was just jaw-dropping, @john.desborough. We’ll write a DM to @jsteed to make sure he read it. 

lol.. @Gabriel thanks for the props.. i could not let that one go by, even if it was late at night lol.. it was something that was on my ‘to do’ in any event, to test out some logic like that.. 

cheers

 

des


jsteed
  • Socializer
  • June 10, 2021

Wow… the kindness of strangers! Thank you so much - you really went above and beyond, and you don’t know how grateful I am. Now to find the time and energy to devote to comprehending what you’ve done so I can put it into action! Wish me luck.

juju xx


john.desborough
Forum|alt.badge.img+6
jsteed wrote:

Wow… the kindness of strangers! Thank you so much - you really went above and beyond, and you don’t know how grateful I am. Now to find the time and energy to devote to comprehending what you’ve done so I can put it into action! Wish me luck.

juju xx

@jsteed - no worries [edited - my bad]. as in my note to Gabriel above, it was something on my list to tackle in any event and you happened to catch me after the house went to sleep and i wanted a have a scotch lol.  

It’s an application-type that i have actually been working towards for my own business and was glad to have moved the needle in getting several items off my to-do list and to have given you a few sleepless nights figuring it out lol

 

cheers

 

des


jsteed
  • Socializer
  • June 10, 2021
john.desborough wrote:
jsteed wrote:

Wow… the kindness of strangers! Thank you so much - you really went above and beyond, and you don’t know how grateful I am. Now to find the time and energy to devote to comprehending what you’ve done so I can put it into action! Wish me luck.

juju xx

@jsteed - no worries sir.. as in my note to Gabriel above, it was something on my list to tackle in any event and you happened to catch me after the house went to sleep and i wanted a have a scotch lol.  

It’s an application-type that i have actually been working towards for my own business and was glad to have moved the needle in getting several items off my to-do list and to have given you a few sleepless nights figuring it out lol

 

cheers

 

des

coffee in the morning, coffee in the evening, whisky at supper time… i think that’s how the song goes? anyway, those are my kind of tasty beverages! thanks again.

 

juju (she/her)


john.desborough
Forum|alt.badge.img+6

@jsteed - apologies, too many things happening in my brain and not paying attention to ‘cross-typing’ from multiple threads/applications. But as long as you like scotch… lol

 


Reply