Report isn't showing tickets sold per category with credit card payment

Hi,

I pulled a Jotform report of our ticket sales for the 2019 gala but for any sale that was made by credit card (not check), it doesn't show the quantity of each ticket purchased. It only shows that information in the next column where it says "product" and that's not very easy to read or be able to sort in Excel. Is there a way to resolve this?

I found a number of other problems which I'm including in the attached screenshot that are highlighted in different colors. They are as follows:

Yellow - example of credit card payment with no quantity designations, but then "Products" column has the info on which tickets were bought

Green - example of credit card payment that is identical to "yellow" above, but it has 0 quantities indicated - I don't know why 0 and why not just blank

Blue - example of credit card payment WITH quantities (which is what I wanted) but then the "Products" column is blank... why?

Orange - example of credit card payment WITH quantities AND description in "Products" column - how did this work out in this scenario?

Pink - example of a 0 quantity when it's actually supposed to be a quantity of 1 (but no payment needs to be made because it's a free ticket)

Please advise ASAP as our gala is in 1.5 weeks and we're struggling with getting our ticketing info and guest numbers organized. 

Thank you!

I have checked the form and see that there are separate fields for check and credit card payment. The fields with individual selections are displayed only when check payment is selected. Since the products and quantities are selected within the payment field for credit card payment, they are displaying separately. 

If you want the quantity options to be displayed for all payment methods, you may consider calculating the total of the selected fields by assigning calculation values. The calculated total can be passed to the payment field by choose custom payment instead of Sell products.

In all the other cases mentioned from your spreadsheet, the user might have selected Check payment while filling the form and selected these quantities and then changed to credit card payment. Also, since the credit card payment field is not a required field, the user should be able to submit the form without making any payment which is displaying blank.

To avoid this confusion, please follow the steps below:

1. Make the credit card payment field as a required field.

2. Change the Clear hidden field values setting from the Form settings to 'Clear on being hidden' so that when the user switches the payment method, the previously selected values.

Thanks!

It took me a couple hours to figure out how those functionalities work but it still doesn't explain why my spreadsheet is showing all types of different entries in each column the way I described in my first message with the different highlighted rows. Whether it's payment by credit card or check, either quantities are shown or they're not, and ticket specifications are shown or they're not. Is that all being caused by the calculator form widget being absent? 

And me adding the widget now, will that fix all the entries up until now or only form submissions being made after I add the widget?

Also, if I was testing it correctly, I believe I need to add the widget to each of the quantity fields of the check payment options and then to the credit card quantity field (since it's all one field, not each quantity separate), correct? And with each quantity field in the check option, I'm multiplying it by 1 or by the dollar amount like $50? I'm just trying to properly understand this in terms of how it'll spit out into the spreadsheet. Right now what I'm most desperate for is to total up how many adults are coming, how many children of each category, etc. 

Also, thank you for informing me I can make the credit card field required but it won't be required if someone is paying by check. I didn't realize that before. 

Thanks!

I have checked your form and you're using Stripe Payment Integration. You don't need to use the Form calculation in your form to calculate the total. The integration will automatically calculate the product.

The product column in your excel file/spreadsheet will show the Product Item name,Quantity,amount and total.

However,if you want to assign a different column to the fields then you can my colleagues

method to pass calculation to the payment field.

Guide:https://www.jotform.com/help/275-How-to-Pass-a-Calculation-to-a-Payment-Field

I would recommend duplicating your form and make the changes.

https://www.jotform.com/help/27-How-to-Clone-an-Existing-Form-from-Your-Account

I have created a sample form you may test and duplicate.

With my sample form, I'm using the inventory widget and Form calculation widget to calculate the total.

Sample Form:https://form.jotform.com/90515043464957

Please give it a try and let us know if you have further questions.

I understand that currently the quantities are shown in another column, but it's not in a way that I can add up the total quantities. The quantities are showing as text that would take me hours to tally by moving each ticket quantity to a different column - like for adult tickets, child tickets, staff tickets, etc etc etc.

I understand you're suggesting that I can make a different column for these items using the Form Calculation widget, however now the problem is that the form will calculate for  each quantity "sold" for the "pay by check" but for credit card, there's no way for me to have it calculate for adult tickets, child tickets, etc, separately. It'll just calculate an overall total quantity and I won't know what a quantity of 5 is - 5 adult? 3 adult, 1 child, and 1 table?

I understand the concept of the Inventory widget, and again, I know I can use it for the check payment options. But how do I use it for the credit card option for making payments?

But how do I use it for the credit card option for making payments?

Unfortunately, it is not possible to separate the items from a payment field to separate columns in the excel sheet. Since the payment field is considered as a single field array, the data of the field will be sent to a single column only and required to separate them manually. We are sorry to let you know that there is no workaround at this moment.

Thank you.