Automating an Entry of a Specific Linked Record in an Entry with Multiple Linked Records?

Trying to see if I can set something up as follows with automations:

I schedule people into events. They may be scheduled into multiple events over the course of say a year.

So I have Person A, who has a linked field to the scheduling calendar, and she is scheduled for events: X -1/1/21, Y - 2/2/21, and Z - 3-3-21.

What I am trying to do is have a check in field with the options of “Checked In” or “No Show” that I could use day-of (and that would clear itself out after a day). So on 3-3-21, if Person A does not show up, I could mark their status as “No Show” and this would updated a second linked field (linked to the same tab as the entry for the event itself), called No Show, with the Z - 3-3-21 record.

What I am having an issue with is being able to update only the most recent record and not having this automation assume that Person A is a no show to all three events. Is this possible? Any ideas on how I would achieve it?