AirTable - Update Record

I am trying to figure out how to find a record ID using shortcuts of a specific table based using the email field as search criteria. I will then use this ID to update another field belonging to this ID.

I know there is the ROutineHub workflow but it is too complicated. I want to figure out how to do the basics steps.

Edit: I’ve been able to figure the steps myself. It looks like I am on the right track. The key is to use Filter By Formula. Here is what it looks like:

I figured out how to get the record id and then patch it with an update.

1 Like