Answered

Creating a New Row in google forms

  • 30 August 2021
  • 2 replies
  • 706 views

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?

icon

Best answer by john.desborough 30 August 2021, 23:44

View original

2 replies

Userlevel 7
Badge +5

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!

Userlevel 7
Badge +6

@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

Reply