I need some help with formatting phone numbers for WhatsApp messages. I'm using Pabbly to automate sending WhatsApp messages (Wati) after a Shopify purchase, but customers enter their phone numbers in different formats (with or without country codes).
So currently when I map the "customer default phone number" field to WhatsApp number in Wati, it doesn't always goes to the intended person (due to irregularities in phone number formatting)
Any tips on how to standardize phone numbers and add the correct country code automatically? if it was a google sheet, i'd add a formula like this to fix this:
=IF(LEN(A1)=10,"91"&A1,IF(LEFT(A1,2)="91",A1,IF(LEN(A1)=13,A1,"")))
Any help appreciated!
So currently when I map the "customer default phone number" field to WhatsApp number in Wati, it doesn't always goes to the intended person (due to irregularities in phone number formatting)
Any tips on how to standardize phone numbers and add the correct country code automatically? if it was a google sheet, i'd add a formula like this to fix this:
=IF(LEN(A1)=10,"91"&A1,IF(LEFT(A1,2)="91",A1,IF(LEN(A1)=13,A1,"")))
Any help appreciated!
