i send out an notification when a specific field changes -> this works. But i only want to send out the notification if the specific field was not empty.
Old Value = empty -> New Value = X ----> no notification
Old Value = X -> New Value = Y ----> send notification
is there a way to do that?
Go to Solution.
I think you can Create a trigger on the field and then call procedure to send notification.
You can put the conditions in the trigger on which you need to send the notificaiton.
You can put condition in trigger like:
IF (old.field_value is not NULL ) --- if old value is NULL then dont call procedure
send_mail_procedure (pass required parameters here)
It would surely work, we have done similar to this on our system.
Thank you for your help, i will try this but im shure it will work .. so simple :)
Lostpond can you please explain how you are doing the first thing that you say
ie HOW DO YOU TRIGGER A NOTIF FOR A FIELD CHANGE?
Thank you so much!!