I'm so sorry to dig this up from 2 years ago, but I have a similar business need. We have a date field that changes all the time, but we only want people to get notified of the first initial change. Did the checkbox solution work for you? The logic is somehow not making sense to me.
Ideally, if [Date.old] is blank and [Date] is not blank, send a notification. If [Date.old] is not blank and [Date] is not blank (meaning there was already a date entered), don't send a notification.
How it should be is,
- Record has a blank date
- Date is added to the record, notification is sent
- Date is changed on the record, notification is not sent
The suggested solution is,
- Record has a blank date
- Date is added to the record, notification is sent, box is checked upon record save
- Date is changed on the record, notification is not sent if the box is checked
However, in step 2, saving the record with the added date will also check the box, so the notification wouldn't go out, anyway, because the box is checked as soon as it's saved, right?
The only workaround I can think of is to have a manual checkbox that people will have to check if they do not want notifications to be sent.
