Jira Automation - Automatically send an email 24 hours in advance based on a date field.

Anthony Morais August 8, 2022

I have a custom field of type Date Time Picker, called Maintenance Date. This field is nothing more than the date of a scheduled maintenance. I wanted to create an automation so that a reminder email is sent to a team 24 hours before the date selected in the custom field.

1 answer

1 accepted

2 votes
Answer accepted
Manon Soubies-Camy _Modus Create_
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 8, 2022

Hi @Anthony Morais and welcome to Community!

The easiest way to achieve this is to trigger an automation rule everyday and to check which issues are planned until the following day.

  • Using the Scheduled trigger:

reminder-trigger.png

The JQL query returns all issues having Maintenance date between now and the next day at 23:59:

"Maintenance date" >= now() AND "Maintenance date" <= endOfDay(1)

You could also use the following query if you have a fixed 24h window:

"Maintenance date" >= now() AND "Maintenance date" <= 24h
  • Then the email (or Slack, or Teams, or even just a Jira comment) action:

reminder-action.png

Hope this helps,

- Manon

Ashly Montaño August 8, 2022

Wow really thank you very much!
I needed this information 

Anthony Morais August 8, 2022

@Manon Soubies-Camy _Modus Create_ Thanks for the quick response.
I already tested it and it worked, thank you very much.

Manon Soubies-Camy _Modus Create_
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 8, 2022

Glad it helped :)

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events