You need to sign in to do that
Don't have an account?
SV M
Validate phone number field to accept only numbers
Hi, I would like to validate the phone number field to accept only numbers except zeros.
Acceptable : 9987541452
Not Acceptable : 9010058471
Can someone help me achieve the functionality...
Thanks in advance...
Acceptable : 9987541452
Not Acceptable : 9010058471
Can someone help me achieve the functionality...
Thanks in advance...
Greetings!
You can use the below formual on the validation rule to avoid any other texts and zeros.
OR(NOT(REGEX(MobilePhone,"^[a-zA-Z0-9]*$")),REGEX(MobilePhone,"^[0]*$"))
You can replace the MobilePhone field with the field name of your field.
Kindly mark it as best answer if it helps so that it can help others in the future.
Warm Regards,
Shirisha Pathuri
If you find this information helpful, please mark this answer as Best. It may help others in the community. Thank You!
Anudeep
I've already tried your validation rule but it's not even accepting numbers (1-9)...