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

    Error when copying multiple cells in integrated google sheets

    Asked by webreak 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
    JotForm Support

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

    Answered by webreak 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
    JotForm Support

    Answered by jonathan 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
    JotForm Support

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

    Answered by Ross Davis 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.  



  • Profile Image
    JotForm Support

    Answered by jonathan on July 19, 2017 at 04:26 PM


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


  • Profile Image
    JotForm Support

    Answered by jonathan 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.