function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Dan KiddDan Kidd 

Field changed > send e-mail alert Workflow rule

Hi,

This is my first post on SF dev forum, so be gentle :)

I'm trying to create a workflow rule to e-mail X users when the Billing Address on an Account is changed. I currently have the below rule set up but I can't get it to fire. Does anyone have any ideas to make this work/more elegant!
AND( 
OR( 
ISCHANGED(BillingCity), 
ISCHANGED(BillingStreet), 
ISCHANGED(BillingState), 
ISCHANGED(BillingPostalCode)), 
NOT(ISBLANK( PRIORVALUE(BillingCity))), 
NOT(ISBLANK( PRIORVALUE(BillingStreet))), 
NOT(ISBLANK( PRIORVALUE(BillingState))), 
NOT(ISBLANK( PRIORVALUE(BillingPostalCode))), 
NOT(ISNEW()) 
)

Thanks in advance,
Dan
Best Answer chosen by Dan Kidd
Maharajan CMaharajan C
Hi Dan,

Please try the below Formula:

AND(
OR(
AND(NOT(ISBLANK(PRIORVALUE(BillingCity))),ISCHANGED(BillingCity)),
AND(NOT(ISBLANK(PRIORVALUE(BillingStreet))),ISCHANGED(BillingStreet)),
AND(NOT(ISBLANK(PRIORVALUE(BillingState))),ISCHANGED(BillingState)),
AND(NOT(ISBLANK(PRIORVALUE(BillingPostalCode))),ISCHANGED(BillingPostalCode))
),
NOT(ISNEW())
)

Can you please Let me know if it works or not!!!

If it helps don't forget to mark this as a best answer!!!

Thanks,
​Raj

 

All Answers

Amit Chaudhary 8Amit Chaudhary 8
Please try below formula 
OR( 
		ISCHANGED(BillingCity), 
		ISCHANGED(BillingStreet), 
		ISCHANGED(BillingState), 
		ISCHANGED(BillingPostalCode)
)

Let us know if this will work
 
Maharajan CMaharajan C
Hi Dan,

Please try the below Formula:

AND(
OR(
AND(NOT(ISBLANK(PRIORVALUE(BillingCity))),ISCHANGED(BillingCity)),
AND(NOT(ISBLANK(PRIORVALUE(BillingStreet))),ISCHANGED(BillingStreet)),
AND(NOT(ISBLANK(PRIORVALUE(BillingState))),ISCHANGED(BillingState)),
AND(NOT(ISBLANK(PRIORVALUE(BillingPostalCode))),ISCHANGED(BillingPostalCode))
),
NOT(ISNEW())
)

Can you please Let me know if it works or not!!!

If it helps don't forget to mark this as a best answer!!!

Thanks,
​Raj

 
This was selected as the best answer
Dan KiddDan Kidd
Thanks Raj! This worked a treat.