+ Start a Discussion
CRMandresGCRMandresG 

how to gray out fields when a pick-list value is chosen.

On the opportunity object there is a custom picklist field (Loan_Payment_Method__c).  When a certain pick-list value (cash) is chosen I would like to have it to gray out 2 custom fields (Interest_Rate__c & Term__c) that are no longer applicable.

 

Alternativly, I could have a validation rule have Interest_Rate__c & Term__c required if anything other than 'cash' is chosen. 

 

Any help?

 

 

CRMandresGCRMandresG

Interest_Rate__c = percent data type

Term__c = number data type

 

 

SteveMo__cSteveMo__c

You could do that using Field Depenancies

SteveMo__cSteveMo__c

here you go:

AND(
TEXT(Loan_Payment_Method__c) = "Cash",
OR(
ISBLANK(Interest_Rate__c),
ISBLANK(Term__c)))