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:
and when they come back from ClickSend they look like this:
so i can use ‘numbers’ in zapier to format the phone number, but then it comes out like this:
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
anyone know how I can solve? i need to format one of them, but can’t figure out how to do it…