- stpksAsked 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.
- JotForm SupportWelvinAnswered 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.
- stpksAnswered 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.
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.
- JotForm SupportWelvinAnswered 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:
Please try it and let us know how it goes.