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 Docs spreadsheet is not updated after editing

    Asked by idanfactor on May 13, 2012 at 02:22 AM

    The integration with google spreadsheets is amazing! 
    Jotform is such a brilliant tool. 

    With great power come great problems:

    I noticed that when I edited the data in the integrated spreadsheet it was stopped from being updated,
    One thing is for sure: Google spreadsheet was stopped of being updated.
    What is the exact reason and how I can solve it?

    thanks! :)

     

  • Profile Image

    Answered by gori-mathew on May 13, 2012 at 03:15 AM

    Hi,

    We sorry for what this issue has caused you. Unfortunately, you can not change/edit data in the spreadsheet  and still have the data being imported. You will have to make changes of either the through JotForm.

    Can you try to remove the integration and re-integrate it again. Try it out and lets know if this works.

    For more guidelines, please read on; http://www.jotform.com/blog/57-Google-Docs-Integration-Send-Responses-to-Google-Spreadsheets-Instantly-

    Please also lets know the Form's URL to have alook at it and see if we can find a workaround.

  • Profile Image

    Answered by idanfactor on May 13, 2012 at 03:29 AM

    Thanks, I think you should consider to change this feature and allow to spreadsheet to update after editing... 

  • Profile Image
    JotForm Support

    Answered by liyam on May 13, 2012 at 05:25 AM

    We apologize for this.  Currently, what happens on my end is that an edited submission turns out to be a new submission in google spreadsheet.  Is this what's happening to yours now?

    I will let the development team know about this.  As soon as we have updates, we'll let you know immediately.

    Thanks for your patience.

  • Profile Image

    Answered by Nieboy on June 12, 2012 at 11:19 AM

    yes please, I have been struggling with this too.  I am making changes to my form and it is causing the original form to be ignored and I have to re-integrate google docs which creates a duplicate speadsheet in goole docs (drive :)). I have a relatively complex sheet added to the origonal submissions sheet and I need to cut and paste the old sheet over to the new submissions spreadsheet. 

     

    I can see the problem with editing the main submissions sheet from within google, but if the form is changed on Jotforms side then I think it should update the speadsheet in google docs.

     

    I will be patiently waiting for a update, until then I will need to cut and paste and delete the old spreadsheet i suppose.

  • Profile Image

    Answered by jniles on July 27, 2012 at 03:36 PM

    I was experiencing the same issue, the Google Docs didn't update when I had made changes to the form. Also, we need to add additional columns to the Google Docs that doesn't appear on the form but is used by our department internally to track the submission requests, is there a way to add a feature/function to parse/import original Google Docs from JotForm to another Google Docs to keep both updated docs updated dynamically real time? Any tips would be greatly appreciated.

  • Profile Image

    Answered by EngPaired on July 27, 2012 at 04:09 PM

    I have also had problems with this. It is also discussed in this thread: 

    http://www.jotform.com/answers/97679-Can-we-customize-this-at-all-Google-Docs-Integration-#12

    I ultimiately decided to abadon using the google Docs integration for forms that I knew would still change and instead use the Google Doc function importHTML to import my data from an html table report. (i.e. use  =importHTML("http://www.jotform.com/table/210941800600XX", "table", 0) ).

    This is a pretty complex way to achieve what is much easier with the integration, but it gives you more control and you can change your form all you want and it will keep importing to the same sheet.

  • Profile Image

    Answered by jniles on July 27, 2012 at 04:19 PM

    How do I obtain my form's jotform url table??   I see something like this when I view my form data in JotForm  http://www.jotform.com/submissions/21986584624xxx

  • Profile Image

    Answered by EngPaired on July 27, 2012 at 06:21 PM

    The HTML table is generated as a report for the form. So select the form, go to reports, add new report, and select HTML table. When you make that report it will give you the url for the table.

    As I'm writing this though, the thought occured to me that I'm not sure that report updates automatically if you change the form either. I know that most reports will NOT update to add new fields so you have to explicitly go back and regenerate the report. Again, I believe the mentality here is that once you have a form and people start using it you aren't planning on changing it. I personally find that philosphy inadequate for the way I am using the tool, but perhaps it is true for many users. 

  • Profile Image
    JotForm Support

    Answered by liyam on July 28, 2012 at 09:28 PM

    Thanks for responding to jniles, EngPaired.

    To answer your question, remember that we select the fields that we wish to appear on our reports?  So this means that by default, these new fields added when you edited your form are unchecked in the reports wizard. You will need to edit the report, tick the checkbox, and continue the end of the wizard for it to be saved and for it appear on the report page. 

    So there is no need to regenerate the report, just edit your report and check the new field will do fine.

    Warm regards.