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

    Edited submissions duplicated in database

    Asked by ResAdmin on June 24, 2011 at 12:29 AM

    Good evening,

    I have an extensive form that clients can return to and edit at their convenience. This has worked very well until today. We noticed today that one of our clients submissions was entered as a new entry in the database everytime he submitted his changes or additions to the form. Historically, any changes or additions were added to the original submission. I noticed that the IDs were different for each duplicated submission. I tried to duplicate this issue but was unsuccessful. Any ideas on where to start looking for the cause of this problem?

    Further review shows that email notifications recieved when this specific client edits his form all say 'new submission from'. Email notifications from all other clients follow this pattern - new submission from; EDIT: New submission from.

     

    Resadmin

  • Profile Image
    JotForm Support

    Answered by NeilVicente on June 25, 2011 at 01:34 AM

    Hi,

    May I ask how your clients edit their submitted entries? I noticed your autoresponder mail for the form 'Client Questionnaire' does not contain anything. For your information, the only way for users to edit their submission is using the edit link that is inserted in Autoresponders. Since your autoresponder is blank, I am wondering as to the method you are using to enable your clients to edit the submission.

    If you are indeed using edit links, it is impossible that a new submission is added when the user supposedly 'edits' the original entry. The only way it can happen is if the edit link was modified. An incorrect edit link clears the information saved in the loaded form (not in the original entry), treating the form as a new entry.


    Neil

  • Profile Image

    Answered by ResAdmin on June 25, 2011 at 09:04 AM

    Hmm, not sure what happened to my autoresponder.

    The original autoresponder included the {edit_link} field so clients can return to the form later. I have recreated the autoresponder that is sent to clients.

    This email we received from our client is below. We corrected the conditions issue with our form that he refers to first. The important bit of information is where the client says the other information he entered does appear each time he accesses the form. Clearly, he was able to see most of the information he already submitted. I was unable to add a screenshot of the submissions page with the IDs revealed. I can email it to you if necessary. This client edited the form several times within a span of a couple of hours. Each edit is treated as a new submission and has a slightly different ID code.

    This has never occured before or after this specific client. Is it possible that the system treated each 'edit' as a new submission and sent a new autoresponder email with a different ID after each submission?

     

    ----------

    I started the questionnaire this evening.  I wonder if I'm having troubles with one of the sections.  I've entered two items under the 'Professional Development' category.  When I save and return, the information that I entered seems to have vanished.  I'm brainstorming these items now and I'd like to return at a later time to tweak them.  Everything that I entered before this section does appear again like it should.  Am I doing something wrong?

    -----------

     

  • Profile Image
    JotForm Support

    Answered by NeilVicente on June 27, 2011 at 11:41 PM

    Hi,

    There is no need to attach a screenshot of the submissions page. We do have access to stuff like that.

    Anyway, I realized just now that you mentioned in your original post that the notifications you have received from that particular client's submission 'edits' have a subject line of "New Submission:..." instead of "EDIT: New Submission...".

    You have also said that you failed to resplicate the issue. I did try replicating the issue myself but couldn't make it happen. For all we know, the client might have made multiple submits and not multiple edits, hence the new entries appearing in your submissions page.

    I believe there used to be a bug many months about submission edits appearing as new entries, however, it has long been fixed as far as I know.

    If you are worried about your clients making multiple submits in your form, you can configure the form to accept only unique submissions. Click here to learn how to implement this in your form.


    Neil

  • Profile Image

    Answered by ResAdmin on August 16, 2011 at 05:26 PM

    Good afternoon,

    This same issue has occurred again. A client edited a form several times and each edit is entered as a new submission. The auto responder emails I have received all say New Submission rather than following New Submission and the EDIT: New Submission... It is clear when looking at each submission in order that more information has been added to the form.

    Try as I might, I have been unable to duplicate this issue. Any edits I make to a test submission are added to the original submission entry.

    I emailed the client and asked a few questions while trying to duplicate this issue. I believe that the client is receiving a new auto responder email with a new link (and id) after every submission. As far as I can tell, this is not how it is supposed to work. I will ask him to forward the emails to me.

    In what scenario would the system send a new auto responder email with a new ID when editing an already submitted form.

    The client is using Yahoo email and Internet Explorer.

  • Profile Image

    Answered by ResAdmin on August 16, 2011 at 11:50 PM

    I have successfully duplicated this problem using Internet Explorer. When using IE, every submit causes a new auto responder email to be sent. When using Firefox, edits are added to a previously entered submission.

  • Profile Image
    JotForm Support

    Answered by NeilVicente on August 17, 2011 at 09:38 PM

    Hi,

    Thank you for this information. While using a different browser will avoid this complication, I believe this still needs some attention from our developers. With that in mind, I submitted a ticket to report this problem. We will see what our developers can do about it.

    To be honest though, I'd advise each and every JotForm user to ditch IE and get a better browser such as Chrome, Firefox, or Safari. Of course, that's just my opinion :)

    Anyway, we thank you for your valuable input to the community. Feel free to contact us again for any other issues you encounter while using your forms.


    Regards,
    Neil

  • Profile Image

    Answered by ResAdmin on August 17, 2011 at 11:05 PM

    Completely agree about ditching IE:-) Do you have any idea when this might be corrected or if a work around exists? I am currently testing this form and can't go public with it until this problem is solved.

  • Profile Image
    JotForm Support

    Answered by NeilVicente on August 18, 2011 at 12:31 AM

    Hi,

    Sadly, the only workaround I know of is to use a different browser. We do not have any idea as to when this will be fixed since us support members are not privy to what our developers' priorities are.

    If using Firefox or Chrome works perfectly for you as it did for me, I think it's safe to go public now.

    We will let you know once a fix has been applied. Thank you for your patience on this matter.


    Neil

  • Profile Image

    Answered by ResAdmin on August 18, 2011 at 09:15 AM

    Thank you for working on solving the problem. Unfortunately, I can't go public with my form because I can't dictate what browser my clients will use. The multiple auto responder emails clients are recieving after they edit the form are confusing. If the clients fail to click on the most recent auto responder email, the most recent information entered into the form is missing which causes further confusion...

    Yes I can recommend Firefox - most clients won't download a new browser or will be annoyed that they have too.

    Yes I can tell them to only click on the most recent email with a link back to the form - doesn't look very professional.

    Hope you can solve this soon!

  • Profile Image
    JotForm Support

    Answered by NeilVicente on August 18, 2011 at 07:15 PM

    Hi,

    Honestly speaking, I wasn't able to replicate your problem with IE because I couldn't get it to display my submissions page (more reason to hate IE, right? LOL). However, I was able to test edit links under that browser and found no issues whatsoever.

    With that in mind, I don't think your users would need to use a browser other than IE since edit links do not add new submissions, at least on my end. Would you care to test again using IE to confirm if editing a submission through an edit link works without any problem?

    I'll await your results. Thanks!


    Neil

  • Profile Image

    Answered by ResAdmin on August 21, 2011 at 02:00 PM

    Editing a submission on my Client Questionnaire form with IE is treated as a new submission. After every edit, I receive a new autoresponder with a different SID when using IE. This does not occur with Firefox and I have not tested Chrome or other browsers. When the Client Questionnaire form is edited with Firefox, I do not receive a new autoresponder email and all edits are added to the original submission.

    I created a new Test Form to try and duplicate this problem. However, the above problem does not occur when using IE on the new Test Form. All edits, regardless of what web browser is used adds new info to the original submission.

    So, maybe this is a problem specific to the Client Questionnaire form. Any suggestions on what I can try to fix this?

  • Profile Image
    JotForm Founder

    Answered by aytekin on August 25, 2011 at 07:12 AM

    Can you use a different browser for now? We opened a bug report for this one.

  • Profile Image

    Answered by emrew86 on October 19, 2011 at 08:00 AM

    Hi ResAdmin, are you still having this problem ?

  • Profile Image

    Answered by dwkeh on August 30, 2012 at 01:27 PM

    I have replicated this exact problem. I am on Firefox (no issues) and my clients on IE (and their IT is locked down for secuity so a different browser is not an option. I have tested IE too and duplication occurs every time. A year has passed since the last post on this thread so I would be interested to know if cause/solutiom has been found. Many thanks,