Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Rollup Orders Placed via Form

Topic Labels: Formulas
735 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

1 Reply 1

Hi @Angie_Belle,

Welcome back to the Airtable Community ! :grinning_face_with_big_eyes:

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