Inventory widget: list of exact tickets sold

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. 

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

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

It looks like this:

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

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.

The PDF looks like this:

The Excel file looks like this:

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.

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

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".

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

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 

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.

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.

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?

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.