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 Spreadsheet Integration: Unable to load file error

    Asked by kkorstad on November 18, 2016 at 04:27 PM

    I have a form that I have integrated with Google Spreadsheet.  I keep getting the error -- Unable to Load File on the Google Spreadsheet .  I only get this error if I have data in the spreadsheet from my form.  If I clear out the data for my form it opens just fine.

    I tried different browsers, mac, pc, etc and this keeps happening.  Deleted the integration, re-integrated and still won't work.

    Here is a video of what is happening to me:

    My JotForm is here:

    https://www.jotform.com//?formID=62786252928165

    and lives on the website here:

    https://tic.miracosta.edu/requests/

    Please help.

     

     

     

     

     

     

    Page URL:
    https://tic.miracosta.edu/requests/

    Screenshot
    google spreadsheet error load file
  • Profile Image
    JotForm Support

    Answered by Mike on November 18, 2016 at 07:03 PM

    Thank you for contacting us.

    Personally I cannot reproduce the issue while testing a cloned version of your form with integration to my Google account.

    Here some Google users reported that a similar error was caused by browser extensions. Could you please do a quick test with disabled browser extensions on your end?

  • Profile Image

    Answered by kkorstad on November 21, 2016 at 02:44 PM
    I’ve disabled plugins, used other computers, other browsers, Chrome, Edge, Internet Explorer, Firefox.
    I still keep getting unable to load for the google spreadsheet if I have data on the form.
    I created a clone of my form, without data the integration worked. With data it bombs. I’m thinking something coming from jot form with the data is upsetting the integration. Could it be one of your data plugins? I used 2 different ones for email and dates.
    Karen Korstad
    Faculty Technology Specialist
    Online Education Department
    [cid:07C95311-81F2-4B82-8110-BD1DB9F98486]
    Oceanside Campus
    1 Barnard Drive MS# 11A
    Oceanside, CA 92056
    P 760.795.6787
    kkorstad@miracosta.edu
    https://tic.miracosta.edu
    ...
  • Profile Image
    JotForm Support

    Answered by KadeJM on November 21, 2016 at 04:55 PM

    Karen, thank you for the update about that and for trying and letting us know.

    I have a google account as well so I have done some additional testing of this with a submission I prefilled onto a cloned copy of your form prior to integrating it with google's spreadsheets just to see what would happen for my side of things.

    Unfortunately, my results were the same as my colleagues as well where I was able to successfully integrate with google spreadsheets on my end.

    I've cleared your form caches to refresh things for your account so I would suggest removing the spreadsheet integration and trying it again to see if that helps to resolve it or not.

    If for some reason there's still an issue just let us know and we'll try to investigate further to assist with getting to the bottom of your issue since it's occurring with one of our generated spreadsheets.

  • Profile Image

    Answered by seedstars on December 01, 2016 at 12:43 PM

    HI, I have the exact same issue. I can't see the spreadsheet since it is unable to load everytime I try to open it to check the results.

    Did you figure out what could be the issue?

    THanks

  • Profile Image

    Answered by kkorstad on December 01, 2016 at 01:45 PM
    No, this is not resolved for me either. I have been working with support and they say they can’t duplicate. However I can. I’ve done everything possible I can think of. The only time it works is if the form has no data in it. As soon as it has data then it won’t work and gives me the error.
    I’ve even copied my form, then started again and same results. Support hasn’t admitted to the problem to date.
    Karen Korstad
    Faculty Technology Specialist
    Online Education Department
    [cid:07C95311-81F2-4B82-8110-BD1DB9F98486]
    Oceanside Campus
    1 Barnard Drive MS# 11A
    Oceanside, CA 92056
    P 760.795.6787
    kkorstad@miracosta.edu
    https://tic.miracosta.edu
    ...
  • Profile Image
    JotForm Support

    Answered by KadeJM on December 01, 2016 at 02:05 PM

    I've checked this again and it was the same result unfortunately but, I have a question for you after looking at this some more.

    I see there's one submission shown on the spreadsheet when your issue occurs:

     

    Where is the one line of data shown on your spreadsheet coming from?

    Was that a previous submission that was sent to you when you had it integrated or did you copy and paste that onto the spreadsheet from somewhere?

    Are you doing anything to modify the spreadsheet after integrating it?

    That can cause these types of problems if that is the case and could be a possible reason behind it.