+ Start a Discussion
summerprojectsummerproject 

Email alert does not work when I use ISCHANGED function for more than one field

Hello, I am trying to set up an email alert that goes to users to notify them when a record has been modified. I used ISCHANGED (field) and combined it with AND functions to make it possible to send alert when more than one field had been modified. On the update field side I put values I want to be displayed like " Account, Contact". They all say they are correct formulars but I dont get the updated value that I specified. Does anyone know what I am doing wrong or why ISCHANGED (field) is not working for more than one field? I appreciate any help.
Dan_CDan_C

With the way you worded your question, I think you will want to change to use the OR function.

 

If right now you have it setup like:

 

And(

ISCHANGED (field1)

ISCHANGED (field2)

ISCHANGED (field3)

)

 

That is only going to fire an email alert if all 3 of those fields are changed at the same time.

 

If you change to something like this:

 

OR(

ISCHANGED (field1)

ISCHANGED (field2)

ISCHANGED (field3)

)

 

That will fire an email alert whenever any one of those fields are changed, not just when all three are changed.

 

I think thats what you were asking. I may have missunderstood.

 

Dan