Apex Code Development You need to sign in to do that
Don't have an account?
Bharat Seth 12 Validation Rule On Phone Field in Account or Contact
I want to create a validation rule on Phone field where Phone field can only accept numbers, brackets and dashes with numbers may or may not start with '+'. And '+' should always be leading character when it comes in the number.
I have written below validation rule but its still allowing more than one '+' character in the numbers and its not allowed. It should only be the leading character if at all its required in the number.
Someone kindly assist with this asap.
Find below my validation rule:
NOT(OR(REGEX( Phone , "[[+][0-9]\\(\\+\\)-]*"),
REGEX( Phone , "[[0-9]\\(\\+\\)-]*")))
Also I want to bypass this for System Admin Profile.
I have written below validation rule but its still allowing more than one '+' character in the numbers and its not allowed. It should only be the leading character if at all its required in the number.
Someone kindly assist with this asap.
Find below my validation rule:
NOT(OR(REGEX( Phone , "[[+][0-9]\\(\\+\\)-]*"),
REGEX( Phone , "[[0-9]\\(\\+\\)-]*")))
Also I want to bypass this for System Admin Profile.
$Profile.Name <> "System Administrator",
)
Should be included at the start of the your validation rule.
This will allow the only System Administrator.
Hope So this will Help you.
Mark Answer a closed If it helped you
Thanks