Google Spreadsheet Integration: Not All Submissions were Added in spreadsheet

  • Profile Image
    pmarAngela
    Asked on February 19, 2015 at 08: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

     

  • Profile Image
    Charlie
    Answered on February 19, 2015 at 09: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.