How to count tickets instead of submissions

  • APuttroff
    Asked on June 8, 2020 at 2:02 PM

    Hello,

    We are using JotForm to sell tickets for events. We are running into a problem where we end up overselling tickets. Is there a way to change the disable setting from disabling for the number of submissions to disable for the number of tickets sold. 

    Right now someone can buy 3 tickets but because one person bought 3 tickets under 1 submission it is only counting 1. 

    Please help. 

     

  • jonathan
    Replied on June 8, 2020 at 6:13 PM

    We apologize for inconvenience. Currently there is no direct way to get the quantity of items/products separately from the payment field.

    All the payment details were presented on a single field/element (the payment field).

    A workaround you can do is to add another field (you can hide it on the form), and use it as the Quantity container for the quantity of tickets sold.

    Example in your form, you can extract the actual quantity sold if you will divide the total amount by the price(since total = price * qty). 

    1591654264zzz 2020 06 09 06 Screenshot 10


    1591654293zzz 2020 06 09 06 Screenshot 21


    Example output:

    1591654323zzz 2020 06 09 06 Screenshot 32


    You can check it also on my test form https://form.jotform.com/201596553582967

    Using this workaround, you will be able to get a separate field data for the "Quantity".

    I hope this help. Let us know if you need further assistance.



  • APuttroff
    Replied on June 9, 2020 at 1:25 PM

    This doesn't really solve the issue. It looks like what you provided will just count how many are sold. What I need is for a setting that will disable the form when a certain amount of tickets are sold. 

  • David JotForm Support Manager
    Replied on June 9, 2020 at 5:20 PM

    That would not be possible, however, another option you could try is using the Inventory widget, where you can define the amount of tickets you will sell, calculate the total through a Form Calculation widget(which you can hide), and pass the total to your PayPal payment field.

    1591737380total Screenshot 10

    Result: https://form.jotform.com/201606163773958

    1591737488result Screenshot 21

    Note: to add a widget to your form, please follow this guide.

    So, when there is no remaining quantity, users won't be able to purchase a ticket.

    Let us know if you need more help.