Forum Discussion

ZintJoseph's avatar
ZintJoseph
Qrew Captain
7 years ago

I need to trigger a notification on a date change in a date field

Here is the scenario A new project is setup but no scheduled date is entered A PM comes into the project and enters the scheduled start date A change to that date occurs after it is entered I ...
NotificationsEmail
JasonJohnson's avatar
JasonJohnson
Qrew Assistant Captain
7 years ago
I think automations will work as well. I used a field Install Date and Orig Date
Create a check box formula field 'Is orig date' and use the formula
If(ToText([Install Date])=ToText([Orig Date]),true,false)

You can run the Notification on if the install date is changed and if that date is equal to the original date. Also in the Notification you can display the Original Date. It is an option and a good way to practice Automations, it was for me.