Google Spreadsheet Integration: Not All Submissions were Added in spreadsheet

  • pmarAngela
    Asked on February 19, 2015 at 8:13 PM

    We have created a submission form that does 2 things when the user files.

    1. It generates an email with a pdf to a list of email addresses.

    2. It places the data into a google spreadsheet.

     

    Our problem is that we aren't seeing the data populate the spreadsheet, although we are still receiving the emails. I've tried to unlink and relink the google drive, and that did all sorts of things (created a new spreadsheet link and all formatting and comments were lost). I think I can clean it up, but I still don't see info populate my spreadsheet. We've not made any permissions/sharing changes to the sheet, and it worked as recently as Sunday..

    Looking at the image might help..
    If you look at the image, you can see the submission date/time of the form in the spreadsheet on the far left. The emails in the mailbox correspond to these entries. The last entry that populated the spreadsheet was Feb 14, but we have received 2 additional emails, both of which should populate exactly the same, and neither are there.

    Thanks in advance for your help.

    Angela

     

    Jotform Thread 519422 Screenshot
  • Charlie
    Replied on February 19, 2015 at 9:37 PM

    Hi,

    I see that you have both Google Drive and Google Spreadsheet integrated to your form. Could you re-integrate the Google Spreadsheet only, it should reload all the existing submissions you have in your form.

    The problem is that if you made changes in the Spreadsheet, it might be breaking the integration. Re-integrating should solve the problem. If after this you are still having problems, please do let us know.

    Apologies for the inconvenience and thank you for understanding.