Phone Column Type accepting character

Does anyone notice that the phone column type accepting letters? what is the best way to validate phone number field to prevent all the letters, or symbols.

Does the following validation in the valid_if help for a 10 digit phone number entered as continuous string of 10 digits.

AND(NUMBER([_THIS])>=1000000000, LEN([_THIS])=10)

3 Likes

@Suvrutt_Gurjar this is simply genius.

1 Like

I want the same result but the number is an extension so it can be anywhere between single to 4 digits please let me know how to do this.

Thank you!! :pray: :blush:

Could you update if you have tried any expressions?

1 Like

This works for 10 digit mobile numbers but I have number which is an extension number so it can be anywhere between single to 4 digits what will be the expression in that case?

please let me know.

Maybe

AND(NUMBER([_THIS])>0, LEN([_THIS])<=4)

2 Likes