=============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.
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