Hello!
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!