How to automate the connections between two cards?

Patrick Eissler

Hi atlassian-forum,

Situation: 

• One Board that includes all products
• Another Board that includes all suppliers
• Each product has several suppliers and each supplier supplies several products

Goal: 

• Link each product to its respective suppliers
• Link each supplier to its respective products

Problem: 

• How can you do this in an automated way such that only on the cards of the product board the supplier cards of the supplier board are attached manually and then the product cards are automatically attached to the supplier that was attached to that product.
• This saves time and is more flexible to future changes (deleting or adding a supplier to a product should be considered on the respective supplier cards as well)

My qestion: Is there any add-on that solves that problem? I checked 1 or two mirroring apps and tried to build a butler rule, but it didnt work out so far. 

I am thankful for any help

Regards,
Patrick

Iain Dooley

@Patrick Eissler You won't be able to do this with Butler, but here's a Trellinator function that would do what you're after:

https://gist.github.com/iaindooley/0e810a4625865d9f13b86878a8641b42

The Trellinator user would need to be a member of both boards, and you'd install the above function on the Products board. When you add an item to a checklist named "Suppliers", it will find a card containing that name on the Suppliers board, replace the checklist item text with a link to that supplier card, then add a link to the Product card into a "Products" checklist on the supplier card (unless it already exists).

You can read more about Trellinator here:

https://community.atlassian.com/t5/Marketplace-Apps-Integrations/Introducing-Trellinator-Automate-Trello-with-Google-Apps-Script/ba-p/925271