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.
Inventory widget: prevent two submissions at the same timeAsked by Alen_Lin on March 25, 2016 at 05:06 AM
I have created an order form Inventory Widget to manager the available quantity, but I found a logic problem.
The available quantity 2 less.
userA and userB login the form and same time to fill-in the form
The available quantity 2 less display both userA and userB screen, then userA and userB can submit the order form without any error.
From backend report I got extra order, it's possible real-time double check the actual available quantity and display warning message before submit the order from ?
Thank you for contacting us. Can you also try it with the Appointment slots widget instead of the Inventory Widget? At that time, it will work properly. However, you need to space out between number and curly brace as you see below.
Please, test it on your side and let us know the result.
Thanks for your prompt response, I have do the testing in my form, but the Appointment slots widget can't meet my requirement.
The Inventory widget can fully meet my requirement but have some problem link my previous mention.
In my thinking is possible to design an function when user select or type quantity of the Inventory widget can real-time query the backend DB again to get the actual available quantity?
Thank you for your response. I will escalate it to our developers. We will update you via this thread as soon as possible when we solve the problem.
Have any update from your developers ?
Unfortunately, the issue's status is still on progress at the moment, so we need to wait a little longer to get a fix. However, you can be sure that it will be handled as soon as possible. As it is mentioned, you will be informed from this thread through email.
Thank you for your patience.
Within half a second, we are now able to detect two submissions being made at the same time.
This should be prevent an overcount/oversell of your inventory.
Please check - and share your feedback.