Multiple Records, Sum by Individual

[MarcelMertens]

Hi Everyone,

i am new to Airtable and try to build a small solution for our cycling club. We like to keep track of group rides, so i have three tables:

• Members (List of all Members)
• Routes with the fields:
  
  • Name
  • Distance
• Records with the fields:
  
  • Member (multiple records, from Members table)
  • Route (from Routes table)
  • Date

I have a form there a member can create a records and add a records for a group ride on a date and can select multiple members who joined the ride. A member can do the same route on multiple days.

Now id like to create a view which shows a member list with the sum of the distance of the routes.

Expected output:

• Marianne Westhoff, Distance 40
• Marcel Mertens, Distance 30
• Daniela Feuersträter, Distance 30
• Max Wievel, Distance 20
• Werner Heldt: Distance 20

How can i do this?

[TheTimeSavingCo · Accepted solution]

In your "Members" table, create a rollup field that'll take the value from the "Distance" lookup field, and use the formula 'SUM(values)'.  Should do what you need!

[MarcelMertens]

Awesome!