Notify when the due date field changes

[Karoline Rezende Ramos]

Hello everyone.

I would like to know if it is possible to create the automation:

1. When the due date is changed (Due Date) to be notified by e-mail
2. Appear in the body of the e-mail the date that was before and the new date.

The PMO team wants to have control over the due dates and be notified when they change without alignment.

[Mark Segall · Accepted solution]

Hi @Karoline Rezende Ramos 

This is totally doable with smart values.  Here's a sample on how you would do this:

The key to this is using the changelog smart value:

Old Value:  {{changelog.duedate.fromstring}}

New Value:  {{changelog.duedate.tostring}}

[Karoline Rezende Ramos]

Wow. Thank you so much!

[Frédéric Eckert]

Hello @Mark Segall

I've previously created this rule, but it's not satisfactory (too much notifications): indeed, I'd like to be able to send an email with the list of tasks whose "duedate" field changed for previous day (sending based on scheduled trigger: e.g. each day at 9:00 am).

The result would be, each morning at 9:00 am:

Hello {{assignee.displayName}},

The duedate changed for this list of tasks:

{{#lookupIssues}}
<a href="{{url}}">{{key}} - {{summary}} is now set for <b>{{duedate.format("dd/MM/yyyy")}}</b></a>
{{/}}

I've made several tests with smart values, but with ni success: do you have some ideas to help me, please?