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 not working

    Asked by thegreatandroid on August 08, 2013 at 12:59 PM

    New submissions are not being pulled to the spreadsheet, i ve tried removing and reappling the integration multiple times but the submissions are not pushing to the spreadsheet.  

    It was working for awhile with no problems and quite fast, but now nothing pulls to the spreadsheet. 

    The google drive integration works fine though.  

    I havent changed any columns on the spreadsheet.

    Page URL:
    http://missionpropertyrunners.com/Inspection_report/inspection.html

    Submissions
  • Profile Image
    JotForm Support

    Answered by KadeJM on August 08, 2013 at 02:23 PM

    Hello, I just checked this on a clone of your form and the integration seems to be working as it should sending the data through to google spreadsheets. Can you please try removing the integration, clearing your form cache, then reintegrate with google spreadsheets to rebuild it and see if this resolves the issue. Please let us know if you are still having problems with this.

    Screenshot of my Test Results:

  • Profile Image
    JotForm Support

    Answered by KadeJM on August 08, 2013 at 02:24 PM

    Pardon, I see that you mentioned this already additionally but please try doing it the way I have recommended and then let us know so that we can look into it more if necessary.

  • Profile Image

    Answered by thegreatandroid on August 12, 2013 at 06:42 PM

    I have performed everything you requested and it worked for a day, then went back to not pulling data around 10 am PST this morning, and i re integrated to a different spreadsheet. the new spreadsheet isnt pulling either the last pull was from 1:00 pm PST 

     

    Just wondering if there are any tips when working with the spreadsheet, will data pull to it when the spreadsheet is open or activily being filtered?

  • Profile Image
    JotForm Support

    Answered by jonathan on August 12, 2013 at 07:52 PM

    Hi,

    "Just wondering if there are any tips when working with the spreadsheet, will data pull to it when the spreadsheet is open or activily being filtered?"

    If I understand correctly, you meant to ask if the updating of spreadsheet base on the form submissions will still work while the spreadsheet is opened and in-used. 

    The answer is Yes. You just need to refresh the spreadsheet to see the updated data base on the form's submission results. BUT, please take note that, certain editing process on the integrated spreadsheet can break the integration. For example, changing the column headers of the spreadsheet can break the integration.

    I hope this answers your inquiry. Please inform us if you need further assistance.

    Thanks.