Creating a New Row in google forms | Community
Skip to main content
Answered

Creating a New Row in google forms

G

Hello,

 

I am looking for some advice on how best to create a form.

We are building a submission form where a client can submit multiple items to be looked at. They initially submit them with a unique reference number so for example they might want to submit  4 items with ref 1 / ref 2 /ref 3 ref 4.

 

When this goes into our spreadsheet it creates a new column for each submission but what I really want is it to create a new row and remember the users details.

 

So for example  It would be Row 1 - User 1 - Ref1

                                            Row 2    User 1 - Ref 2 

 

 This is to stop the user having to submit their email and personal details several times. Can anyone shed any light on how to do this?

Best answer by john.desborough

@Graeme @Liz - from another user

 

  1. don’t mess with the first tab where typeform loads the data - doing so will screw up the world for you
  2. create a second tab, where you will have your ‘organized’ data 
    1. you can create pivot tables to organize the data you want in the format you want
    2. you can run a macro to transpose the columns/rows 

alternatively, you create an output report (based on getting the data into a separate tab from the main typeform data tab) where you can generate the layout you want and for each new record added, spit out the custom report with client name and data in rows… 

 

des

View original
Gabi Amaral
1 person likes this
  • Gabi Amaral
    Gabi Amaral

2 replies

Liz
Community Team
Forum|alt.badge.img+5
  • Liz
  • Tech Community Advocate
  • 14971 replies
  • August 30, 2021

Hi @Graeme Happy Monday! Thanks for stopping by. Our native integration will create a new column for each answer, so there isn’t a direct way to change how the integration sends data to the sheet. 

Though, you could send the data to a tab in your Google Sheet and setup formulas to show the data as you’d like. @Paulo may have a better idea of how to set this up!

Life is a series of awkward moments separated by snacks.
P
Gabi Amaral
2 people like this
  • P
    Paulo
  • Gabi Amaral
    Gabi Amaral
john.desborough
Forum|alt.badge.img+6
  • john.desboroughCertified Partner
  • Certified Partner & Champion
  • 5298 replies
  • Answer
  • August 30, 2021

@Graeme @Liz - from another user

 

  1. don’t mess with the first tab where typeform loads the data - doing so will screw up the world for you
  2. create a second tab, where you will have your ‘organized’ data 
    1. you can create pivot tables to organize the data you want in the format you want
    2. you can run a macro to transpose the columns/rows 

alternatively, you create an output report (based on getting the data into a separate tab from the main typeform data tab) where you can generate the layout you want and for each new record added, spit out the custom report with client name and data in rows… 

 

des

If your third coffee of the day is not helping you with your Typeform, maybe we can help you find your answers...
Liz
P
Gabi Amaral
3 people like this
  • Liz
    Liz
  • P
    Paulo
  • Gabi Amaral
    Gabi Amaral

Reply


Still need help?

Don't be shy and ask the community.

Ask your question here!
Community T&Cs