Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,463,996
Community Members
 
Community Events
176
Community Groups

Butler - How to pull due date from title while also modifying title?

Hi, we are currently using email-to-board to manage incoming requests from a form. When the request gets emailed into Trello, I set up a rule to rename it and add a label:

when a card with a name starting with "New Marketing Request - {*} - {*} - {*} - {*}" is emailed into the board, rename the card to "{wildcard1} - {wildcard2}", and add the sky "Request" label to the card
And another that pulls the date from the title and makes it the due date on the card
when I enter a card name containing a date, set due on the date and remove the matched text
However, I recently ran into an issue where I wanted to name a card "Ad - 1/2 page" and it kept thinking the 1/2 was a date. I only want it to pull the date from these emailed in cards. Unfortunately there is no emailed into option for that trigger, so I played with wildcards a bit but realized I don't think commands necessarily run in the same order every time? So can I combine into one rule?
when I enter a card name containing a date after "New Marketing Request - {*} - {*} -", set due on the date and remove the matched text, rename the card to "{wildcard1} - {wildcard2}", and add the sky "Request" label to the card

But so far I'm not having much luck... it's not catching the cards like the "when a card with a name starting..." trigger would. Would appreciate any insight!

1 answer

0 votes
Hannah Morgan Community Leader Jun 29, 2022

Hi @Olivia Henao ! Just to confirm, you're wanting to add a condition to your rule "when I enter a card name containing a date..." command so that it only applies to the cards created from email. Is that right?

It's not possible to add a condition to that particular trigger. My first thought would be to use a different user for your email-to-board settings - like a service account. Then, create the date command logged in as the service account. The command says "when I enter a card name..." so that means it will only apply when the service account creates cards AKA when cards are created from email.

Hi Hannah! That is actually in the plans for the future, because right now I have created all of our automations and they're tied to my account, so if I were out or left my team would be in a bit of trouble haha.

In the meantime however I was hoping to get this working with my account... was my last attempt not looking possible? This one:

when I enter a card name containing a date after "New Marketing Request - {*} - {*} -", set due on the date and remove the matched text, rename the card to "{wildcard1} - {wildcard2}", and add the sky "Request" label to the card

 Because all the cards that get emailed in that I want to apply this to have the same subject format - "New Marketing Request - {Department} - {Need} - {Date} - {Request Number}" so I thought that would help capture them, which it did when I was just renaming them, but I'm struggling with the due date trigger.

Hannah Morgan Community Leader Jun 30, 2022

@Olivia Henao I think the only way it'd work in that case would be if your format was something like: "New Marketing Request - {Date} {Department} - {Need} - {Request Number}"

Then, your command could say:

when I enter a card name containing a date after "New Marketing Request -", set due on the date and remove the matched text, and add the sky "Request" label to the card

 
So if your card title was "New Marketing Request - 7/15 Create Blog Post - Sales - 1234", the command will set the due date to July 15 and rename the card to "Create Blog Post - Sales - 1234".

The "matched text" in this case is "New Marketing Request - 7/15" so that part of your title would be removed. 

If your trigger says:

when I enter a card name containing a date after "New Marketing Request - {*} - {*} -"

 
Then the matched text would be everything up until the date so the department and need would be removed from the title.

Hi @Hannah Morgan sorry for the delayed reply.

So it seems the issue is that the due date match relies on being at the beginning of a string? 

I tried another route, trying to pull the date from the description instead of the title:

when I enter a card description containing a date after "Needed By:", set due on the date

 The "Needed By:" is not at the beginning of the description either. It hasn't been working for the most part, though oddly it worked today on one instance... the only difference I can see is the "Needed By:" wasn't bold? Should that affect it?

ETA: Played with that idea and tried to use Regex to capture both, but that doesn't seem to be helping lol...

when I enter a card description containing a date after "regex:/.*(Needed\sBy:|\**Needed\sBy:\**).*/", set due on the date

 

Hannah Morgan Community Leader Aug 03, 2022

@Olivia Henao I don't think the due date match needs to be at the beginning of the string. It could be anywhere in the title. You just need to make sure you're removing the correct matched text. In the original command you shared, the matched text contained the department and need, so it would remove this information in that case. 

For example, if your title was:

{Department} - {Need} - New Marketing Request - {Date} {Request Number}

Your command could say "when I enter a card name containing a date after "New Marketing Request -"

When Trello removes the matched text, your title would be left with:

{Department} - {Need} - {Request Number}

So the matched text that's getting removed is just "New Marketing Request - {Date}"


For your other command with the description, it could be that you need to include the markdown formatting like you've started experimenting with - so try "...containing a date after "**Needed By:**"

You might have to create two separate rules to account for the text being bold. Not sure if regex would work in this case 🤔


Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events