How do I create an automation to move a card that's been inactive for X days?

Question

I've tried figuring this out through the Butler interface but can't find any options for actions that occur after a certain period of inactivity. I've also seen some commands online such as this one: "for each card in list "To Do" inactive for more than 5 working days, add the red label"

I could adapt this command for my own purposes,  but can't find a place in Butler where you can enter a command like this using this code/script alone. Is there such a place?

Thanks!!

milynnus · Answer

@Matt Jarman

Below is the solution I shared with Brett. It does mean signing up to my Superhero Power or developed you own endpoint to support this. You can also used the variable in the way that works for you. The thing is Butler does not handle if conditions.

every day at 8:55 pm, create a report in variable "last_activity" with all cards using pattern "{cardlastactivitydate~YYYYMMDD}^{date-7d~YYYYMMDD}^- The date of last activity of this [{cardname}]({cardlink}) in this List {cardlistname} is more than 7 days ago. The last activity was on {cardlastactivitydate}.", post to url "https://25368.wayscript.io/butler/?registry=<registry ID>&module=5f8f85b37e48935f02fa954e" with payload "{"report_variable" : "{$last_activity}"}", and send an email notification to "sgi.collective.sg@gmail.com" with subject "Last Activity More 7 days Ago" and message "Here's your report :

{httpresponse.condition_met_list}"

Matt Jarman · Answer

Thanks for this - I looked through the threads and {cardlastactivitydate} does sound like it would help with what I'm looking for. But I'm not sure where to put it or raw code that contains that variable in it.

Where do I go for that? I'm currently using Trello Gold.

Thanks!

milynnus · Answer

@Matt Jarman  Look at this post on a undocumented variable for dateLastActivity and also look at the solution in my post for Brett K.

https://community.atlassian.com/t5/Trello-discussions/Have-you-discovered-any-undocumented-variable/m-p/1513446#M1497