- abbyreidAsked on May 03, 2016 at 02:03 PM
I added 3 options
adult, sibling, member- when i pull it into a spreadsheet that is all in 1 column, i need to be able to tally how many were purchased in each categoryPage URL:
- KadeJMAnswered on May 03, 2016 at 03:41 PM
To my understanding you are looking for a better method of being able to sort of tally or count how many of each of your products was purchased for those catagories since you don't like how it is only shown in one column on the exported spreadsheet, correct?
I had one idea called JotPayments but it looks like it is no longer working properly after testing it so please allow me to explore other options for you to assist you better and I'll update you as soon as I know something more.
- KadeJMAnswered on May 03, 2016 at 04:01 PM
I thought of something that may help you with the tally problem.
Instead of using the standard excel spreadsheet I would suggest integrating your form google spreadsheets which does contain the majority of the product information.
You could then use spreadsheet formulas to get that data and tally it for you.
- abbyreidAnswered on May 04, 2016 at 01:15 PM
I did the integration- I actually tested it on the original form first, then when it didn't work, tested it on a different form- it still is not working with this particular form- it still just shows all the orders in one box for each user (2 adults, 1 child) all in one box, instead of 2 separate boxes (one for adult and one for child)
on the other form it does show what i need it to in google spreadsheets, but that one does not have a paypal associated with it. It seems that the paypal application is what messes this up.
I really need this to be able to separate the data for this to be usable for me
- HubersonAnswered on May 04, 2016 at 02:16 PM
This is because the payment block is considered as a single field. The dropdowns, textboxes or checkboxes you add are just options inside the payment field.
If you want each options in its separate column in the spreadsheet what you can do is, create those fields outside the PayPal field and use a calculation field to get the total, then pass the value of that field to PayPal field - How-to-pass-a-calculation-to-a-payment-field.
You will have the Payment working the same as before, and each option in individual column in the spreadsheet.