Hello! I am creating a field for event attendees. I have each attendee's name, the events they attended, and the dates of the events they attended separated into 3 columns. I would like to make a fourth column that retrieves the most recent date each attendee came to an event.
In this scenario, I want to make a fourth column that will automatically register that 1/8/24 is the most recent date and it will return that. Please let me know if you can help.
Given the way you've structured your base you probably will need a script to help you do this
I recommend that you create a new table called "Event attendance" instead where each record represents a single person's attendance at a single event. The fields in that table would be:
1. Event name
2. Event date
3. Linked field to a table where each record represents a single person
Once you've set your base up like that you can then use a rollup field on the 'Event date' field with the formula `MAX(values)` to get the most recent date
Given the way you've structured your base you probably will need a script to help you do this
I recommend that you create a new table called "Event attendance" instead where each record represents a single person's attendance at a single event. The fields in that table would be:
1. Event name
2. Event date
3. Linked field to a table where each record represents a single person
Once you've set your base up like that you can then use a rollup field on the 'Event date' field with the formula `MAX(values)` to get the most recent date
Thank you @TheTimeSavingCo
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.