- dtplisneyAsked on March 19, 2015 at 06:19 AM
The Google sheet has change name for no reason and the new sheet does not have all the customised formatting I had applied over the last few months, (i.e. new columns with values and hidden columns). This appears to have happened automatically since i haven't used it in several days.
Old Sheet name: Form Responses 1
New Sheet Name: Submissions
- dtplisneyAnswered on March 19, 2015 at 06:25 AM
Furthermore, when I view the the 'revision history' from 9.24am today, every record is shaded pink. This is strange since only 10 submissions have been made since last week.
- CharlieAnswered on March 19, 2015 at 10:40 AM
Apologies for the inconvenience. If you have updated your form or changed anything on it, it is highly probably that this is the cause of resetting the default formatting in your Google Spreadsheet, this is to make sure that everything is linked properly. I will escalate a ticket about the issue you have described, but I do not know when or if it can be fixed.
You could also try another integration method: JotForm -> Zapier -> Google Spreadsheet. It should not change your custom Google Spreadsheet formatting.
You can check it here: Add JotForm Submission to Google Docs Row. We will let you know if we have any updates.
Regarding the revision history, I'm not sure if I understand you correctly, are you referring to the changes you made in your Form or is it something still related to Google Spreadsheet?
- alp_denizAnswered on March 24, 2015 at 06:45 PM
An improvement has been made very recently on Spreadsheet integration as required by Google and this had some residual effects. Those issues have also been fixed. Could you please let us know if the problem continues after re-integration?
- dtplisneyAnswered on March 25, 2015 at 05:39 AM
As far as I can see the re-integration pulls the data that was contained in the original Jotform submission, it makes no provision to data that may have been added or edited to the Google Sheet. I had additional information added to the original spreadsheet, when the re-integration was performed I lost all of it. I wasted hours manually inputting the information all over again. How can this be prevented in the future. My confidence has been shattered with this jot form and Google Sheets integration...
- alp_denizAnswered on March 25, 2015 at 05:47 AM
My humble apologies for all this inconvenience.
As you pointed out, this has been one of the most important issues and we have started implementing a better solution to Spreadsheets modifications.
I will update this thread when it goes live.
Thank you for feedback. It is very much appreciated.
- JotForm SupportWelvinAnswered on March 30, 2015 at 10:40 AM
I'm sorry to hear that. Will be checking your problem to this thread: http://www.jotform.com/answers/543042.