Search
Twitter
« Updates To Recyle Bin | Main | Salesforce’s Next Billion Dollar Business »
Tuesday
Sep042012

Required Checkbox Validation

Prevent a Salesforce Record From Being Saved if Checkbox is not Ticked

So we now how to enable a required field in a record, but how about making a requried checkbox in your Salesforce form? well it's simple and here is how to do it:

In this tutorial, whether the three fields (Accounts, Date, Expected Completion Date) are populated, the record will NOT be saved unless the user ticks the checkbox (Review) 

Field 1: Lookup field called : "Account"
Field 2: Date field called "Date"
Field 3: Date field called "Expected Completion Date"
Field4: Checkbox called "Review""

AND(Review__c = FALSE,
OR(
NOT(ISBLANK(Account__c)),
NOT(ISBLANK(Date__c)),
NOT(ISBLANK(Expected_Completion__Date__c))))

and now, If the user enters data in to any one, any two, or all three fields, but does NOT check the box, an error will be thrown.

PrintView Printer Friendly Version

EmailEmail Article to Friend

Reader Comments

There are no comments for this journal entry. To create a new comment, use the form below.

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Post:
 
All HTML will be escaped. Hyperlinks will be created for URLs automatically.