Multiple Lines in Google Spreadsheet

  • Profile Image
    Asked on October 01, 2012 at 04:53 PM

    I have set up our form, and it works! It sends emails confirming each submission to the email addresses I gave it, and posts the submission in the Google Spreadsheet your fine program created for me.

    However, We have just had our first "live" real person fill out our form, and there is one problem. It actually added four identical, complete lines to the Google Spreadsheet, each one containing the identical data, right down to the time of submission identical to the second. 

    So it doesn't look like our first user input the data four times, or hit submit four times. It looks like maybe jotform added a line to the Google spreadsheet several times...wonder why? Is it possible that it is adding a line for the return email and for each of the three email addresses?

    It's working so great and you guys have been so much help, I'm sure you can handle this one, too!


    Al Peabody

  • Profile Image
    Answered on October 01, 2012 at 07:35 PM


    If you check your form's submissions page, you will find out that the user actually submitted the form for five times in a row. It is probably caused by slow/intermittent internet connection.

    The user must have thought that the form isn't responding, and repeatedly pressed the submit button.

    By the way, your test submissions are live submissions as well. How the form works when you do a submission to your own form is how it should work for others.