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

Did you find an answer to this? I’m trying to work out the same thing.

I think it’s not so hard, but it depends on ‘based’ and ‘update field’