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: Duplicate and triplicate entries on google spreadsheet from one form submission

    Asked by astoriarenters on January 22, 2013 at 01:56 PM

    Duplicate entries were recorded in the google docs spread sheets from one submission starting today.

    I have tried re-integrating.

    I have logged out and in and tried again.

    Browser's cookies, cache, and browsing data have been cleared on subsequent attempts. 

    On previous attempts I received "an error has occured" message with the spreadsheet being created regardless.

    Test submission showed triple entries after last re-intergation attempt.

    The forms concerned are:

    http://form.jotform.us/form/30185152880149

    http://form.jotform.us/form/30185809603151

    http://form.jotform.us/form/30185084743151

    http://form.jotform.us/form/30215415168144

     

    Previously they worked fine. The problem began today.The spreadsheets were crated in the same folder (Renter Profiles).

    Tried several things to make it work, it may have broken somewhere along the line, can you guys take a look?

    Thanks

    Screenshot
    duplicate entries multiple entries google docs google spreadsheet intergation
  • Profile Image
    JotForm Support

    Answered by Welvin on January 22, 2013 at 02:51 PM

    Hi,

    How about re-integrating the form to Google Spreadsheet? This is not actually a permanent fixed but this might help you solved that case.

    Let us know for results after some times so I can forward this to our developers for further investigation. I will try it also to see if I can replicate the same.

     

    Thanks

  • Profile Image

    Answered by astoriarenters on January 22, 2013 at 03:38 PM

    Thanks for the reply. It looks like it is working so far.

    I re-intergated only this form: http://form.jotform.us/form/30185152880149

    After a test submission, it worked properly. The rest of the forms were already integrated so I tested them before doing anything else and they seem to be working as well.

    I made a few test submissions on all 4 forms and a single entry on the spreadsheets was created.

    All these test submissions have taken up a quarter of the quota. Can you please reduce the counter becuase of this issue?

    Thank you  

  • Profile Image
    JotForm Support

    Answered by jonathan on January 22, 2013 at 06:17 PM

    @astoriarenters

    Hi, you can also delete the test submissions only on the form. I have reset your total submissions counts all the way to zero(0) for your convinience.

    Please try monitor also if the issue happen again, and inform us when you can.

    Thanks.

  • Profile Image

    Answered by astoriarenters on January 22, 2013 at 09:46 PM

    Will do, thank you.

  • Profile Image

    Answered by kplude on January 29, 2013 at 11:08 AM

    I have a similar issue, but it seems more sporadic. Certain submissions are coming through with the same timestamp to the google doc, but it's not every entry. I'm wondering if this can be prevented or if it's from people hitting the submit button more than once? 

    http://www.jotform.com/?formID=30175733279862

    Thanks!
    Kim 

  • Profile Image
    JotForm Support

    Answered by Welvin on January 29, 2013 at 12:49 PM

    Hi Kim,

    Apologize for the issue, please try adding the captcha field into your form and re-integrate the form to Google Spreadsheet as advice on my first response above.

    Please let us know for results.

     

    Thanks

  • Profile Image

    Answered by kplude on January 30, 2013 at 09:05 AM

    Hello! That seems to have fixed it, thank you!

  • Profile Image

    Answered by stephanievilla on February 28, 2013 at 06:51 PM

    Hello.  What is the straight ahead fix other than reintegrating the form?  I have at least 10 forms live across two accounts that all sporadically have double or triplicate entries and I would not like to have to reintergrate them everytime this problem appears.  Thanks!

  • Profile Image
    JotForm Support

    Answered by EltonCris on February 28, 2013 at 10:11 PM

    @stephanievilla

    That's the best option for now. This has been reported to our development team already and they are made aware on it. I have also escalated this thread to our dev team for you to received updates once a fixed is commited.

    Thanks and apologies for the inconveniences caused.

  • Profile Image

    Answered by abavicconf on March 08, 2013 at 10:47 PM
  • Profile Image

    Answered by abavicconf on March 08, 2013 at 10:49 PM

    I just wanted to add that I've been having this issue too - a single entry in a jotform form is appearing twice, three times, sometimes even up to five times in my google spreadsheet. The submission time-stamp and submission ID are identical so it is not due to clicking the submit button more than once. Also for your developers info: this is happening regardless of the device used to submit the form - I have submitted form using mobile phone (iphone and android), ipad and laptop/desktop computers running windows and mac os. 

  • Profile Image
    JotForm Support

    Answered by Welvin on March 09, 2013 at 07:47 AM

    @abavicconf,

    This thread is already forwarded to our developers, the status of this report is set to important so I am sure that our developers will surely look into this tho we can't give you any timeframe for now. If updates will be made, you'll surely know it here.

    By the way, have you tried re-integrating the form to Google Spreadsheet? Please kindly try that.

    Thanks

  • Profile Image

    Answered by canerbalci on May 09, 2013 at 07:25 AM

    this bug is fixed.