Automation to update fields based on description?

[Justin Morgan]

Our HR system sends a request into our email which Jira picks up.  We have automation setup to set the Request type and organization but is there a way we can update fields based on the email description?   

For example we get the info below that always looks the same.  We'd like to capture "Fred Flintstone" and append their name to the end of the summary and set "12/4/23" to the due date.   Is this possible?  

"Our newest teammate Fred Flintstone has signed their offer. Their first day will be on 12/4/23"

[Murat Seven]

Hi @Justin Morgan

It seems like you're consistently receiving similar requests. I understood that this system operates in a static manner. If I've misunderstood, please correct me. If I'm right, I believe I can fulfill this request using the automation I shared in the screenshot below.

Best,

Murat Seven

[David Friedrich]

Hi @Murat Seven ,

I could be wrong, but I believe that "Fred Flintstone" and the start date are supposed to be examples. @Justin Morgan would need to extract the variable name and date from the email / description field and have it added to the summary and due date.

[David Friedrich]

Hi @Justin Morgan ,

yes that is possible as you can extract certain content via regex. 

Here is a very good article that should help you:

https://confluence.atlassian.com/jirakb/extract-content-out-of-description-and-summary-with-regex-and-automation-1157495262.html

[Justin Morgan]

Your other post is correct. This seems exactly what I'm looking for... trying it out now, thanks!!!!

[Justin Morgan]

Worked perfectly!!!   Only issue is setting the due date as its in mm/dd/yyyy and it needs to be 'yyyy-MM-dd"

Doesn't look like regex can change format so any ideas?

[Murat Seven]

Hi @Justin Morgan 

you can following docs might help:

.format("yyyy/MM/dd")

[Justin Morgan]

I saw that but not really sure where to place it since there's already the regex formula.  Below is what I have which outputs mm/dd/yyyy

{{issue.description.match(".*will be on (\S+)")}}