I am looking to pseudo-automate a stand-up/status message from about 25-30 people on a team. My plan is to schedule a slack automated message weekly at a certain time that links out to an airtable form. The form is linked to a status collection table that would collect these over time. The person would select their name from a drop down, a general status (choice of 4, linked to single select in table), the projects they’re working on (linked to a projects table), and a few notes fields. Ideally I want to show the latest update from a person.
We’d then have another view of this data, filtered to show the updated entries. Currently I’m doing this by using Date of Entry > last seven days.
However - the question I have - is there a way to instead simple show the latest record by person? For example currently if a person fills this form out 3 times in a week, the view will show all three records. But I only want the last update from a person.