Hi,
This is my scenario:
I have three boards (new, current, archive).
when an item is created in the board NEW an automation is activated to connect (two ways connection) the item with an item with the same NAME on the board CURRENT. this woks fine.
On the board CURRENT there is an automation that suppose to be activated by column change and move the item to the board ARCHIVE.
It does not get activated by the change that happens with the automation. If I manually connect the fields it work’ but not when the change happens by automation.
Is there any work around?
By the way, with other columns it works even if the change happens with automations, but not with the connect boards column.
What you’re experiencing is normal, with two-way connections the “passive” change (where as the one on NEW is active, the one on CURRENT is a side-effect of the two-way link) does not trigger events. This also crops up when a connected item is deleted and removed, no change is triggered on the boards linking to the item.
There is a workaround though.
On the NEW board where the automation triggers that connect the item, add a status column call it something like “Item Connected”.
On the NEW board, create an automation to set this new status to “Connected” when connect board changes.
On the CURRENT board, create a mirror of the “Item Connected” column from NEW.
On the CURRENT board create another status column, called “Move Trigger”
On the CURRENT board, use the pre-made “When Item Connected (Status Mirror) changes to Connected, change Move Trigger to Move” (from the Categories => Status Change group of recipes on the left of the automations center, not the “create custom automation” or “add new automation” buttons). This is one of the few magical recipes that you can select a mirror status column as the trigger, and use item connected to change the move trigger status. This step is the key to the whole thing working.
On CURRENT create a “When Move Trigger changes to Move, move item to ARCHIVE” recipe.
I know it adds a couple automations to the mix but by using the not well publicized ability to trigger a few pre-built recipes from mirrors of status columns changing, you can convey the effect to the other which is normally not conveyed.
There is a possible shortcut where instead of changing the Connected status column when the connect board column changes, you use an item default value to set Connected. But I believe this is prone to sometimes happening before the link to the item on CURRENT is created, and won’t always be reliable to trigger on through the mirror on CURRENT.
