Automating Due Date on a Linked Card

Question

Hello,

We are managing wedding week-end with always the same things to do before, for each week-end, but of course with different dates.

I would like to create a board with always the same lists of cards corresponding to each wedding week-end we organise.

The only thing that must change for each of those cards is the start dates or end dates or due dates which must depend on the start date and end date of the first card (mother card) of the list.

How can I connect each of the cards in each list (a list correspond to a wedding week-end) to each other so that when I enter the dates in the mother card, all the other cards are updated?

Many thanks

milynnus · Accepted Answer

Hi, the way I had seen this done was to automate from a spreadsheet that use the due date to compute all the due dates of the upstream task cards and then create cards from it. The project focus was on Unito to create a flow to a master board. I hope this helps.

Mike - Dreamsuite Consulting · Accepted Answer

This can be done using Trello automation but it is a little advanced there are several steps...

1) You have to collect all of your cards together on the Mother Card, using this automation  button as an example

Note, this automation is to initialise your board and can be discarded after

Collect all cards not containing name "{triggercardname} into checklist "Child Cards"

2) Next, an automation that will add new child cards to the Mother Card

When a card is added to the board, find the card "Mother Card" and add the item {triggercardlink} to checklist "Child Cards

3) Set up all cards on the board with the correct dates you require, including the master dates in the Mother Card

4) Lastly, you want an automation that when the mother card date is moved, it moves all the child cards by the same out amount of time

When a due date is moved in a card with a name containing "Mother Card", for item linked in checklist "Child Cards", move the due date by the same amount of time