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

    All integrations are duplicating Google spreadsheets on each submission

    Asked by sommier on May 31, 2013 at 06:03 PM

    Hello:

    All integrations are duplicating Google spreadsheets on each form submission... We have a lot of spreadsheet copies right now and they keep on duplicating on each form submission!

    In one form, I tried removing the integration and re-creating it, and it seems to work fine. But it's a huge work each time I do that, because I have a very specific format in Google Spreadsheet.

    So I'd like another solution rather than removing all integrations, recreating them all, and reapplying all formats again to the Spreadsheets.

    Besides, I don't know why that happened, and if it happens again, I will have to do it all over again. So it's no safe option.

    Is it possible to tell you what Google Spreadsheet to save the data into, for each form integration, instead of letting the integration create a new one?

    Thank you!

    PS: By the way, noone is modifying the Google spreadsheets headers directly (nor any other part of the Spreadsheet), which could be a cause for that behaviour...

    Page URL:
    sommiercenter.com/soporte

    Screenshot
    integrations format create solution
  • Profile Image
    JotForm Support

    Answered by jonathan on May 31, 2013 at 07:48 PM

    Hi,

    I am not able to reproduce this issue when I tested using a cloned of your form.

    This is the google spreadsheet https://docs.google.com/spreadsheet/ccc?key=0ArHMx2ARJqlrdHpab0syZG5vaEJCV05PMHJrS3R4dGc&usp=sharing

    The integrated spreadsheet is not repeatedly created every time I do submission on the form

     

    This is the test form http://www.jotformpro.com/form/31507054134949?

    What I can suggest for you to do right now, is try to clone your form (guide: Form-Cloning). Then integrate the cloned form.

    I know it will become a different form, and submissions will different. But you can at least try this method for now, and check if this resolves the spreadsheet duplication issue every time the form is submitted.

    Hope this help. Please continue updating us if the issue persist.

    Thanks.

  • Profile Image

    Answered by sommier on June 03, 2013 at 01:10 PM

    I think it would be simpler to remove integration and re-integrate...

    It worked with one of my forms, so it should do the same with the rest, despite I wanted to avoid it for the described reasons...

    Do you think that cloning the form could prevent the problem from ocurring in the future?
    I mean: cloning the form and integrating, is it better  than just removing integration and integratin again?

    Thanks

  • Profile Image

    Answered by sidharth_kch on June 03, 2013 at 02:12 PM

    @sommier

    Removing and re-integrating with google spreadsheet should definitely help.

    Also, I have cloned several forms and was not able to reproduce this issue. You may like to clone and integrate with google spreadsheet and see if that solves your issue.

    Let us know the outcome.

    Thanks,

    Sidharth

  • Profile Image

    Answered by sommier on June 03, 2013 at 05:39 PM

    I'll do that, thanks.

    We don't know why this happenned... it seems to be something like a random issue on the integrations. I hope it does not occur again in the future!

    Thank you!

  • Profile Image
    JotForm Support

    Answered by Welvin on June 03, 2013 at 07:09 PM

    Hi,

    If the issue persists, let us know so we can double check everything. Forward to our developers if needed.

     

    Thanks