Multiple forms submitting to the same Google Spreadsheet

  • Profile Image
    analogueteacher
    Asked on August 13, 2013 at 10:54 AM

    Hi, 

    I just created a new form (ID=32234253590853) and connected it to Google Spreadsheets. But rather than creating a new spreadsheet in my JotForm GDrive folder, it renamed an existing spreadsheet which is already being used to handle submissions from a different form.

    How can I get my new form to submit to a separate spreadsheet?

    Thanks!

  • Profile Image
    KadeJM
    Answered on August 13, 2013 at 11:29 AM

    Hello analogueteacher , To correct this problem you will need to remove your google integrations on the mentioned form or forms. Next I would advise either deleting the spreadsheet or spreadsheets in your gdrive that were connected to your form(s), either that or just move them to a separate folder if you want to back them up. Now make sure all your forms have different names and be sure that they are not integrated. You should now be able to reapply the Google Integration to each of them and it will now create new separate spreadsheet for each. I think this problem probably resulted from just renaming them since that doesn't always disassociate them which lead to the multitude of submission data afterwards.

  • Profile Image
    analogueteacher
    Answered on August 13, 2013 at 11:38 AM

    Thank you