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 integration issues

    Asked by bjorn.kvinge298 on August 25, 2015 at 09:33 AM

    Hi!

    I just realized that I have lost some information the same way that the others are explaining here. It was an coincidence that I discovered this. Is it possible to get an warning for this in the future?

    I Understand that I have all my submissions available at the form, but after setting up the connection the google docs I have done some changes in the excel file on the layout and formatting. I don't want to do this each time i have lost submissions from google docs.

    google google sheets google integration issues integrations google spreadsheets
  • Profile Image
    JotForm Support

    Answered by Jan on August 25, 2015 at 09:34 AM

    Sorry for the inconvenience. Unfortunately, this happens whenever Google make an update with their API. The API is the communication between JotForm and Google. So if there are issues reported, our developers apply patches in order to fix it.

    All the submissions are still available in the submissions page, just like what you've mentioned. If you remove the integration and create a new one, it will pull up all the submissions from our servers to the new spreadsheet.

    Thank you for understanding.

  • Profile Image

    Answered by linfoxt on August 25, 2015 at 08:00 PM

    Hi Jan,

    I totally understand the bjorn question.

    We usually integrate the SPREADSHEET ID and all features within our reports through Google documents, so if we RE integrate we lose everything and we must adjust the code again as a new ID is generate.

    I've already requested a feature (long time ago) to have a button called "Re integrate", so instead of creating a new spreadsheet (new id), Jotform will delete the data within the current spreadsheet and re populate the information, so we avoid issues like he had.

     

    Because of the last issue with Google Drive, I lost half day re integrating and checking IDs as I have lots of spreadsheets reading and generating reports based on Jotform data.

  • Profile Image
    JotForm Support

    Answered by ashwin_d on August 26, 2015 at 12:48 AM

    Hello linfoxt,

    I was not able to locate your previous thread for this feature request.

    I have moved your question to a new thread and we will forward your feature request again to our back end team:  http://www.jotform.com/answers/647839 

    Thank you!

  • Profile Image

    Answered by bjorn.kvinge298 on August 26, 2015 at 03:08 AM

    Hi!

    Something must have happened with the integration. Now I have tried to re integrate the google spreadsheet 3 times. Changing account settings in jotform, changing spreadsheet settings. Changing format in "Submission Date" column. But still new submissions is coming as shown in the screenshot.

  • Profile Image
    JotForm Support

    Answered by ashwin_d on August 26, 2015 at 06:13 AM

    Hello,

    Since it is a different issue, I have moved your question to a new thread and you will be answered here:  http://www.jotform.com/answers/647982 

    Thank you!