Payment Form: Get product quantity on separate columns in spreadsheet integration

Hi,

I'm using Square payment widget setup as "products". The problem is that when we download the excel sheet it doesn't give us numbers in columns.

So in example below we have to go in and manually calculate the quantities.

The top line is Adult: 3, 10% off: 1
The next line is Adult: 1, Children: 1

Is there a way to get those values into their own columns so we can easily run the totals?

What we used to do is do it as calculate them as "Donations" in separate fields and get the total w/ a calculated field.  But we needed Coupon Codes and you can't use those with Donations. 

Any thoughts?

Thanks,

Steve

Unfortunately it is not possible to get the product details of a payment field, as it only returns the total amount. If your end goal is to calculate the total amount, you can use the payment field so that you can apply coupon codes, then just add a Form Calculation Widget which will retrieve the total amount on the payment field.

Hi Vanessa,

I see what you did.  Is it possible to but the value form "Quantity" instead of price?

What I'm looking for is the total number of people.

Thanks,

Steve

Hi Steve,

The payment integration only returns an amount, not the quantity of the selected products. Hence, extracting the quantity isn't dynamically possible.

However, a possible workaround is to export the submissions into an Excel file then try using the Text-to-Column tool. Here's a guide for that: https://www.excel-easy.com/examples/text-to-columns.html

This might a bit tedious but might help you achieve the requirement. Here's a quick demo for that: