How can I create an "on this day"/throwback/flashback automation?

Question

I'd like to be able to resurface archived cards from this day in history, to see what I was up to. I'm picturing using a Scheduled Automation that would maybe use a date variable somewhere. Cards from a year ago, a month ago, or whatever would move to a list called "On This Day."

But, of course, I'm open to any methods I haven't thought of!

Sal_mqejn5 · Answer

The best way I can think of would be to move all the cards you've completed to a "Done" list and then create a scheduled command similar to this one:

every friday, create a report in variable "report" with all cards in list "Completed", and send an email notification to "email@emailTest.com" with subject "Weekly Report for week #{weeknumber}" and message "{$fridayreport_html}"

This will generate an email every Friday with a report of all the cards in the "Completed" list and email you this report. You can make some adjustments to include other information in your email report, but this is basically how to get started.

You can read more about email reports here: https://support.atlassian.com/trello/docs/creating-reports-with-butler/

I hope this helps, Scott!

Scott Selva · Answer

Thanks, @Sal . That makes sense. And that's a good idea about making a "Done" list. What would be the optimal way to create a report like what you mentioned? I think I'd need a date variable in there somewhere, but that's the part that's tripping me up.

Sal_mqejn5 · Answer

Hi @Scott Selva! Unfortunately, there isn't a way for you to create a report that would fetch your closed cards. The scheduled command will only fetch open cards in your board. Alternatively, you could move the cards you've completed to a list called "Done" and then create a scheduled report that would fetch all the cards in this list. I believe this could be the best option here.

You could also try using Zapier to see if it's something possible. I know a lot of Trello users use Zapier to integrate and Automate some of their board processes on Trello. I hope that helps.