Can I integrate 2 form to use a single google spreadsheet

  • Profile Image
    Asked on June 01, 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?
  • Profile Image
    Answered on June 01, 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.

  • Profile Image
    Answered on June 01, 2016 at 02:11 PM
  • Profile Image
    Answered on June 01, 2016 at 02: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.