Hi,
I’m fairly new to Trello, but am embarking on a project where we are going to use to it as a scheduling system, scheduling work for each day. Each day is a list, each card is task. Each task (card) will have a custom field that indicates effort for the task.
Cards (tasks) can be moved to different days (lists within a Trello board) to identify when the work will begin.
Boards, list and cards will be created via API. Users will only move cards between lists on a board.
What I need to do is prevent a card (task) from being moved to a list (day) if the sum of the effort (custom field) of all the cards in the list now exceed a specified limit for the list.
So if I have 15 cards in a list, each with a custom field “effort” value of 3, I need to set my list total at 46. If I try to move a card from another list to that list, and it’s effort is 2, it will not allow it. ((15 cards in list *3 hours each) + (1 new card*2 hours) > 46), so it cannot move it.
If I try to move another card with an effort of just 1, then it will allow it ((15 cards in list *3 hours each) + (1 new card*1 hours) <= 46), so it is allowed.
Is there a power-up, or someway to do this?
Related requirement to this is lists and cards will be created via API, so the API must be able to specify the effort per card (seems like that works with the “Custom Field” power-up), but the lists will also be created via an API, so I also need to be able to specify the limit for each list (day). Different lists can have different limits.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.