+ Start a Discussion
TigerPowerTigerPower 

checkbox validation rule

Hey,

how about this one?!

 

If 'Male' checkbox is checked then 'Female' checkbox has to be unchecked. How do I write a validation rule for that? And of course this goes both ways, so only one sex can be checked :smileyhappy:

 

Can you please help me with this one? 

Thank You!

 

Best Answer chosen by Admin (Salesforce Developers) 
TigerPowerTigerPower

IF(Male_c, Female_c, null)

How simple is that? Very! 

 

Stevemo... thanks! :smileywink:

 

 

All Answers

SteveMo__cSteveMo__c

The formula to evaluate a Checkbox Field is

 

 

IF({!CheckboxField}, value_if_true, value_if_false)

 

 But why bother having 2 seperate checkbox fields in the first place?  Wouldn't you be better off using one single value picklist (Gender) field?

 

 

TigerPowerTigerPower

Well, customer prefers checkboxes. We had first a picklist, but they think that checking a checkbox is easier to do.

 

Maybe I'm missing something, but I think that you can't validate two checkboxes against each other with that syntax. Or can it be that simple (or maybe I am...) :smileysurprised:

 

 

SteveMo__cSteveMo__c

(sorry, my bad)

 

I was just using that as an example of a simple Checkbox validation.  For what you want to do, you'll have to amend it to compare the 2 fields.

 

 

 

PS.  I'm resisting the urge to comment on your customers  *difficulty* using a Single Value Picklist

TigerPowerTigerPower

Yeah :smileyvery-happy:

 

Life is. Some kind of difficult (sometimes).

 

 

SteveMo__cSteveMo__c
Unfrozen Caveman SalesforceUser "Your wordy picklist thing confuses and frightens me..."
TigerPowerTigerPower

IF(Male_c, Female_c, null)

How simple is that? Very! 

 

Stevemo... thanks! :smileywink:

 

 

This was selected as the best answer
pankaj.kumar@sfd.compankaj.kumar@sfd.com

Hi,

  can you send me steps of that validation.

 

thanks 

pankaj