AND(
checkbox1__c = FALSE,
checkbox2__c = FALSE,
ISPICKVAL( Type , "Prospect"),
ISPICKVAL(employee_numbers__c , "1-100"),
OR(
ISPICKVAL (BillingStateCode , "NV"),
ISPICKVAL (BillingStateCode , "AZ"),
ISPICKVAL (BillingStateCode , "NM"),
ISPICKVAL (BillingStateCode , "TX"),
ISPICKVAL (BillingStateCode , "OK"),
ISPICKVAL (BillingStateCode , "AR"),
ISPICKVAL (BillingStateCode , "LA"),
ISPICKVAL (BillingStateCode , "HI"),
AND(
ISPICKVAL (BillingStateCode , "CA"),
OR(
BEGINS( BillingPostalCode , "90"),
BEGINS( BillingPostalCode , "91"),
BEGINS( BillingPostalCode , "92"),
BEGINS( BillingPostalCode , "93")))))
Basically, if an account fits the criteria (in a specific geographic location), it fires a field update. For some reason when a record is edited and the new data fits the criteria it doesn't fire, but if that same record is edited and saved without changing the data the wfr fires. I am at a loss why this might be. It should fire every time.
3 answers
Mark, why don't you use, every time a record is created and edited to subsequently meet the criteria in workflow ?
