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
Terry_0101Terry_0101 

Enforce Shipping fields are populated

How to make this validation rule enfore ALL shipping fields are populated?  I have so far...

AND( 
AND( 
AND( 
ISPICKVAL( StageName , 'closed won'), 
ISPICKVAL( StageName , 'closing likely'), 
ISPICKVAL ( Hardware__c, 'Hardware will be shipped' ), 
OR( 
ISBLANK( Account.ShippingAddress), 
ISBLANK( Account.ShippingCity), 
ISBLANK( Account.ShippingState), 
ISBLANK( Account.ShippingCountry), 
ISBLANK( Account.ShippingPostalCode)))))
Dan ErvinDan Ervin
Well, you could mark the fields required on the page layout (or field settings). Or, you could use this as a validation rule:

OR(
ISPICKVAL(Shipping_Picklist_Field_1,""),
ISPICKVAL(Shipping_Picklist_Field_2,""),
ISPICKVAL(Shipping_Picklist_Field_3,""),
ISBLANK(Shipping_Text_Field1),
ISBLANK(Shipping_Text_Field2),
ISBLANK(Shipping_Text_Field3),
)

If any of those return true, the entire formula will return true and fire off the validation rule.