Can I have Butler set a due-date of 2 working days later, only if the card is added by 9pm?

Eric Sirianni_eh2inc

If our customers add their requests to a specific Active Request list by 9pm EST, we guarantee their request will be delivered by 5pm, two days later.

For example:

If the customer adds their request to the Active Request list at 8:59pm on Monday, we will finish their request by 5pm Wednesday.

If the customer adds their request to the Active Request list at 9:01pm on Monday, we will finish their request by 5pm Thursday. 

 

What I'm aiming for is when a customer adds an episode to the "Active Request" list, Butler assigns the due date and time (by 5pm) to the card, based on the scenarios above. (if it's before 9pm Monday, Butler sets the due date for 5pm Wednesday, if it's after 9pm Monday, Butler sets the due date for 5pm Thursday.

 

Everything else works beautifully, just the 9pm deadline screws everything up, and we unfortunately can't change it.

The other tough part is, seeing as this is customer facing, we can't expect them to do anything more than add the card to the Active Request list.

 

Also, does anyone know what times Trello considers "Working Days"? Is it just 12am to 11:59pm Monday through Friday? If that was customizable we would be gold!

 

Thanks so much, you all have been so helpful in the past!

Nathan Smith_5jmh6a

Hi @Eric Sirianni 

Nathan here from Trello Support, hope you're doing okay?

This isn't something that's possible just using Butler but you should be able to set this up using a combination of Butler and Custom Fields, below are some steps you can use to do this:

1. Create a Custom Field called Created Time with a type of Number
2. Create a rule in Butler that when a card is added to the board (or added to your Active Request list) the Created Time custom field is set to {time24}
3. Once you've saved this rule create a second rule that when the Created Time custom field is set to a number less than 21, set the due date on a card for in 2 days time
4. Then create a third rule that when the Create Time custom field is set to a number greater than or equal to 21, set a due date on the card for in 3 days time

Once you've set up and enabled these 3 rules your due dates on the cards should be set correctly, can you give this a go and let me know if this works for you or not?

I believe weekdays in Trello are recognized as Monday to Friday 12:00 am to 11:59 pm, this isn't something that's able to be modified at the moment but I'll pass your interest in this on to our team for consideration!