Thursday, 19 February 2015

VALIDATION RULES REALTIME SCENARIOS

=============VR====================
ISCHANGED(Aadhar_Card__c),
IF(ISPICKVAL(Aadhar_Card__c ,"Yes"),

OR(ISBLANK(Aadhar_Card_No__c),LEN(TRIM(Aadhar_Card_No__c) )<> 12) , NOT(ISBLANK(Aadhar_Card_No__c)))

Error::1) Please enter Aadhar card No.
2) Please Enter Valid Aadhar card No.
3) If 'Aadhar card No.' is entered then select 'Aadhar card' as 'yes'.

=======================================
ISPICKVAL(Aadhar_Card__c,"Yes") &&
ISBLANK(Aadhar_Card_No__c)

Error::Please enter Aadhar Card No

======================================
ISCHANGED( Name )

Error::You are not allowed to change the Client Name
=========================================
CONTAINS( TRIM(Full_Present_Address__c) , "|"))

Error::Address should not contain "|" symbol

===========================================
OR
(
Age1__c < 21,
Age1__c > 58
)

Error::Age of primary customer should be between 21 - 58 years

================================================
OR(AND( ISNEW() || ISCHANGED(Address_Proof__c) ,ISPICKVAL( Address_Proof__c , "Bank Passbook"),AND(LEN( Address_Proof_No__c )>18,NOT(REGEX( Address_Proof_No__c , "(\\d{18})?")))
),
),
    (AND
        (ISPICKVAL( Address_Proof__c , "Bank Passbook") , ISBLANK( Address_Proof_No__c))
    )
  )

  Error::Pass book number should be alphanumeric and cannot be greater than 18 digits.

No comments:

Post a Comment