I need help with an automation between two boards.
The simple automation would be -
If date changes in board 2 then change date in board 1
The fields in the rows on both boards are different and in different orders but what they both share is each entry will have an “organisation” field on it.
I don’t know the recipe for it, but I bascially want the automation to also look for a common field on both boards - the Organisation. I want the recipe to do something like this:
If date changes in board 2, then copy the oganisation field from that row and then update the date in any rows in board 1 which have the same organisation field
i.e. the common denominator between the two boards is the organisation field but I can’t work out how to tell Monday to match that and then just update any rows containing that organisation name.
Is this sort of automation possible?