Error when copying multiple cells in integrated google sheets

  • Profile Image
    webreak
    Asked 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.

  • Profile Image
    jonathan
    Answered 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.

  • Profile Image
    webreak
    Answered 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...

  • Profile Image
    jonathan
    Answered 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.

     

     

     

  • Profile Image
    jonathan
    Answered 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.

     

  • Profile Image
    Ross Davis
    Answered 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.  

    Thanks!

    Ross

  • Profile Image
    jonathan
    Answered on July 19, 2017 at 04:26 PM

    @Ross

    We will resolve your issue on your own thread here https://www.jotform.com/answers/1203551

     

  • Profile Image
    jonathan
    Answered 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.

    Example:

     

    Let us know if issue still persist.