I'm getting duplicate orders from my order form

  • Profile Image
    stpks
    Asked 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!

     

     

  • Profile Image
    Welvin
    Answered 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
    stpks
    Answered 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
    Welvin
    Answered 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