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

  • Profile Image
    EastEndSeaportMuseum
    Asked on July 30, 2019 at 11:03 AM

    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.

    1564498489Screen Shot 2019-07-30 at 10.5

    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




  • Profile Image
    Vanessa_T
    Answered on July 30, 2019 at 11:44 AM

    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.

    15645014381.gif

  • Profile Image
    EastEndSeaportMuseum
    Answered on July 30, 2019 at 12:55 PM

    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



  • Profile Image
    JohnRex
    Answered on July 30, 2019 at 02:05 PM

    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:

    1564509882texttocolumn.gif