Google integration issues

  • Profile Image
    bjorn.kvinge298
    Asked 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.

  • Profile Image
    Jan
    Answered 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
    linfoxt
    Answered 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
    ashwin_d
    Answered 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
    bjorn.kvinge298
    Answered 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
    ashwin_d
    Answered 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!