Update field based on single select update

[Jane_Zurbrugg]

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!

[Rachel_Braedyn]

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

[Alexey_Gusev]

Jane_Zurbrugg:

updates a single select field based on the input in another table of the same base.

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