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

    Can not integrate one form with a Google Spreadsheet

    Asked by OAF_Jobs on September 10, 2014 at 11:44 AM

    I am trying to integrate my form with Google spreadsheets. However, it isn't putting the information into a new spreadsheet (or creating one) and won't put it into a new spreadsheet that I created. Where is the information going and how can I make it appear on a spreadsheet?

    Page URL:
    POPSApplicationForm2(September8-Present)

    google spreadsheet integration
  • Profile Image

    Answered by jedcadorna on September 10, 2014 at 12:44 PM

    I just made some test with google spreadsheet and it works fine on my end. It sends data for every completed form.


    Kindly check if your integration is connected if not please try to integrate your form again. Please follow this guide on how to integrate your form https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet.

    Also try clearing your browsers cache and form cache before testing the integration.

  • Profile Image

    Answered by OAF_Jobs on September 11, 2014 at 01:19 PM

    Hello, 

    We are continuing to have difficulties with integration. Multiple members of our team have tried to integrate Google spreadsheets and continually receive an error message (as shown below). I have de-integrated and re-integrated the form more times than I can count, and it still isn't working. Jotform is not doing any of the following:

    A) Creating a new form where it puts information;

    B) Putting information in a newly created form;

    C) Putting information in an old form.

    This is the fourth time I've asked for help, and only one answer that I've received from your team has been partially helpful. Please look at this as soon as possible. If there is a phone number at which Customer Support can be reached, I would really appreciate it so that we can get this figured out and get our business back up and running. Thank you! 

  • Profile Image

    Answered by jedcadorna on September 11, 2014 at 01:30 PM

    I would like to ask permission to test the integration in your account. Also can you provide the form URL where we can run our test with google spreadsheet. I'll probably use my google account. 

    We need to do reproduce the error on our end to properly document and submit it to our 2nd level. By the way if you haven't tried clearing your form cache please try and let us know whether it works or not. Sometimes clearing form cache resolves integration problem.

  • Profile Image

    Answered by OAF_Jobs on September 11, 2014 at 03:20 PM

    Hi, 

    Thanks for your quick response. The form was still unable to integrate after I cleared my cache. 

    The form URL is: http://www.myjotform.com/form/40471746260553

    Thanks!

  • Profile Image

    Answered by OAF_Jobs on September 11, 2014 at 03:26 PM

    Hi, 

    Thanks for your quick response. The form was still unable to integrate after I cleared my cache. 

    The form URL is: http://www.myjotform.com/form/40471746260553

    Thanks!

  • Profile Image
    JotForm Support

    Answered by Mike_T on September 11, 2014 at 05:11 PM

    I was able to reproduce the Google Spreadsheet integration issue on your form #40471746260553. It is probably that the Google Spreadsheet can not accept such a big amount of the form submissions upon integration and failing due to this.

    We have attached a bug report ticket to this thread and escalated it to our Next Level Support.

    We will get back to you as soon as we have any updates on this.

  • Profile Image
    JotForm Support

    Answered by alp_deniz on September 13, 2014 at 08:47 PM

    Hello,

    I have carefully studied the issue and made significant performance enhancement on the process.

    Now I am able to generate over 7,000 submissions at once, although an error is displayed. I expect you to see your spreadsheet link after the error.

    I suppose you can now use it, as I will be working on a permanent solution to initialize google docs spreadsheet with relatively huge data.

    Please let me know if you cannot have your spreadsheet.

    Kind regards