[SalesForce] Validation rule to allow only one field with value

I have 3 Text field in a page. While saving only one text field should have the value. If more then one text filed has a value it should throw an error. How i can do this in validation rule.

Best Answer

there could be other better ways, but one possible way i can think of is to do something like this

( IF(ISBLANK(Field1),0,1) + 
  IF(ISBLANK(Field2),0,1) + 
  IF(ISBLANK(Field3),0,1)
) > 1

this will check if more than one field has value, it will return true and you can show an error

Related Solutions

[SalesForce] Validation rule to allow 15 digits only

The logic is over-complicated; the second regex returns false when there are only numbers, but you actually wanted it to return true regardless. You can simplify this formula to:

OR( LEN(custom_text_field__c) <> 15, NOT(REGEX(custom_text_field__c,"^[0-9]+$")))

If you want to allow blank values, you need to add that in, too:

AND(NOT(ISBLANK(custom_text_field__c)),
OR( LEN(custom_text_field__c) <> 15, NOT(REGEX(custom_text_field__c,"^[0-9]+$"))))

[SalesForce] Prior Value in validation rule to find previous lookup field value

If I understand you correctly, you have 2 objects, and the Lookup from the child to the parent is called Lookup_Field__c.

If that is the case, an easy way to achieve what you are looking for would be to

create a checkbox formula field in your child object Parent_Object_Protected_State__c that references the value you want to check (ISPICKVAL(Lookup_Field__r.State__c,'NY'))
Use the validation Rule AND(ISCHANGED(Lookup_Field__c), PRIORVALUE(Parent_Object_Protected_State__c))

You could as an alternative create a text formula field and check the state in the validation rule, but then you will have to play with TEXT() function

Best Answer

Related Solutions

[SalesForce] Validation rule to allow 15 digits only

[SalesForce] Prior Value in validation rule to find previous lookup field value

Related Topic