Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

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

Topic Labels: Automations
163 0
cancel
Showing results for 
Search instead for 
Did you mean: 

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?

0 Replies 0