Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Multiple Records, Sum by Individual

Topic Labels: Base design Data
Solved
Jump to Solution
730 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!