Conditional updating of a single select field in another table (not base)


I am trying to create an automation that updates a single select field based on the input in another table of the same base.

I tried the “when a record matches condition” automation but it didn’t work as it only lets me update records from the same table. I thought that maybe it would work with a script but as I don’t know how to code I’m having a hard time.

Any help is highly appreciated!

1 Like