Spreadsheet on my Google Drive is overwritten.

  • konuralp
    Asked on March 21, 2015 at 10:04 PM

    However second part of my question, that the Spreadsheet on my Google Drive (google Sheet) has been overwritten, I assume so all my notes and modifications have gone. 

    Is there any solution to this ?

  • Ashwin JotForm Support
    Replied on March 22, 2015 at 8:59 AM

    Hello konuralp,

    I'm sorry for the trouble caused to you. 

    Please be noted that when you reintegrate your form with google spreadsheet, it does not make any changes to the existing google spreadsheet but it will always create a new google spreadsheet in your google drive account.

    Existing google spreadsheet must have not been overwritten and must be still there in your account. 

    I would suggest you to please take a look at your gDrive folder and see if the existing spreadsheet is still there.

    Thank you!

  • BJoanna
    Replied on March 22, 2015 at 2:11 PM

    I could  not replicate the same situation. When I received new submissions, the spreadsheet would keep the same format, color/styling:

    Spreadsheet on my Google Drive is overwritten Screenshot 20

    You may try removing and adding again the Google Spreadsheet integration.

    Let us know if you need further assistance. 

     

  • konuralp
    Replied on March 23, 2015 at 5:28 AM

    indeed at this moment it does not do the same and what i have done since yesterday remains same, however all the rest of the spreadsheet some 100 lines have been cleared with all formatting, 

  • raul
    Replied on March 23, 2015 at 10:37 AM

    Did you try to remove the integration and add it again as suggested by my colleague?

    Spreadsheet on my Google Drive is overwritten Screenshot 20

    If not, please try to do so and let us know if the issue persists.
    Thank you.

  • konuralp
    Replied on March 23, 2015 at 7:42 PM

    i didn't try that for spreadsheet for two reason

    1- it will only create a new and empty spreadsheet that my list will be divided in two files by this solution

    2- I am not sure if my old data with my classification and colouring will come back

     

    if there is anything to bring those back like a version history or so I can try that solution else, i don;t want to create a new spreadsheet since this is already a second spreadsheet, and to compile data i need to combine spreadsheets each time.

     

  • Charlie
    Replied on March 23, 2015 at 11:48 PM

    Hi,

    You are right, when you re-integrate, you will have a new Google Spreadsheet with no formatting on it, but all the submissions will be loaded there. Unfortunately, we cannot re-integrate then have it linked directly to an existing spreadsheet, in this case the old one.

    What you can do is get the formatting in your old spreadsheet and apply it to the new one. There is also no revision tool for the integration, but there is one for the changes you made in the form itself, but I believe this won't solve the issue: http://www.jotform.com/help/294-How-to-View-Form-Revision-History

    Kind regards

  • konuralp
    Replied on March 24, 2015 at 7:50 AM

    Because my formatting has gone for the old sheet, and currently the existing sheet is updating normally with new forms data, i guess i will not need to reintegrate, right?

     

    In case it again overwrites my formatting than i will think of reintegrating. But as you said I can be sure it will bring all existing records (the old ones from the start) am I right?

     

  • Charlie
    Replied on March 24, 2015 at 9:14 AM

    Hi,

    If you are pertaining to the Google Spreadsheet, it will not overwrite the any spreadsheet, it will actually create a new one when you re-integrate. But, re-integrating it will load all the submissions that the form has. 

    Example: Form 1 has Spreadsheet1. I then had a problem with the integration and the only way to fix it is to re-integrate, my Spreadsheet1 will remain in my Google Account Drive but will not anymore be connected to the form, but when I re-integrate, it will create a new Spreadsheet1 BUT all the submissions of that form will automatically be loaded in that spreadsheet.

    I hope that helps.

    Kind regards.

  • konuralp
    Replied on March 24, 2015 at 9:36 AM

    hi 

    thank you it is very clear now

     

    thanks for your assistance

     

    Regards

     

  • Charlie
    Replied on March 24, 2015 at 9:54 AM

    You're most welcome.

    I'm glad that it helped. If you need any assistance again or have other concerns, please do not hesitate to open or create a new thread.

    Thank you.