% progress between custom creation date & due date automatically updated

Arthur Darde

Hi there,

I've been unsuccessful in finding a way to calculate and then update on a regular basis (every hour for example) a field that would display the value

(Due date - Now)/(Due date - creation date) x 100.

=> this value will help me prioritize tasks based on the relative time remaining to complete the task.

For example : If I have 3 hours to complete two tasks, but one has been there since 24hours, the other since 5hours, then the former is much more urgent than the latter (at least in my usecase).

milynnus

@Arthur Darde 

This can be done with a cron bot that will run every hour to update, say a custom field. This will involve inspecting all cards with code and Trello api. Note that although this done via code, the plan entitlement will be consumed. I learnt this while running a asynchronous process to a update checklist via code.