You need to sign in to do that
Don't have an account?
WonderfulStar
Help with Validation Rule needed...
Hi if anyone can help with creation of a validation rule that ensures the first 3 digits are "INV" and the last 5 digits are numerical only it would be great. Below is what I created so far however it doesn't ensure the last 5 are numerical.
NOT(
OR(
ISBLANK( X4D_Invoice__c),
LEN( X4D_Invoice__c) = 8,
LEFT(X4D_Invoice__c,3 ) = "INV"))
I haven't got time to bang out a VR Formula right now, but what you want is a REGEX Function.
https://help.salesforce.com/apex/HTViewHelpDoc?id=customize_functions.htm&language=en
https://help.salesforce.com/apex/HTViewHelpDoc?id=fields_useful_field_validation_formulas.htm&language=en
All Answers
I haven't got time to bang out a VR Formula right now, but what you want is a REGEX Function.
https://help.salesforce.com/apex/HTViewHelpDoc?id=customize_functions.htm&language=en
https://help.salesforce.com/apex/HTViewHelpDoc?id=fields_useful_field_validation_formulas.htm&language=en
Thanks so much this worked great! Unfortunately I could not access the help files so I just tested in my DEV environment.