I am trying to update a validation rule we have for an existing page layout. We have added a new page layout that does not need to meet the requirements within this validation rule. The current validation rule is:
ISNULL(kWh_reduced__c)&&(ISPICKVAL( StageName , "Closed Won"))&& NOT(ISPICKVAL(PRIORVALUE( StageName ),"Closed Won"))
I want to add, except when the page layout is ABQ Opportunity Layout. How do I make this work?
답변 2개
Eric Praud (Activ8 Solar Energies) Forum Ambassador
Hi Tracey,
This isn't possible. However, if this page layout is on a separate record type, you can exclude a record type like so:
RecordType.Name<>"RecordTypeNameHere" && ISBLANK(kWh_reduced__c)&&(ISPICKVAL( StageName , "Closed Won"))&& NOT(ISPICKVAL(PRIORVALUE( StageName ),"Closed Won"))
Also, never use ISNULL, use ISBLANK instead. ISNULL has been deprecated over 10 years ago and could cause issues