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

    My form creates a new Google spreadsheet after each submission.

    Asked by matthewr on June 12, 2012 at 06:08 PM

     

    I've created a form and integrated it with Google Docs and DropBox. I've been testing it and it was working perfectly until I deleted the spreadsheet in Google Docs and removed the integration. I wanted to start with a fresh spreadsheet, so I re-integrated Google Docs with my form and now every time I submit the form it creates a new version of the spreadsheet. The forms are identical except the new version has the latest submission data and a new URL of course. I don't want to have to keep deleting older version of spreadsheets, I'm not sure why the new submissions aren't added to the original spreadsheet.

    I've tried disconnecting and re-establishing the connection multiple times, integrating the form with a different Google account, cloning the form and then integrating the cloned version and nothing seems to work. The form is really long and it took me some time to customize it, so I don't want to have to start from scratch. 

    Please let me know if there's some setting I can change to fix this.

    Thank you!

    Page URL:
    http://form.jotform.us/form/21636379160152

    google integration dropbox Submissions different integrated
  • Profile Image
    JotForm Support

    Answered by jonathan on June 12, 2012 at 06:57 PM

    Hi,

    If the form was edited/updated and then re-integrated, will create a new instance of the google spreadsheet. This is the current behavior of the integration.

    As long as you do not edit/update elements on the form (i.e. add/edit labels), the spreadsheet will not change or create a new set.

    What we can advise is to "finalize" form before finally integrating it to google spreadsheet. This way, the changes on the spreadsheet will be minimized. You can actually make revisions on the spreadsheet end (i.e. insert column, formulas, rows.. so on) without altering the form.

    BUT just do NOT change the column names on the spreadsheet that were derived during the integration. Because if this happen, the integration will be broken, and the succeeding form submission will fail to map to the appropriate column/fields.

    Btw, a feature request ticket was already submitted to our dev team to request to modify the current behaviour. We will be informed when this feature gets updated.

    Hope this help. Please inform us if further assistance is needed.

    Thanks.

  • Profile Image

    Answered by matthewr on June 13, 2012 at 09:32 AM

    Hi Jonathan,

    Thank you for responding so quickly. I understand what happened now, but I don't know how to fix the current problem. So you're saying that I should remove the current integration with Google, make all the necessary changes to my form, and then once the form is ready, I can re-integrate the form with the same Google account and I shouldn't have a problem anymore? Also, if that is what you suggest, should I delete the other existing spreadsheets that JotForm created in that Google account? 

    Thanks again.

  • Profile Image
    JotForm Support

    Answered by NeilVicente on June 13, 2012 at 10:00 AM

    @matthewr

    I believe that's exactly what my colleague advised you to do. You should remove the current integration with Google Docs if you're doing test submits while editing the form, to prevent spreadsheets of the same name from piling up on your JotForm folder.

    Also, if that is what you suggest, should I delete the other existing spreadsheets that JotForm created in that Google account?

    Ideally, yes.

  • Profile Image

    Answered by Spreadsheet help on June 18, 2012 at 08:31 AM

    At macro level you are dealing with maintaining sheets and integrating with sub sheets. I hope this is what you are trying to explain,. Well, honestly this problem is unanswered by Google docs. I was reading through a lot of article and found this tool called Collatebox http://www.collatebox.com/ which deals with master sheet and sub sheet. each time you update a sheet the subsiquent sub sheet get updated automatically creating a different view for the owner. So he does not have to keep creating different sheets instead just create a view of the sheet. I would stronglr recomment you to register with them and get in touch with them..They may be a complete game changer.

  • Profile Image

    Answered by webtools@heart.org on January 16, 2013 at 10:54 AM

    I just wanted to check to see if there has been any progress with the feature request ticket that was submitted regarding this Google Spreadsheet integration.

  • Profile Image
    JotForm Support

    Answered by EduardoMendez on January 16, 2013 at 12:11 PM

    @webtools@heart.org

    Can you please let us know which feature request you are speaking about?

    We'll be glad to check for you!

  • Profile Image

    Answered by webtools@heart.org on January 16, 2013 at 12:17 PM

    The issue where if you integrate a form with Google spreadsheets, but then make an edit to the form, this will create a new spreadsheet. Here is the answer that was given on June 12, 2012:

    "Hi,

    If the form was edited/updated and then re-integrated, will create a new instance of the google spreadsheet. This is the current behavior of the integration.

    As long as you do not edit/update elements on the form (i.e. add/edit labels), the spreadsheet will not change or create a new set.

    What we can advise is to "finalize" form before finally integrating it to google spreadsheet. This way, the changes on the spreadsheet will be minimized. You can actually make revisions on the spreadsheet end (i.e. insert column, formulas, rows.. so on) without altering the form.

    BUT just do NOT change the column names on the spreadsheet that were derived during the integration. Because if this happen, the integration will be broken, and the succeeding form submission will fail to map to the appropriate column/fields.

    Btw, a feature request ticket was already submitted to our dev team to request to modify the current behaviour. We will be informed when this feature gets updated.

    Hope this help. Please inform us if further assistance is needed.

    Thanks."

  • Profile Image
    JotForm Support

    Answered by EduardoMendez on January 16, 2013 at 12:26 PM

    Thanks for your response!

    The situation as it stands is that the integration continues to be the same.

    You can edit the content of the sheet, however, you can not edit the headings of the columns.

    In all truth, I do not see the possibility to have an integration where the headers can be changed and not break the integration.  You may want to have a separate spreadwheet where you can copy the information from the original and format as you wish.

    I hope this helps!

  • Profile Image

    Answered by collegeplus on March 22, 2013 at 12:55 PM

    I'm having trouble with googledocs creating new spreadsheets with each submission.  It happens when I use a form which was never integrated with GoogleDocs, as well as clones of an existing form.  Ideas?

  • Profile Image
    JotForm Support

    Answered by Welvin on March 22, 2013 at 01:29 PM

    @collegeplus,

    If your Form Field Labels comes with a special characters such as / (slash), - (minus), * (asterisk). I'd suggest you to remove them and only use a plain text. These special characters causes the issue to happen sometimes or oftentimes.

    May we also know the said Form, form URL?

     

    Thanks

  • Profile Image

    Answered by Joe  on September 18, 2016 at 09:56 AM

    I have an problem with google forms. I need to grade an assignment but I have permanently deleted the spreadsheet associated with a google form. Can I create a new spreadsheet to grade the assignment? Thanks.

  • Profile Image
    JotForm Support

    Answered by EltonCris on September 18, 2016 at 11:20 AM

    @Joe

    Your question doesn't seem to relate with JotForm. If you have issues with your Google forms, you can contact Google support.

    Thanks!