Manage
Learn to apply best practices and optimize your operations.
Validating A Phone Number The Easy Way.
I validate a telephone number to be in the following format:
(999) 999-9999.
Put this code in the validation formula of a field. Of course replacing the
name of your field for the one in the example. It is a short and sweet
function. You can do all sorts of things with it. Use it to validate ssn #s
too. If you want to check for letters use {A-Z} or {a-z}.
@If(@Matches(PhoneNumberfield;"{(}{0-9}{0-9}{0-9}{)}
{0-9}{0-9}{0-9}-{0-9}{0-9}{0-9}{0-9}");@Success;@Failure("Please enter the
telephone number in the following format: (999) 999-9999"))
Start the conversation
0 comments