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

    Problems with Google Sheets integration

    Asked by emun-fellows on April 30, 2015 at 08:12 PM

    Hey guys,

    I keep running into troubles with the Google drives integration - every couple of weeks, old form entries that had already been transferred to google disappear from the google sheet (more specifically, really old ones) - alongside with all tabbed sheets other than the main one (the one where the entries go).

    Furthermore, since a couple of days only parts of the fields from the jotform seem to be transferred.

    Did you by any chance hear about a similar problem and could offer some ideas?

    Thanks so much,

    Tobias

    JotForm all Google Spreadsheet Google integration
  • Profile Image

    Answered by Shadae on April 30, 2015 at 10:04 PM

    Hi Tobias,

    I do apologize for the issue that you are experiencing with your form integration.

    Have you been making any changes directly to the integrated spreadsheet? If so, this can cause the integration to be broken and cause the issues that you are currently experiencing.

    Please attempt the following steps to resolve the issue:

    Remove the current integration

    Clear your form cache

    Recreate your integration

    I hope this helps, please inform us if you need further assistance.

    Thank you.

  • Profile Image

    Answered by emun-fellows on May 10, 2015 at 09:15 AM

    Hey Shadae,

    Thanks so much for getting back to me! Would you also say that the issue with some form entries only being partially transferred to google is due to what you described?

    Tobias

  • Profile Image

    Answered by Ben on May 10, 2015 at 10:54 AM

    Yes, that might be possible reason if it happened at that time Tobias.

    Since Google released the update to their Google Drive policy at that time, our developers worked on both Google Drive and Google Spreadsheet integration.

    This was done in a way to not interrupt any active integrations, but if it did for you, we apologize for that.

    Can you tell us if the same issue is still present for you?

    I should mention though that old parts of your Google Spreadsheet should not be missing since our integration does not remove any data, only adds to it, but please be sure that you are not near the limit of your Google Spreadsheet row count (about 400.000 rows of 1 cell, more cells means less rows, so 200.000 rows of 2 cells, and so forth).