Aha! So I’m making some progress. I think I’m one step off making something work in Airtable.
So I have two tables: AcademyEventsList and AcademyTriggerEvent.
In the AcademyEventsList table is a list of all my online classes with students. The fields are: UserID (an automated number), Event Date (a date and time), Event Name (text field), DaysToGo (a formula that calculates how long between the event date and now), Hours To Go (same but hours)
In the AcademyTriggerEvent table is just one record. Here are the fields: TriggerID which is just a number, TriggerEventDate (date and time), TriggerEventName (text).
My automation intention is that: When DaysToGo= 5 ->the record in AcademyTriggerEvents is updated with the EventName and EventDate from the record in AcademyEvents that has 5 days to go.
I’m almost there but I’m stuck on what the Record ID should be.
I’m getting the error message “The record does not exist” when I test it. I can see that the Fields are bringing in the right information, so I suspect its the RecordID part that I’m messing up.