- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 05, 2024 03:04 AM - edited ‎Feb 05, 2024 03:09 AM
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?
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 05, 2024 03:25 AM
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!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 05, 2024 03:25 AM
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!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 05, 2024 03:44 AM
Awesome!
