How to count tickets instead of submissions

  • Profile Image
    APuttroff
    Asked on June 08, 2020 at 02: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. 

     

  • Profile Image
    jonathan
    Answered on June 08, 2020 at 06: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.04.12.png


    1591654293zzz 2020-06-09 06.03.31.png


    Example output:

    1591654323zzz 2020-06-09 06.05.41.png


    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.



  • Profile Image
    APuttroff
    Answered on June 09, 2020 at 01: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. 

  • Profile Image
    BDAVID
    Answered on June 09, 2020 at 05: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.png

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

    1591737488result.gif

    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.