Inventory widget: list of exact tickets sold

  • Profile Image
    flccim
    Asked on March 27, 2018 at 01:33 PM

    It's a time consuming process to manually count each ticket sold - is there a setting we can add/use for an accurate sell of ticket count?  Sometimes one registrant will register for three individuals.  

    See attached link.

    Please advise. 

  • Profile Image
    aubreybourke
    Answered on March 27, 2018 at 02:32 PM

    You can use the inventory widget:

    https://widgets.jotform.com/widget/inventory

    It will keep a total of available tickets. Each purchase they will update. And your customer can also select multiple tickets to purchase.


    You would need to capture the total tickets in a form calculation widget. Multiply the number of tickets by their price and pass this information on to a payment integration.

    For example:

    How-to-Pass-a-Calculation-to-a-Payment-Field


  • Profile Image
    aubreybourke
    Answered on March 27, 2018 at 02:40 PM

    I have cloned your form and integrated the inventory widget correctly.

    It looks like this:

    1522175927a0k3c.png

    You can view it here:

    https://form.jotform.com/80855396337973


    And if you like it and want to save yourself the time to create it, you can clone this form.

    How-to-Clone-an-Existing-Form-from-a-URL


  • Profile Image
    flccim
    Answered on March 27, 2018 at 02:50 PM

    Thank you.  I'm more interested in seeing what it looks like when I download the pdf or xcel to show me that column so I do not have to manually count tickets or see who bought more then one.   

    We're close ... :)   Thank you.

  • Profile Image
    aubreybourke
    Answered on March 27, 2018 at 03:17 PM

    The PDF looks like this:

    1522178154fknej.png

     

    The Excel file looks like this:

    1522178231uys36.png

    Note that I should have labeled the inventory widget. It shows the number of tickets selected. But you can easily fix that if you wish.

  • Profile Image
    flccim
    Answered on March 27, 2018 at 03:40 PM

    Awesome ... I think, lol.   Column H, No Labels would tell us exactly how many tickets 'sold'?  Yes?

  • Profile Image
    aubreybourke
    Answered on March 27, 2018 at 03:55 PM

    Yes column H is the inventory widget. As I didn't label it on the form it is undefined on the PDF and Excel file. Its very easy to fix, just need to type a label. For example "Quantity".

  • Profile Image
    flccim
    Answered on April 02, 2018 at 06:57 PM

    Can you add the widget to the existing form CCIM Reception and the CCIM Designation Dinner without it messing anything up?   

  • Profile Image
    BDAVID
    Answered on April 02, 2018 at 09:53 PM

    Yes you can add any widget to an existing form, please check this guide: https://www.jotform.com/help/252-How-to-Add-a-Widget-to-Your-Form 

  • Profile Image
    flccim
    Answered on April 03, 2018 at 06:31 AM

    I added the Inventory Widget to an event I closed last night:  see CCIM Social.  I'm guessing b/c the event is closed the xcel spreadsheet cannot give me a total.  Please take a look at the form and the spreadsheet and advise.  Please note, when I download this spreadsheet I have to manually count how many tickets were sold - I do not want to do that. 

    I'm not sure the inventory widget is the correct solution.  I don't want 'how many are left', I want a widget that gives me an immediate accurate number of tickets sold, not just submissions.  

    The event CCIM Designation Dinner needs this widget as well.


    Please advise.

  • Profile Image
    BDAVID
    Answered on April 03, 2018 at 08:56 AM

    Please note that this widget or any widget, will work with new submissions. So, it will not show you any data right now. The Inventory widget should have been added before the event began, so you could have applied a formula to sum up the total in Excel: https://support.office.com/en-us/article/summing-up-ways-to-add-and-count-excel-data-d3f918a1-0151-403e-881f-a92f3176f8ea 

    Unfortunately, a manual count would be the only way to count the already sold tickets.

  • Profile Image
    flccim
    Answered on April 03, 2018 at 10:20 AM

    Ok, at least it is an option moving forward. To confirm, the CCIM Designation Dinner form I have active right now cannot add this widget and it would work to count the registrations, correct?


  • Profile Image
    BDAVID
    Answered on April 03, 2018 at 11:40 AM

    Correct, you  will need to remove the product from your payment field, and set it up within the Inventory widget, and you will need to perform the calculation in order to pass the total to be paid to your payment field.

    The Inventory widget will show the quantity that was selected(same as my colleague example), so you can apply Excel SUM function to sum up all the quantities for that column to get the total.