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

    Missing Submissions on Google Spreadsheet Integration

    Asked by CornelViljoen on February 19, 2015 at 04:48 AM

    One of my forms has a integration with google spreadsheets however every now and then a form submission goes missing.  I can see it is submitted but the data is not exported to my google spreadsheet.  Any suggestions on how to fix this.  I have re-integrated many times and need it to be reliable.

    My Forms integrated then and
  • Profile Image
    JotForm Support

    Answered by Charlie on February 19, 2015 at 09:35 AM

    Hi,

    Thank you for reporting this. If you are constantly making changes to the spreadsheet, I believe that is one reason why that integration seems to be a faulty. But, if you are not changing anything on the spreadsheet and there are a couple of submissions missing on it, there might be something wrong with the integration. I can escalate this to our developers but could you confirm if this is the form that has the the problem with: http://www.jotform.com/43075657520960?

    We'll wait for your response.

    Thank you.

  • Profile Image

    Answered by CornelViljoen on February 20, 2015 at 03:07 AM

    Thank you for the feedback, the link you have is the correct one.  I am working on the spreadsheet although on different tabs in order to analyse the data submitted.  The source tab (submissions) i do not temper with.

  • Profile Image
    JotForm Support

    Answered by Charlie on February 20, 2015 at 08:59 AM

    Hi,

    Thank you for the update. I'll escalate this to our developers so that they can take a closer look. 

    Are you using some calculation on your spreadsheet or you would just like to view it? If you are just viewing the submissions you could try creating an HTML table report or a Grid report, it's much more reliable and real time because it shows the submissions directly from your JotFrom account. Here are the guides on how to do that:

    http://www.jotform.com/help/209-How-to-create-an-HTML-Table-Listing-Report 

    http://www.jotform.com/help/105-How-to-create-a-Grid-Listing-report 

    With regards to the problem, we'll update you when our developers see any major problem with the integration or if they can have a fix on it to make it more reliable.

    Thank you.

  • Profile Image
    JotForm Support

    Answered by alp_deniz on March 01, 2015 at 06:18 PM

    Hello,

    We have fixed every problem we encountered during a 6 month period and our spreadsheet integration has become very much stable and it should not miss any submissions from now on. Please let us know if you experience any issues.

    Please accept my apologies for previous inconveniences.

    Kind regards,

    Alp