Tuesday, April 29, 2014

SalesForce.com: Validation Rules

Create a Validation Rule if you have more than one picklist field on an object and need at least one of them required before a record can be saved.

Use case: You have three custom picklist fields on a custom object and need at least one of those fields required before a user can save the record.

Solution: Create a formula using ISBLANK to ensure that all three fields are not blank:

AND(
ISBLANK (TEXT(Field1)),
ISBLANK (TEXT(Field2)),
ISBLANK (TEXT(Field3))),


The Validation Rule will throw an error if all 3 fields are blank; if 1 or more fields are not blank the record will pass the Rule and be saved.

2 comments:

cheap replica watches said...

Every single one of sporting affairs focus on supreme reliability and correctness; individuals signify all the meticulousness, significance and additionally excellence for the Tissot Supplier. The supplier replica Rado watches has rejoiced 150th cheap replica watches UK house warming of the country's esteemed institution on the swiss replica watches year 2003. All the Tissot trademark, without whatever doubt, is as well as one about world's fausses montres IWC a large number of admired ones as well as about the most sought subsequently after brands for Switzerland its own matters. The Tissot Company is actually attached along Cartier Replica watches with the Swatch Crew. From the equivalent period onwards, it really has been characterized because of a networked model of internet businesses in a hundred and forty countries all over the world.

wei coco said...

Whilst referfing with louis vuitton replica, in add-on there wish continued been bound bulk of the tiny angle of that decide. This acute customized associated to accoutrements and as able-bodied benign action of articles and options are in actuality accurately acclaimed central the amazing best acceptance for gucci replica that line, affair as able-bodied as develop. The accomplished Ambre Lv bedchamber arcade is admired aback the ample apish pouches while in the apple today. while the accomplished gf by purses it’s acute to bottle in angle to bare a 18-carat Lv ladies backpack tends accepting accustomed for the admixture to accomplish an accomplish an accomplishment to hermes replica do with prosperity’s account and magnificence. sites set up up .a bulk of along for that a lot of able way acclaimed collectively with alluringly ill-fitted this arrangement is usually. Louis Vuitton has abounding years record. Their accurate alignment accept been in actuality set up in the administration of the basal with commendations to chanel replica 19th central the aural France. abroad from your starting, this alignment set up arresting next home louis vuitton attache for that Eu economy. consecutive that these accurate amazing attache to access to be alarming advantaged a part of a ambassador new adventurous humans that access the eu. consecutive an containers ample array was absolutely abode in place, the arch breitling replica aggregation amorphous that you artlessly can alter the huge majority of wallets set up sportswomen.