You need to sign in to do that
Don't have an account?
babranno
ISCHANGED
I am pretty new to salesforce and I am struggling to create a validation rule. I want to use the ISCHANGED function with a phone or fax number. So if the phone or fax number is changed on an account then it triggers a field update on a custom object. The workflow keeps telling me that I cannot use ISCHANGED with a phone or fax number. Does anyone have a work around? Thanks for the help.
Bladen
ISCHANGED can only be used when the WFR is triggered "Every time the record is created or edited"
ISCHANGED
NOT(AND(ISCHANGED(Priority), ISPICKVAL(Priority, “Low”)))is a validation rule that ensures if a user changes the Priority of a case, the new priority cannot be “Low.”
I was aware of that caveat; however, the ischanged does not want to work with the standard phone number data type from account. That is why I am having trouble getting the workflow to work.
If you are sure, that you are using "Every time the record is created or edited", ISCHANGED(Phone) does work on Account. I think you are missing something else where. Remember Phone is treated as a text and if you are trying to update a field which is a number try using VALUE(Phone) in your field update.
Also, check if you have activated your worflow rule.
It would be great if you specify what trouble you are having and when.