Rollup Orders Placed via Form

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:
person1@email.com 1 shirt $10
person1@email.com 2 shoes $25
person1@email.com 10 chairs $7
person2@gmail.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.

Hi @Angie_Belle,

Welcome back to the Airtable Community ! :smiley:

Ok so, there are 2 ways to do this, either manually or via script.

  1. Manually:

You will copy the email addresses to a new field in the same table. This field should be a Link To Another Record (create new table). In the new table you can use Rollup Fields.

In this option, you will have to copy paste each option in the Linked Field.

  1. Via Script:

Check out this Topic. It explains how you can do that.

BR,
Mo