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.
What should RecordID be in this case? Big thanks.
Hmm, given that you only have one record in
AcademyTriggerEvent, if I were you I’d:
AcademyTriggerEventcreate a new formula field called “Record ID” or some such, and give it the formula
Update Recordaction, paste the value of the “Record ID” field from the previous point
I think this should work!
After you create a new formula field called “Record ID” with the formula
AcademyTriggerEvent, it should look something like this:
From there, you’d copy the value in the “Record ID” field and paste it into the
Record ID field of the automation:
Does that make sense?