Phone number formatting for Australia

gday team, having an issue here which is causing havoc between airtable and zapier.

so i’m trying to use zapier to search for a record and use look up fields to compete the table.

but in my input form from airtable the phone numbers come out like this:

Screen Shot 2020-09-08 at 10.39.15 am

and when they come back from ClickSend they look like this:

Screen Shot 2020-09-08 at 10.40.48 am
:face_with_symbols_over_mouth:

so i can use ‘numbers’ in zapier to format the phone number, but then it comes out like this:

Screen Shot 2020-09-08 at 10.41.13 am

note the bracket is different - (0401) compared to (040) which is the default formatting in airtable for phone numbers.

so this means that search won’t match these records even though they are the same

:face_with_symbols_over_mouth::face_with_symbols_over_mouth::face_with_symbols_over_mouth:

anyone know how I can solve? i need to format one of them, but can’t figure out how to do it…

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.