Move card if today >= start date

[Benjamin]

I would like to move cards automatically to a "in progress" list whenever the custom field  "start date" is = or > to today's date.

(Alternative answers on how can I automate organization of card to show which tasks should be started would be acceptable).  

Thanks

[Benjamin · Accepted solution]

The solution is to create a calendar trigger with Butler:

every day, move each card in list "Up Next" with custom field "Start Date" set to a date less than 1 days from now to list "In Progress"

[Remy]

I don't think this option existed in march 2020, but as of now you can just use:

every day, move each card in list "Up Next" starting today to list "In Progress"

[Iain Dooley]

@Benjamin you can do this using Butler if you use the "Due Date" on the card as the "Start Date", and then you could have a custom field to indicate the actual "due date" or end date of the task. This seems backwards, but Butler doesn't have the option to trigger based on custom field date conditions.

Another option would be to use a due date trigger in Butler with an offset defined by the number of weeks or days it will take to complete the task, but the offset would need to be fixed, ie. you couldn't have a custom field defining the number of weeks it will take to complete a task and then offset by that field, you'd have to always do 7 days prior to the due date or something like that.

Will either of those solutions work?

[Benjamin]

Thanks for trying @Iain Dooley , the solutions wouldn't work as they require sacrificing one feature for another.

I tried the following:

1. Button: 

move each card with custom field "Start Date" set to a date less than 1 days from now to list "In Progress"

2. Calendar:

every day, move each card with custom field "Start Date" set to a date less than 1 days from now to list "In Progress"

Running the button though clearly didn't work, so my cards with a start date "3 Feb 2020" are not moving to "in progress" as of 3 March 2020. 

[Benjamin]

Okay I think I figured it out:

Running two jobs:

1. bring in past cards:

every day, move each card with custom field "Start Date" set to a date more than 1 days ago in list "Up Next" to list "In Progress"

2. bring in today's cards:

every day, move each card in list "Up Next" with custom field "Start Date" set to a date less than 1 days from now to list "In Progress"