% 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.

[Arthur Darde]

thanks, this is what I feared!

[Arthur Darde]

But I still don't see how to create the formula between the custom fields

[milynnus]

@Arthur Darde 

Custom field arithmetic is quite limited. See :

https://help.trello.com/article/1160-custom-field-variables

the cron bot will have to handle the arithmetic since it involves dates, division and multiplication.