- webreakAsked on July 18, 2017 at 05:51 PM
I tried reintegrating, clearing the cache and restarting and it didn't work. I see that only my jotform sheets are having this issue.
- JotForm SupportjonathanAnswered on July 18, 2017 at 05:55 PM
I assume this was your form that have the issue. I have manually trigger google spreadsheet submissions from the form. Can you please check again now if you are able to load the spreadsheet on your browser.
Let us know if issue persist.
- webreakAnswered on July 18, 2017 at 05:58 PM
I changed the description of this issue. That was not necessarily the form in question but that one is having issues when I attempt to copy from the sheet as well...
- JotForm SupportjonathanAnswered on July 18, 2017 at 07:42 PM
Thank you for clarifying what the issue was about. I was able to replicate it when I test on my form google spreadsheet integration.
I will investigate on the issue more. I'll get back to you with an update shortly.
- JotForm SupportjonathanAnswered on July 18, 2017 at 07:49 PM
I was able to confirm that the error only happens to the spreadsheet used by form integration. It doesn't happen to the spreadsheet that was not used by JotForm google spreadsheet integration.
I submitted a bug ticket report to the higher team support.
We apologize for any inconvenience caused. We will let you know once we have fixed the issue.
- Ross DavisAnswered on July 19, 2017 at 03:38 PM
Me to on this same issue. Form: https://form.jotform.com/71735133769160
I receive the error on any attempt to copy.
- JotForm SupportjonathanAnswered on July 19, 2017 at 04:26 PM
We will resolve your issue on your own thread here https://www.jotform.com/answers/1203551
- JotForm SupportjonathanAnswered on July 20, 2017 at 05:35 AM
Our developer have now fixed the issue with copying multiple cells data in sheet used by google spreadsheet integration.
The issue was related to Google spreadsheet cells that do not have borders on it.
You can apply the fix in 2 ways on your form current google spreadsheet integration.
#1 Redo the google spreadsheet integration of the form. Removing the integration and adding it back again to the form will update the related sheet in the spreadsheet integration.
#2 Manually add the cells borders in the Sheet used in google spreadsheet integration. This should fix the issue without removing the existing google spreadsheet integration.
Let us know if issue still persist.