Standardize phone number formatting on phone numbers | Data & Integrations

Standardize phone number formatting on phone numbers

Calvin Chuang

Alumni enter phone numbers vary greatly. Is there a way to have them either enter it using stricter formating or adjust the formatting once they enter it to be standardized?
Country followed by phone number formatting of that nation
US: +1 XXX-XXX-XXXX
Australia: +61 XX-XXXX-XXXX
etc

October 31, 2024

Calvin Chuang

Right now Almabase doesn't save international numbers correclty. For example if you put in an Australia number of "+61 3 9700 0000" it will save as "+61 03 9700 0000". There is no way to changes this.

So it would be nice if you could select your country code. Then the rest of the nubmers will format according to that country. For example for a US number +1 would format (XXX) XXX-XXXX and a for Japan +81 80-2552-6412

Kimberley D Bailey

As well, phone entry should not include free text just numerical. Fir example we have had alumni enter 1-123-456-7890 (direct to me) which is not recognized in RE. As well need the ability for someone to add their work phone extension, currently having to do manually

Ginu

Hello Calvin Chuang! I have a few more questions for you:

Can you provide more examples of the phone number formats for different countries that you would like to see implemented?
Are there any specific countries that are a priority for this feature?
Would you like the system to automatically detect the country based on the phone number, or should the user manually select their country?

Calvin Chuang

Hi Ginu,
Sure. Here are some examples:
United States: (123) 456-7890
Canada: (123) 456-7890
United Kingdom: +44 20 1234 5678
Australia: +61 2 1234 5678
Germany: +49 30 12345678
France: +33 1 23 45 67 89
Italy: +39 06 12345678
Spain: +34 912 34 56 78
India: +91 98765 43210
Japan: +81 3-1234-5678
Brazil: +55 11 91234-5678
Mexico: +52 55 1234 5678
South Africa: +27 21 123 4567
Russia: +7 495 123-45-67
Netherlands: +31 20 123 4567
Sweden: +46 8 123 456 78
Norway: +47 21 23 45 67
Finland: +358 9 1234567
Switzerland: +41 44 123 45 67
Belgium: +32 2 123 45 67
Austria: +43 1 23456789
Singapore: +65 9123 4567
Thailand: +66 2 123 4567
Malaysia: +60 3-1234 5678
Philippines: +63 912 345 6789
New Zealand: +64 3-123 4567
Ireland: +353 1 234 5678
Turkey: +90 212 123 45 67
Israel: +972 2-123-4567
Australia, UK, Germany, Japan, USA, Canada, Ethiopia, Kenya, Malaysia, India but ideally it would nice to generate the international codes for all even if the formatting isn't perfect.
User should manually select their country. Then the "-" between the numbers would format to what is standard for that country. So example US would be +1 (which they select) then (XXX) XXX-XXXX.