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
RRRizeRRRize 

WORKFLOW HELP - Update checkbox ONLY when address is updated. Not when new address is inputted...

I have a checkbox that I want updated ONLY when the address is updated.  Below is the formula I use in my workflow rule, and it works well EXCEPT, it also checks the checkbox when the address fields are blank and new address is entered.  I just want the checkbox checked when an address is already there but is changed/updated.  Here is what I have in place - please help me fix this:

 

My evaluation criteria is EVERYTIME A RECORD IS CREATED OR EDITED

My ruule criteria is RUN THIS RULE IF THE FOLLOWING FORMULA EVALUATES TO TRUE:

 

OR(
ISCHANGED( Address__c ),
ISCHANGED( City__c ),
ISCHANGED( State__c ),
ISCHANGED( Zip_Code__c ))

 

 

Thanks for your help!

Navatar_DbSupNavatar_DbSup

Hi,


You have to simply add the new condition which will check for the blank.

 

Try the below rule and made changes accordingly (This rule is on contact object):


OR(
ISCHANGED( MailingStreet ),
ISCHANGED( MailingCity ),
ISCHANGED( MailingState ),
ISCHANGED( MailingPostalCode )) && NOT(ISBLANK(MailingStreet) )

 

Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved.