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
Laura_Thacker's avatar
Laura_Thacker
Qrew Commander
7 years ago
Joey - I would build a child table to capture the history of changes.  Trigger notifications each time a new date is created by the automation/webhook/qb action; pointing back to the parent-record.  This way you get a true-history of the changes as well.

Snapshots only work on lookup fields; and only when a record is created.
Laura_Thacker's avatar
Laura_Thacker
Qrew Commander
7 years ago
If you create a new one each time; the trigger will be more effective on the email and you get the benefit of the history in an easy to see embedded report; rather than a text-append type of visual.