Format Phone as 9 digits

[flxaryaman]

How can I format a "phone" column so that it can only contain 9 digits?

[Suvrutt_Gurjar · Accepted solution]

You could start with something like 

AND(LEN([_THIS])=9,NUMBER([_THIS])>=100000000) 

in the valid_if of the phone column. This assumes the number is only numeric and the first digit cannot be 0. You may need to add other conditions based on how the phone numbers are in your country,

[Suvrutt_Gurjar · Accepted solution]

You could start with something like 

AND(LEN([_THIS])=9,NUMBER([_THIS])>=100000000) 

in the valid_if of the phone column. This assumes the number is only numeric and the first digit cannot be 0. You may need to add other conditions based on how the phone numbers are in your country,

[flxaryaman]

Perfect, thank you
how the phone numbers are in your country?
This is the form, but could a format be added where the value of the country was entered, for example, +34 986303030, and could these two requests coexist, the nine-digit one or this new format?
(sorry my english, because i am using the google translate)

[Suvrutt_Gurjar]

You may want to add another column for that purpose called say [Country Code] with a suitable valid_if. But it can get a bit complex depending on how the dialing is required in devices in your country and what countries you would like to call. ISD dialing codes are anywhere from 1 to 6 digits and with or without hyphen.

You could then combine country code and phone column in yet another phone column.

Other community colleagues may share their insights to better handle country code as well.

[JSO]

¿No sería suficiente definirlo como Número y 9 dígitos? Si uno empieza con 0, no te sirve de nada.You can put Maximum value: 999999999 and Minimum value: 100000000

[Suvrutt_Gurjar]

Yes, one can make it just number. But I think advantage with phone type column is it can be made callable and textable in detail and summary views.🙂 Which is not possible with just a number type column.

[flxaryaman]

I didn't explain well in the answer.
The phone number format in Spain is:
123456789
34123456789
Could a formula be made that includes these two formats?

[Suvrutt_Gurjar · Accepted solution]

---

@flxaryaman wrote:

The phone number format in Spain is:
123456789
34123456789
Could a formula be made that includes these two formats?

---

Please try in the valid_if

OR(

AND(LEN([_THIS])=9,NUMBER([_THIS])>=100000000) ,

AND(LEN([_THIS])=11,NUMBER([_THIS])>=34100000000)

)

Edit: Made one minor change in the condition. Changed it from 34000000000 to 34100000000

[flxaryaman]

Very thankful

[JSO]

You're right. That is a very important characteristic.