You need to sign in to do that
Don't have an account?
summerproject
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.
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