What RecordID do I use in my Update Automation - getting "record does not exist"

[Alun_Parry]

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.

[TheTimeSavingCo]

Hmm, given that you only have one record in AcademyTriggerEvent, if I were you I’d:

1. In AcademyTriggerEvent create a new formula field called “Record ID” or some such, and give it the formula RECORD_ID()
2. In your automation, in the Update Record action, paste the value of the “Record ID” field from the previous point

I think this should work!

[Alun_Parry]

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?

[Alun_Parry]

Also, when it says *Record ID id of the record to update - what is the value that goes in that part? Thanks

[Alun_Parry]

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.”

[TheTimeSavingCo]

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?