Can I integrate 2 form to use a single google spreadsheet

  • plott
    Asked on June 1, 2016 at 11:24 AM
    If I have google spreadsheet integration set up with my original form, will my cloned form automatically write to the same spreadsheet?  Is it possible for both forms to write to the same document?
  • victor
    Replied on June 1, 2016 at 11:58 AM

    No, it is not possible to integrate 2 different forms to use the same spreadsheet. This will break the integration and neither will work. You will need to have them use to different spreadsheet and us some formulas to copy and all the data of both spreadsheets and paste it in another (third) spreadsheet.

  • NJFallen
    Replied on June 1, 2016 at 2:11 PM

    I haven't tried this but looks possible using this method ?

    http://www.jessespevack.com/systems-leadership/2015/4/22/pulling-spreadsheet-data-no-scripts-required

  • Huberson
    Replied on June 1, 2016 at 2:39 PM

    I'm pretty sure it is possible to combine data from multiple spreadsheet but, as my colleague previously mentioned, having two different forms passing data automatically to the same sheet is not possible because, each integration will create its own sheet to pass its own data.

    You could always try to create another spreadsheet and use some Script to pass the data from the two forms to the new one.