How can I make the closest checklist item due date the due date of the card?

[Federico Grego]

As I add due dates on the checklist items of a card, I would like the due date of the card itself to change to the closest checklist item due date.  Is that possible?

[Dreamsuite Mike · Accepted solution]

I hope Trello read this and add a {checklistitemduedate} variable. It keeps getting asked so clearly is a pain point, especially as there is an increasing number of people wanting to use advanced checklists.  It would surely be a really easy thing to implement!!

[milynnus]

@Dreamsuite Mike 

See my latest reply to @Federico Grego 

With Space Butler you can use any card attributes even it is not currently available as a variable

https://deta.space/discovery/@milynnus/space_butler

[milynnus · Accepted solution]

@Federico Grego 

There is automation that allows you to use a custom field date to update a checklist item. However, there is no native functions between automation that will tell you which item has a date that is closest to the card due date.

In creating this app

https://deta.space/discovery/@milynnus/taco_bump

I store away the difference between the item due dates to be used to adjust the item due dates using another date field. But the magic was done with code.

[Federico Grego]

Thanks.  I think what I was trying to ask is simpler: can the card due date update itself automatically to equal the date of the closest checklist item date?

[milynnus]

@Federico Grego 

I don’t think there is a way to determined which is the item. There is a badge that has the earliest due date of checklist item. That might help if it can be exposed via api. Let me check. 

[milynnus]

@Federico Grego 

Tested this an it works with a card button calling an existing service in Space Butler and it will set the due date to the earliest item that is due.

post to url "https://space_butler-1-f9...6.deta.app/get_card" with payload "{ \"card_id\" : \"{cardidlong}\"}", post comment "{httpresponse.json.badges.checkItemsEarliestDue}", set custom field "CF_Date" to "{httpresponse.json.badges.checkItemsEarliestDue}", and set due date on the date in custom field "CF_Date"

The actual implementation will depend on your workflow.

Space Butler is available at 

https://deta.space/discovery/@milynnus/space_butler