What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Google Spreadsheet Integration: Not All Submissions were Added in spreadsheet

    Asked by pmarAngela 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

     

    Screenshot
    not updating Emails problem Comments mailbox
  • Profile Image
    JotForm Support

    Answered by Charlie 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.