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 shows blank screen after authentication

    Asked by janice saffir on August 09, 2013 at 09:39 PM

    I cleared the integration, logged out, cleared my cache and cookies, and started the integration process again.   I authenticate, accept, then blank screen.

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

    cache
  • Profile Image
    JotForm Support

    Answered by EltonCris on August 09, 2013 at 10:07 PM

    Hi Janice,

    I can't seem to reproduce the problem. Would you please try it with different browsers like Chrome or Firefox? Also, try to login your gmail account with google first before integrating your form, this might help.

    Let us know if we could be of further assistance. Thanks!

  • Profile Image

    Answered by jsaffir on August 09, 2013 at 10:52 PM

    Now when I try in Chrome or Explorer, the same thing happens:  It authenticates and initializes the spreadsheet, but the url has an error at the end of the address:

     

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

  • Profile Image
    JotForm Support

    Answered by EltonCris on August 09, 2013 at 11:00 PM

    @jsaffir 

    I think I have explained this to you 4 days ago. Anyway, incase you missed it, here's the reason why you're not able to get a working spreadsheet URL.

    --------------------

    @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 25 rows with 10 columns and other extra fields. If we calculate that, that's equivalent to more than 256 columns. Note that matrix element creates a separate column for each cell that's why I multiplied 25 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!

  • Profile Image

    Answered by jsaffir on August 10, 2013 at 01:23 AM

    Yes, you did help me a few days ago.  So I reduced the number of rows to 25 from 32, I believe.  25 x 10 is 250, and you said the limit is 256.  But it's still not working.

  • Profile Image
    JotForm Support

    Answered by EltonCris on August 10, 2013 at 04:02 AM

    @jsaffir

    Yes, it's 250 but like I've said, you have other fields not only the matrix field so that's still counted. Make it 20 rows, that should solved this.

    Thanks!