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: Spreadsheet not synching on jotformEU.com domain

    Asked by sasa999 on March 13, 2013 at 03:41 AM

    I have conected my form to Google spreadsheet, but it transfer only data that was submited before connection. Any new submision is not shown in spreadsheet, I got only email with form data. When I reconect, then it sends all missing data, but anyway any new submissions after reconection is not visible in Google spreadsheet. Can you help resolve this. Yrsterday I tested many times, but with no results. How much time take sinhronisation with google? May be more than 12 hours? Had tested right from here in prewiev, and from google blog. Mail notifications works fine.

    Submissions email form data not visible
  • Profile Image
    JotForm Support

    Answered by EduardoMendez on March 13, 2013 at 08:41 AM

    Hi there, 

    Can you please provide us the URL of the form so that we can test and if necesary forward this to our dev team?  

    Meanwhile, you may want to look into our HTML listing Report.  It can be embedded in a page or on a form and updates with every entry.  Here is a guide to help you with that:

    http://www.jotform.com/help/209-Create-an-HTML-Table-Listing-Report

  • Profile Image

    Answered by sasa999 on March 16, 2013 at 06:54 AM

    Tnx for answer! You can look all my forms. They all is not visible in google spreadsheet. I cen see only old submissions. I was trying Chrome, firefox, ie8, chache and cokies cleaning, form cloning, user account changing, meny reintegrations, but nothing helps get spreadsheet alive. Yesterday I found that there is no any importHtml on google spreadsheet that is created by jotform. I am not programmer anb maybe I am wrong.  How do you transfer data to google spreadsheet? through importHtml or differet way? Can you write right adress where is stored table that contains data table that shoud be in google spreadsheet.  I wiil try manualy resolve problems with dead Google spreadsheets.

  • Profile Image
    JotForm Support

    Answered by KadeJM on March 16, 2013 at 10:58 AM

    Hi, I've done some additional investigating on a your forms and so far it is noted that you don't really have a whole lot of submissions on any of your forms but when you re-integrate it will grab all of the details and show it on your form to recompile it and from what I can tell the Integration is working properly as I was unable to replicate the same problem. Please try removing the integration then add it again. If you are having trouble with understanding the Google SpreadSheet Integration then I would like to recommend that you read it's guide throughly. If you are still having trouble please let us know.

  • Profile Image

    Answered by sasa999 on March 16, 2013 at 06:10 PM

    I can not understand where and how you coud see that if my list 5 minutes ago was empty without any records

    next after reintegration that i see on jotform after 2 submissions from 2 computers

    this is what i see in Google spreadsheet

     

    can you see difference in records. I look this for 3 diferent computers with different browsers. Submiting from 2 different computers..

    http://jotformeu.com/form/30735786061356

    try fill form and submit

    there is link to my spreadsheet that you can see how nothing changes for new submissions - they are invisible for Google

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

    p.s Have read http://www.jotform.com/blog/57-Google-Docs-Integration-Send-Responses-to-Google-Spreadsheets-Instantly

  • Profile Image
    JotForm Support

    Answered by EltonCris on March 16, 2013 at 06:46 PM

    Hi,

    Thank you for all the details. I have escalated the problem to our development team so they can look into this further.

    Meantime, please try to clone this form: http://form.jotformpro.com/form/30746882963972? and integrate it to Google Spreadsheet. If the problem still persist, let us know so we can add it on the report.

    Thanks and apologies for the incovneniences caused.

  • Profile Image

    Answered by sasa999 on March 16, 2013 at 07:47 PM

    There is results

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

    link to cloned form http://jotformeu.com/form/30747834207355

    Let me know if you will be able make new submissions that i can see they in my spreadsheed 

     

  • Profile Image
    JotForm Support

    Answered by EltonCris on March 16, 2013 at 10:43 PM

    @sasa999

    Thanks for your cooperation. The problem has been escalated to our dev team. They'll get back to you as soon as they check this thread. Thanks!

  • Profile Image

    Answered by sasa999 on March 19, 2013 at 09:12 AM

     

    Today I check My form and found my google integration link is broken., After reintegration my google spreadsheet got data from JotForm :))))

    OK that is good,  All works . I am happy BUT ...:(

    It start sending data to another (new) spradsheet. How to get data in my old spreadsheet? 

    http://www.jotform.com/answers/193786-Google-spreadsheet-reintegration#0

  • Profile Image
    JotForm Support

    Answered by Welvin on March 19, 2013 at 11:50 AM

    @sasa999,

    Yes, reintegration will give you another spreadsheet. That is how it works. Unfortunately, all custom data to the old spreadsheet can only be moved manually. You will have to copy and paste them as stated by my colleague Gleen on the thread provided.

    Thank you.

  • Profile Image

    Answered by tanawat on April 20, 2013 at 01:46 AM
    facebook
  • Profile Image

    Answered by canerbalci on May 09, 2013 at 09:29 AM

    This is a bug related to Google Spreadsheets Api not accepting working with column names starting with numbers. For a quick workaround, can you please rename your columns that start with numbers to something like "Number 1", "Number 2", etc...

    I am looking for a fix, however there seems no easy way since changing the behavior for this particular case has the potential of disrupting already working integrations of thousands of users.

    Closing the ticket for now.