I’m having people place orders for a sale online. I’d like to have a rollup form of their totals, since the only tidy way to submit orders is one item per submission, so there will be several lines. The buyer is submitting their e-mail with each order submitted: firstname.lastname@example.org 1 shirt $10 email@example.com 2 shoes $25 firstname.lastname@example.org 10 chairs $7 email@example.com 2 shirts $18
I’d like to be able to somehow summarize the total amount per e-mail address. I can figure out how to do it if I were inputting the e-mail addresses ahead of time, but not when they’re coming in from a form.