Can multiple, dependent card, parent-child relationships be displayed on/in a single card?

David Mills_oum9oz

Good afternoon

We are a manufacturing company that uses an ERP system that does not provide direct visibility (easily) from the sales order through to its various levels of production
• There are four production processes that ultimately yield the final product.
    o Production area 1 feeds production area 2.
    o Production area 2 feeds production area 3.
    o Production area 3 feeds production area 4.
    o Production area 4 yields the final products.
• We have assembled 5 different boards
    o Sales Order Board (Final Product) – Board #5
    o Production Board 4
    o Production Board 3
    o Production Board 2
    o Production Board 1
• Immediate parent-child relationships on cards from one board to another board can be established.

I am trying to create a final card structure in board #5 where-in the status of all parent-child relationships are displayed. See illustration below. Can this be done and if so how? If not, do you have other architectural suggestions that would enable downstream visibility?

Thank you.

David

 

 

 

Iain Dooley

@David Mills You could do this with the API. So for example if your production process on each sub-card can be considered finished when all checklists on that card are completed, and each parent card has a checklist of linked sub-cards, then this command will "bubble up" a completion to all parent cards:

https://gist.github.com/iaindooley/21b7cf7f008a7450073df4240d145b6d

You can see how to set up Trellinator here:

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

You could achieve something similar with Butler, but the trouble is that a Butler command can't trigger a Butler command. The way around this would be to do something like install a command on the "bottom level" board that would check an item on the parent card, then set it due in 5 minutes, then have another command on that board that would trigger when a card is due with all checklists completed, and would check the item on its parent card, setting it due in 5 minutes and so on up the chain.

This would work, technically, but would therefore take 25 minutes to bubble up through 5 boards. You would also need to define the board levels at the outset, so for example you couldn't easily just add a 6th board level to cope with some cards having different "layers of production" sub-tasks.