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

    Google Integration generates an error spreadsheet link

    Asked by jsaffir on August 05, 2013 at 01:39 AM

    This is what I get:

    https://docs.google.com/spreadsheet/ccc?key=error

    I have cleared browsing data and cookies many times as was suggested in other posts.  I tried renaming the spreadsheet.
    I have deleted all files in my Google Drive, closed my browser (Chrome) and removed integration numerous times.  I also tried it in Explorer.  I hope you can help.  Thank you very much.

    Page URL:
    http://ppmtamusicoftheamericas.weebly.com

    integrate
  • Profile Image
    JotForm Support

    Answered by Welvin on August 05, 2013 at 02:55 AM

    Hi,

    I'm not able to replicate that to my end. Please try to first remove the broken integration and integrate it again. Clear your forms cache as well: How to Clear your Form Cache.

    Let us know for the results.

    Thanks

  • Profile Image

    Answered by jsaffir on August 05, 2013 at 02:30 PM

    I cleared my form cache after removing the broken integration and got the same thing:

    Your spreadsheet can be found here:

    https://docs.google.com/spreadsheet/ccc?key=error

  • Profile Image

    Answered by khrisell on August 05, 2013 at 04:09 PM

    Hello, 

    Since none of the clearing of browser dataworks, I highly suggest that you create a new account on google and re-integrate using the new account. And if problem persists, kindy let us know then we'll investigate further or escalate the issue to our higher level of support.

     

    Thank you for using JotForm

  • Profile Image

    Answered by jsaffir on August 05, 2013 at 04:46 PM

    I created a brand new Gmail account and still got the following:

     

    Your spreadsheet can be found here:

    https://docs.google.com/spreadsheet/ccc?key=error

     

    I'm using Chrome.  Could that be a problem?

  • Profile Image
    JotForm Support

    Answered by EltonCris on August 05, 2013 at 06:02 PM

    @jsaffir 

    You've reached the spreadsheet maximum column limits that's why integration can't provide you a working link.

    Google spreadsheet maximum column limit is 256 per sheet. Looking at your form, you have a matrix element which has 35 rows with 10 columns. If we calculate that, that's equivalent to 350 columns or more. Note that matrix element creates a separate column for each cell that's why I multiplied 35 by 10. You may try our reports feature instead like Grid Listing and HTML Table Listing. Here are the guides:

    Grid Listing

    Create an HTML Table Listing Report

    Thanks!