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

    Spreadsheet on my Google Drive is overwritten.

    Asked by konuralp 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 ?

  • Profile Image
    JotForm Support

    Answered by ashwin_d on March 22, 2015 at 08: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!

  • Profile Image
    JotForm Support

    Answered by BJoanna on March 22, 2015 at 02:11 PM

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

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

    Let us know if you need further assistance. 

     

  • Profile Image

    Answered by konuralp on March 23, 2015 at 05: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, 

  • Profile Image

    Answered by raul on March 23, 2015 at 10:37 AM

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

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

  • Profile Image

    Answered by konuralp on March 23, 2015 at 07: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.

     

  • Profile Image
    JotForm Support

    Answered by Charlie 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

  • Profile Image

    Answered by konuralp on March 24, 2015 at 07: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?

     

  • Profile Image
    JotForm Support

    Answered by Charlie on March 24, 2015 at 09: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.

  • Profile Image

    Answered by konuralp on March 24, 2015 at 09:36 AM

    hi 

    thank you it is very clear now

     

    thanks for your assistance

     

    Regards

     

  • Profile Image
    JotForm Support

    Answered by Charlie on March 24, 2015 at 09: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.