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 Spreadsheets Integration is not sending new submissions to sheet.

    Asked by cfnavyleague on February 20, 2015 at 11:42 AM

    I have noticed a number of submissions are missing from my integrated Google Spreadsheet.  I have just tested two submissions and they both failed.

    Form ID 43564362097965

  • Profile Image

    Answered by cfnavyleague on February 20, 2015 at 12:52 PM

    I ended up deleting the integration and creating a new one - which went to a new sheet.  I rebuilt all of my reporting and was good to go.

    I suppose this occurred because I used a "Filter View" on the Submissions sheet, and this disrupted the integration for some reason.  I am now using an "=IMPORTRANGE" function on a separate sheet to get a sortable view, and I've hidden the Submission sheet to make sure this doesn't occur again.

  • Profile Image
    JotForm Support

    Answered by Kiran on February 20, 2015 at 02:49 PM

    Yes. You are right. Making any changes to submissions sheet would break the integration. It is always suggested to use a separate sheet and copy the data from submissions sheet for making any modifications or run any reports as you just did.

    We appreciate your efforts in resolving the issue and glad to see that you have found the solution. Please do not hesitate to get back to us if you need any further assistance. We will be happy to help.