The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Notification on field change

SOLVED
Go to solution
Highlighted
lostpond
Acclaimed Contributor

Notification on field change

Hi ,

 

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.

 

Example

 

Old Value = empty -> New Value = X  ----> no notification

Old Value = X -> New Value = Y ----> send notification

 

is there a way to do that?

 

Regards

Lukas

 

5 REPLIES
Mohit_Agrawal
Frequent Visitor

Re: Notification on field change

Hi Lukas,

 

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.

 

Regards,

Mohit

lostpond
Acclaimed Contributor

Re: Notification on field change

Hi, thank you for you help!

how can i put the conditions into the trigger and what should the condition look like?
Mohit_Agrawal
Frequent Visitor
Solution

Re: Notification on field change

Hi,

You can put condition in trigger like:

 

 

IF (old.field_value is not NULL ) --- if old value is NULL then dont call procedure

THEN

send_mail_procedure (pass required parameters here)

end if;

 

It would surely work, we have done similar to this on our system.

 

Regards,

Mohit Agrawal

lostpond
Acclaimed Contributor

Re: Notification on field change

Thank you for your help, i will try this but im shure it will work .. so simple :)

gmatrozos
Regular Collector

Re: Notification on field change

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!!

 

//Add this to "OnDomLoad" event