Convert Delimited List

Viewing 2 reply threads
  • Author
    Posts
  • November 8, 2026 at 12:31 PM #54735

    David Zizza
    Participant

    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!

    November 8, 2026 at 3:24 PM #54736

    Brendan
    Keymaster

    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.
    November 8, 2026 at 3:25 PM #54738

    Brendan
    Keymaster

    Oh, and by doing it this way, you can easily see a count of the number of attendees per group ride.

Viewing 2 reply threads

You must be logged in to reply to this topic.