Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Nov 17, 2022 01:22 AM
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.
Nov 17, 2022 01:52 AM
Hmm, given that you only have one record in AcademyTriggerEvent
, if I were you I’d:
AcademyTriggerEvent
create a new formula field called “Record ID” or some such, and give it the formula RECORD_ID()
Update Record
action, paste the value of the “Record ID” field from the previous pointI think this should work!
Nov 17, 2022 02:21 AM
Thanks. When you say paste the value of the “Record ID” field from the previous point, do you mean “Airtable record ID” that shows in the pulldown?
Nov 17, 2022 02:23 AM
Also, when it says *Record ID id of the record to update - what is the value that goes in that part? Thanks
Nov 17, 2022 02:25 AM
This is how I’ve interpreted it so far. It wouldn’t let me do “+ choose field” and add the the Record Id as it is a computed field.
On testing it gives the error “record does not exist.”
Nov 17, 2022 03:12 AM
After you create a new formula field called “Record ID” with the formula RECORD_ID()
in 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?