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.
prevent duplicate ordersAsked by stpks on August 20, 2015 at 11:31 PM
I am resubmitting this because it was not solved, and it’s not clear to me whether it will get followup based on my "answer" in the original thread:
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.
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: http://www.jotform.com/help/26-Creating-a-Form-Autoresponder or simply put a message in the thank you page.
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 added routine of 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 user not to press the back button is not a foolproof solution, because it requires the user to remember the advisory at all times... even in the heat of selling.
I understand that the info is resent because it remains in the browser's cache - can that 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.
I have replied to your original thread 30 minutes ago. Please kindly check. Here's the link: https://www.jotform.com/answers/643979#644664