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

Can you help me, how to set automation reminder(send email) when now date is 90 days before due date

Agnes August 31, 2022

I need a reminder automatically always starts when the now Date is 90 days before due date of my issue/task, then continually after that the reminder sent again every 1 weeks.

How can I set this condition?

Thank you

2 answers

2 accepted

1 vote
Answer accepted
Olha Onofriichuk_SaaSJet
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
September 1, 2022

Hi, @Agnes 

Actually, this may be easily done whin any amount of reminders you need. Recently, I've written a few articles about how you can set this process up: 

If you need, I (or my team) can show you how to set automation reminder whenever you need via SLA Time and Report for Jira add-on. This plugin can definitely help you with your question.

Let me know, if you need more information or help with such settings.

Have a great day.

Sincerely,
Olha

Agnes September 1, 2022

Dear @Olha Onofriichuk_SaaSJet ,

Well noted and thank you for your support..

Olha Onofriichuk_SaaSJet
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
September 2, 2022

@Agnes I'm glad it helped you! Feel free to message me if you need any help with setting up sending the reminders.

1 vote
Answer accepted
Mark Segall
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 31, 2022

Hi @Agnes and welcome to the community!

You had me intrigued with the need for weekly updates as I was thinking there has to be a straightforward way to handle this. Here's what I did in my test environment:

  • TRIGGER: Scheduled (Daily)
    • statusCategory != Done AND dueDate >= startOfDay() AND dueDate < startofDay(91d)
  • IF CONDITION (Advanced Compare): Here we check to see if this is the 90 day warning
    • {{now.plusDays(90).jiraDate}}
      Equals
      {{issue.dueDate}}
    • ACTION: Send Email
  • ELSE CONDITION (Advanced Compare):  Here's where we're checking to see if the issue is exactly n weeks from the Due Date.  This formula is evaluating whether it's a whole number.  If it is, send another alert.
    • {{#=}}FLOOR({{now.diff(issue.dueDate).days}}/7){{/}}
      Equals
      {{#=}}CEILING({{now.diff(issue.dueDate).days}}/7){{/}}
    • ACTION: Send Email

Here's a screenshot of what I did. I added variables in here for testing, but they could also be useful for giving dynamic email messages (e.g. You have n weeks remaining until your due date):

2022-08-31_13-11-27.jpg

Agnes September 1, 2022

Dear @Mark Segall ,

Thank you for your support. I have already tried it and success.

I can use it for my tasks..

Really appreciate for your response and help :)

Like # people like this
Mark Segall
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 2, 2022

Fantastic!  

Like Andrii Vavrynets likes this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events