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

    Inventory widget: prevent two submissions at the same time

    Asked by Alen_Lin on March 25, 2016 at 05:06 AM

    Hi Sir,

    I have created an order form Inventory Widget to manager the available quantity, but I found a logic problem.

    example:

    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 ?

    Page URL:
    https://form.jotform.me/60834972293464

    Screenshot
    quantity check how order form problem style size
  • Profile Image
    JotForm Support

    Answered by beril on March 25, 2016 at 06:10 AM

    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.

  • Profile Image

    Answered by Alen_Lin on March 25, 2016 at 07:08 AM

    Hi Beril,

    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?

    Thanks.

     

  • Profile Image
    JotForm Support

    Answered by beril on March 25, 2016 at 09:28 AM

    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.

     

  • Profile Image

    Answered by F5Alen on March 30, 2016 at 03:59 AM

    Hi Beril

    Have any update from your developers ?

     

    Thanks

  • Profile Image
    JotForm Support

    Answered by mert on March 30, 2016 at 04:30 AM

    Hi @F5Alen,

    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.

  • Profile Image
    JotForm Support

    Answered by TitusNdoka on September 22, 2016 at 06:32 AM

    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. 

    Thanks!