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

    I'm getting duplicate orders from my order form

    Asked by stpks on August 20, 2015 at 12:47 PM

    I'm getting duplicate orders.

    See link below to Google sheet integration.

    The form URL: jotformpro.com/stpks/hapng

    In cols d & e on the 16th and again the 18th of August we have TAL & ENGLISH

    It seems that reloading the browser page with the Thank You displayed resends the order with a different submission ID.

    Unfortunately, as a result we produced the same personalized item twice.

    Help!

     

     

    Page URL:
    https://docs.google.com/spreadsheets/d/1cxaw9SNvtCCC3m74YWisF3rlYf_l4u<br/>5UaDAA-PkUq-E/edit#gid=1185270721

    using jotform duplicate orders
  • Profile Image
    JotForm Support

    Answered by Welvin on August 20, 2015 at 04:44 PM

    No, reloading the thank you page should give the submitter an error and that shouldn't re-submit the data. They should receive this error page:

    But when your customer clicks the back button and re-submit the form, that will create a duplicate order. You should advise them not to do so. You can create an autoresponder email: https://www.jotform.com/help/26-Creating-a-Form-Autoresponder or simply put a message in the thank you page.

    Thanks

  • Profile Image

    Answered by stpks on August 20, 2015 at 11:25 PM

    i understand your answer, but it does not solve our problem.

    The agent in the field is using a smartphone to take orders and we cannot rely on the practice or checking emails after each order and before the next order. Only a warning in real time would -possibly - achieve results. Furthermore, the autoreply only informs that an order has been recorded, but does not catch duplicates: it neither informs of them, nor flags or prevents them

    Advising the customer is not a foolproof solution, because it requires the user to remember the advisory at all times, even in the heat of selling.

    Please help.

    I understand that the info is resent because it remains in the browser's cache - can it be flushed clean when the thank you page is displayed?

    Can I be informed in one of the reports or integrations that two submissions are identical except for the unique submission ID?

    This needs more thought and more work. Please help.

  • Profile Image
    JotForm Support

    Answered by Welvin on August 21, 2015 at 03:52 AM

    So, are you saying that the problem of getting duplicates still happens in the form? 

    For putting an advise in the form:

    I'm sorry about the suggestion, but I meant to say to add a note in the form so your agents can read it before submitting.

     

    Clearing session data, cache:

    I'm sorry, but that is a browser thing that remembers the data in the form fields. When going back, they can see the old data and can re-submit it anytime.

     

    Notification for duplicates:

    I'm sorry, but I don't think getting a notification for duplicates is possible. 

     

    I think the solution here would be to setup a limit based on a unique question in the form. Maybe point it to the Invoice Number? Or to any that is unique for each submission. Here's our guide for that:

    http://www.jotform.com/help/223-How-to-set-Form-Limits-Based-on-a-Unique-Question

    Please try it and let us know how it goes.

    Thanks