I'm trying to create an automation that will add labels or notify me of clients who will turn 50 in 2025. It would be great if the automation would create a list based on date of birth on January 1st of each year of individuals turning 50 without me having to annually up date the year. Is this automation possible in Trello?
I wrote an article on this very topic:
I hope it helps but if you have any other questions, please follow up
Hi @Dreamsuite Mike ,
Thanks to the article, Trello is calculating the age and I have added labels based on specific ages.
I'm curious, would you use regex or a wildcard to denote "any label" vs the "green" label to accomplish the following scheduled automation?
Every year on the 1st of January, copy each card with the "any label (not a specific label)" to today list on my week board.
Is there a regex cheat sheet or explanation guide that you can reference?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I would probably use a wildcard in the label unless you want to specify the conditions further. Like if it were certain types of label, I would probably use a regex to create OR conditions (see example 2 below)
I will pledge to make a Trello automation Regex guide before the end of this year. For now, here are some useful bits of advice.
This is a great site for learning about it:
And this is the go-to place to test out your regex search before putting it into a Trello automation command:
Top Tip 1:Always get the regex expression right on Regex101.com before putting into a Trello command, there isn't much debug in Trello if it doesn't work
Top Tip 2:Google what you are looking for, easier than learning to construct yourself, almost every common example you can think of has a thread on stackoverflow.
Top Tip 3: Use AI to generate the regex for you. Its not 100% correct but pretty close
Here are where you can use regex to match text in Trello automation:
Examples:
when a card name is changed to regex:/(.*):(.*):(.*)/i, set the custom field "Project Number" to "{wildcard1}" and set the custom field "Project Name" to "{wildcard2}" and set the custom field "Project Manager" to "{wildcard3}"
These are just a few, you can find more regex bits here on the community:
If you found this answered your question, please kindly click the Accept Answer button
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.