I want to generate and average number of attenders on my Mountain Biking DB. Right now, I have a delimited list of attenders created from a pick list. I want to count those for each ride, then derive an average from the total number of rides. Any thoughts on how to do this? Thanks!
Hi David,
I’m a mountain biker too! I usually ride in the foothills of the Canadian Rocky Mountains near Calgary. I’m also a ride leader for a group called The Shred Collective. So much fun!
Instead of a delimited list of attendees, I would suggest perhaps a Table field or a Link to Form field that lets you select from a list of attendees that way. With a Link to Form field, you could even have a two-way relationship so you could see a specific group ride and the list of riders who attended, plus for any specific rider, you could see a list of rides they had previously joined. You’d need a Many to Many relationship for that.
Attached is a photo of me and my new Orbea Wild LT mountain bike :) I’ve had it for just about 2 months now.
Thanks!
Brendan
Attachments:
You must be
logged in to view attached files.
Oh, and by doing it this way, you can easily see a count of the number of attendees per group ride.