When Google Sheets and JotForm are integrated for multiple forms, it integrates all submissions into one Google Sheet instead of multiple ones.

  • Profile Image
    LCaraccilo
    Asked on July 15, 2015 at 12:36 PM

    PLEASE HELP!

    When Google Sheets and JotForm are integrated for multiple forms, it integrates all submissions into one Google Sheet instead of multiple ones. When Google Sheets and JotForm are integrated, I need it to create multiple sheets and have the submissions to be collected under the appropriate sheet.  

  • Profile Image
    Charlie
    Answered on July 15, 2015 at 03:11 PM

    Hi,

    When you integrate Google Spreadsheet to your Form, it will create only one spreadsheet. Currently, when you remove and reintegrate, it creates a new spreadsheet per instance, the old spreadsheet will remain in your Google Drive but it will no longer be connected to your form.

    It is a one way integration where the Form transfers the data to the newly created spreadsheet, you cannot pass data from Spreadsheet to the Form, you also cannot connect your own spreadsheet to the form.

    Please check our guide here: http://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet.

    Note: Every time that remove and re-integrate Google Spreadsheet, it automatically loads all the submissions in the newly created spreadsheet.

    If you want to compile multiple Forms with their Google Spreadsheets to one main Sheet (a master sheet), you can use the ImportRange function for that.

    I hope that helps.

  • Profile Image
    LCaraccilo
    Answered on July 15, 2015 at 04:11 PM

    Is there another tool I could use to do what I am looking for it to do? Please help! Thanks!

  • Profile Image
    EltonCris
    Answered on July 15, 2015 at 06:29 PM

    @LCaraccilo

    Sorry but I don't think there's any feature that would fit your requirement. The only option I could think of that would be automated is to create your own webhook script, this requires advanced php knowledge though. http://www.jotform.com/help/245-Creating-your-first-Webhook-with-JotForm

    Other than that, you may consider PDF format instead. When you integrate to Google Drive, submissions data will be sent into PDF format.