I have a base to manage volunteers and volunteer events. There's a Volunteers table to store volunteer information (name, email, phone, etc.). There's an Events table with details about volunteer events. There's a table called Volunteer Signups that shows which volunteers are signed up for which events.
I use a form to register new or returning volunteers. The form fills in the details on the Volunteer Signups table. An automation then creates a new record in the Volunteers table if the volunteer's email is not in the system yet. If the email is in the system, a new Volunteers record is not created.
Returning volunteers will then have multiple events listed on the Volunteer Signups table, one for each event they have signed up for over time. I want to have a linked record in the Volunteers table that shows only the most recent event they have signed up for. Right now I'm only able to show the first event they signed up for, not any subsequent events. What do I need to change to achieve this?
