- flccimAsked 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.Page URL:
- JotForm SupportaubreybourkeAnswered on March 27, 2018 at 02:32 PM
You can use the inventory widget:
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.
- JotForm SupportaubreybourkeAnswered on March 27, 2018 at 02:40 PM
- flccimAnswered 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.
- JotForm SupportaubreybourkeAnswered on March 27, 2018 at 03:17 PM
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.
- flccimAnswered 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?
- JotForm SupportaubreybourkeAnswered 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".
- flccimAnswered 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?
- JotForm SupportBDAVIDAnswered 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
- flccimAnswered 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.
- JotForm SupportBDAVIDAnswered 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.
- flccimAnswered 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?
- JotForm SupportBDAVIDAnswered 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.