JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
i did the paypal form- how do i aggregate what i sold?Asked by abbyreid 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 category
paypal form how how do i tally 3 all member
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.
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.
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
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.