Formatting Phone Numbers

Hi guys!

At the moment we are importing customers phone numbers from Shopify, through Integromat (like Zapier), and into Bubble. We then finally SMS clients with ClickSend. Our problem arises as Shopify saves phone numbers as text, so we have to import the numbers as text into Bubble. I then have a workflow that makes a change to a list of things;

“Numbers ClickSend” = “Numbers Shopify”:converted to numbers

Firstly, if there are any spaces in the “Numbers Shopify”, e.g. 021 543 250, it will save the new number in “Numbers ClickSend” to “21”. It stops reading after the spaces. Is there a way around that?

Secondly, I want the country code before the number, at the moment I can import a number from Shopify as “NZ021 452 525”, but want it to end up as “6421543250”.

I very much appreciate your time in reading, and answering this question! Cheers :slight_smile:

If you use the format as a phone number, it will store it without any spaces.