Format phone number to add country code
SOLVE
1 Accepted solution
Format phone number to add country code
SOLVEHi @JoeFromPinch,
Then it depends on how your phone numbers are formatted exactly. In Germany, for example, numbers without country code start with a 0. That 0 is removed when the country code is dialed.
E.g. 030 1234567 would turn into +49 30 1234567
I could achieve that with the workflow below:
Best regards!
| Karsten Köhler |
 | Did my post help answer your query? Help the community by marking it as a solution. |
Format phone number to add country code
SOLVEHi @JoeFromPinch,
Which HubSpot subscription are you on? In Operations Hub Professional, you can use the Format data workflow action to change the formatting of your phone number and add a country code at the beginning.
Without Operations Hub Professional, you'd have to look into third-party tools such as Insycle. (If upgrading to Operations Hub Professional is an option, let me know and I can share more use cases that can be easily implemented in this hub and improve data quality.)
Best regards!
| Karsten Köhler |
| Did my post help answer your query? Help the community by marking it as a solution. |
Format phone number to add country code
SOLVEFormat phone number to add country code
SOLVEHi @JoeFromPinch,
That depends on where the information about the country code lives. Do you have that in a separate property? What would determine which country code is added at the beginning of a phone number?
Best regards
| Karsten Köhler |
| Did my post help answer your query? Help the community by marking it as a solution. |
Format phone number to add country code
SOLVEFormat phone number to add country code
SOLVEHi @JoeFromPinch,
Then it depends on how your phone numbers are formatted exactly. In Germany, for example, numbers without country code start with a 0. That 0 is removed when the country code is dialed.
E.g. 030 1234567 would turn into +49 30 1234567
I could achieve that with the workflow below:
Best regards!
| Karsten Köhler |
| Did my post help answer your query? Help the community by marking it as a solution. |
Format phone number to add country code
SOLVE
Format phone number to add country code
SOLVEHi @teloss79,
Thank you for reaching out to the Community!
Here are some resources that might be of interest as well:
- Format your data with workflows
- Custom Formula Functions
@karstenkoehler thank you for your help!
Could you please explain how the workflow you suggested would work with additional "0" within the phone number to help @teloss79, please?
Thanks a lot!
Have a great day!
Best,
Bérangère
 | Saviez-vous que la Communauté est disponible en Français ? Rejoignez les discussions francophones en changeant votre langue dans les paramètres ! Did you know that the Community is available in other languages? Join regional conversations by changing your language settings! |
Format phone number to add country code
SOLVEFormat phone number to add country code
SOLVEFormat phone number to add country code
SOLVEHi @JoeFromPinch,
Happy to help. Make sure to test this first by copying the formatted phone number into another custom property. Search and replace actions can be hard to clean up if you're doing something wrong (e.g. searching all space characters in a word document and replacing them with nothing).
When everything looks good in the test property, you can unleash your workflow on the actual thing.
Best regards
| Karsten Köhler |
| Did my post help answer your query? Help the community by marking it as a solution. |
