Help

Multiple Records, Sum by Individual

Topic Labels: Base design Data
Solved
Jump to Solution
359 2
cancel
Showing results for 
Search instead for 
Did you mean: 
MarcelMertens
4 - Data Explorer
4 - Data Explorer

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.

MarcelMertens_0-1707131297781.png

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?

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

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!

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

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
4 - Data Explorer
4 - Data Explorer

Awesome!