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).
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
But I still don't see how to create the formula between the custom fields
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.