- JotForm Supportashwin_dAnswered on March 22, 2015 at 08:59 AM
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.
- JotForm SupportBJoannaAnswered 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.
- konuralpAnswered 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,
- raulAnswered 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.
- konuralpAnswered 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.
- CharlieAnswered on March 23, 2015 at 11:48 PM
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.
- konuralpAnswered 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?
- CharlieAnswered on March 24, 2015 at 09:14 AM
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.
- konuralpAnswered on March 24, 2015 at 09:36 AM
thank you it is very clear now
thanks for your assistance
- CharlieAnswered 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.