Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Take a date from a ticket summary and apply to Due Date

Hello,


We have a form for new starters that comes into on prem jira.  

In the summary of the ticket the start date is populated by the form.

Is there a way using automation to take that date and populate the Due Date field please?


Many thanks in advance,
Mark

1 answer

1 accepted

1 vote
Answer accepted

Hi @Mark Cartwright 

Do you have automation for Jira installed in your instance?  If so, you should be able to parse out the date from the summary and use it to see the Due Date.

If not, there is a free (lite) and paid (pro) version of the automation rules, and you could discuss with your site admin about adding the feature.

Kind regards,
Bill

Hi Bill,

Thanks for the quick response.

We do have automation for jira installed and that's what I'm hoping to use but I have no idea how to parse the date out from the summary.

Can you advise or point me to info on how to do that please?

Kind regards,
Mark

Mark, I can try to do both! 

If you provide examples of your summary, the community can give you ideas how to parse that with a rule.

Next, here are links to the server documentation for automation rules, the template library of rules, and a large list of automation references:

Bill, thanks again for the response!

Unfortunately not been able to find what I need from the documentation you kindly gave me so here's the example of what I'd like to do.

The Summary of the ticket will always be in the same format as it's created by a mail sent via Power Automate.  The summary looks like this:

New Hire Form for *user's name* - *universal date format*

For example:

New Hire Form for Joe Bloggs - 2021-10-15

 

What I'd then like to do is use automation for jira to look at each newly created ticket, take that universal date and populate the Due Date field with it.

 

Would love to know how please.


Many thanks,
Mark

Mark, you should be able to extract that date using the right() function:

https://confluence.atlassian.com/automation/text-functions-993924863.html#Textfunctions-rightright(intlength)

For example with your summary layout:

{{issue.summary.right(10).toDate}}

The rest of the rule would be something like:

  • trigger: issue created
  • condition: ??? you probably want some type of condition here to limit which issues get processed.  Otherwise everything created in the project will try to do this.  Perhaps check that the {{initiator}} is who you expect to create the issue.
  • action: edit the Due date to equal the smart value from above
Like Hannes likes this

Thank you so much Bill, that works perfectly!

Like Bill Sheboy likes this

Awesome!  I am glad to learn that helped.

Hello,

first thank you for the great work!

I have a similar problem, which can also be solved with the solution described. Unfortunately our date is in a different format. I have read that you can change the date format, but everything I tried so far failed. What should the query look like if the format from the date in the summary is not 2022-01-21 but 21.01.2022?

kind regards
Hannes

Hi @Hannes 

My suggestion would be to use text functions to parse/convert the string into the standard Jira date format of yyyy-mm-dd and then use toDate on the result.

If you are using Jira Cloud with your automation rule, Create Variable would help for a working space location.  For example, if we assume your date of dd.mm.yyyy format is in the summary, put this in a created variable, such as named varMyDate:

{{issue.summary.substring(7,10)}}-{{issue.summary.substring(4,5)}}-{{issue.summary.substring(1,2)}}

Then use the date with:

{{varMyDate.toDate}}

Kind regards,
Bill

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Apps & Integrations

Send an Email or Publish to Confluence - What should you do with your release notes?

Background When you hear the words ‘Release notes’, almost always you think of an unsolicited email from a software vendor. But I am here to tell you that from our data, sending release notes via E...

130 views 1 2
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you