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 not working properly submission does not appear in the spreadsheet

    Asked by smithkim on April 07, 2013 at 04:32 PM

    I have seen other posts relating to this in the past but I dont think it has been resolved.

    I have integrated my jotform with google spreadsheets and the integration worked well but when I enter new test data into the form and click submit, it does not appear in the spreadsheet. It appears on the submissions page of jotforms and i get an email to say that the submission has been received but its not automaticall populating the spreadsheet.

    This was previously working so what is wrong?

    Thanks

    Page URL:
    http://form.jotformeu.com/form/22973654693366

    Submissions JotForm email submissions page
  • Profile Image
    JotForm Support

    Answered by jonathan on April 07, 2013 at 05:23 PM

    Hi,

    I was able to reproduced the same issue when I tested a cloned of your form https://www.jotform.com/22973654693366

    BUT I also found a temporary solution for it.

    The integratation seems to be broken when the fields on your form starts with numbers

     

    I changes this labels to not begin with number...

     

    and the integration was fixed.

    Please test this form http://www.jotformpro.com/form/30966365485971

    This the shared integrated google spreadsheet

    https://docs.google.com/spreadsheet/ccc?key=0ArHMx2ARJqlrdHdocVlzdk11MjRWSmlsU0R0TVFFQmc&usp=sharing

     

    Please try applying the solution on your end. Test if it works also.

    Thanks.

  • Profile Image

    Answered by smithkim on April 07, 2013 at 05:51 PM
    Thanks for that. It does seem to work better but the spreadsheet only seems to update when I refresh the page. However, this might be because I'm using my ipad to test it, I'll try it with the laptop tomorrow and let you know if its still an issue.Kim
  • Profile Image
    JotForm Support

    Answered by jonathan on April 07, 2013 at 06:18 PM

    Thank you Kim. Do update us again later of the results.

    thanks.

  • Profile Image

    Answered by smithkim on April 09, 2013 at 12:46 PM
    This was working perfectly until I added some more fields to my form. It has now created another submissions spreadsheet by the same name. Since I have already some complex calculations to the original submissions spreadsheets, I would like the submissions to still go to the original one rather than the second it has created. How can I do this?
  • Profile Image
    JotForm Support

    Answered by Welvin on April 09, 2013 at 01:41 PM

    Hi Smith,

    Note that adding more fields will most likely break the integration. It does not automatically add the fields to the spreadsheet result. I know that it will need another time, but I'd suggest you re-create the integration to correct and include the new fields.

    Anyway, a report is already created. We'll let you know if updates will be made about this.

     

    Thanks

  • Profile Image

    Answered by smithkim on April 09, 2013 at 02:01 PM
    When you say re-create the integration, that would mean starting all over again with the submissions data, ie recreating my added field in the spreadsheet.
  • Profile Image
    JotForm Support

    Answered by Welvin on April 09, 2013 at 02:53 PM

    Hi,

    Yes, you will have to start from scratch again. Including the custom Calculations or any formulas you have on the spreadsheet. 

    Also note, to never modify the first row which contains the field labels because that will also break the integration.

    I'd also like to suggest to create another spreadsheet and add/create the calculations or formulas there and just copy/paste the results from the Google Spreadsheet Integration. This way to avoid breaking the spreadsheet result.

     

    Thanks

  • Profile Image
    JotForm Support

    Answered by liyam on July 21, 2013 at 10:07 PM

    We apologize on missing to update you on this matter, smithkim.  We've made some changes just recently that handles the problems reported on Google Spreadsheets integration.

    Please do let us know if you continue to experience problems with any of your forms with integrations.

    Thanks.