workflow to correct phone number format

Highlighted
Occasional Contributor

hi all.

currently we capture Phone Number or Mobile Phone Number in format 04xx xxx xxx.

 

we are looking to utilise the new caller ID function on our mobile devices, and from my understanding the format must replicate country code then number IE +61 4xx xxx xxx.

 

Just wondering if it would be possible to create a workflow to add the +61 and drop the first zero?

2 Replies 2
Highlighted
Advisor | Platinum Partner

Hi @Ace123 

 

I don't believe Hubspot workflows will be able to handle this formatting task for you but integrations such as Zapier (modify number formatsor Insycle (likely more straightforward) can likely do the trick.


Did my post help answer your query? Help the Community by marking it as a solution.

Matthew Shepherd

An Inbound Growth Agency
Platinum HubSpot Partner

Highlighted
Occasional Contributor

Run into this before - not sure how many contacts you have in your CRM - but it probably easiest to just export them all - use Excel formulas to update the field then reimport.