We currently use Marketing Cloud for emails and are considering using it for SMS in future. I've been told I need phone numbers in the following format in our CRM for it to work with MobileConnect: dialling code and phone number, e.g. 44123456789.
Is there a way to format all phone numbers in our CRM to this? So even if someone submits their phone number through our website as 07123456789, Salesforce will change it to 447123456789?
I'd prefer to do the formatting in Salesforce or MarketingCloud to be honest so as not to mess up to UX of our website.
If you want to just block incorrect values, Validation Rule on that field will be enough.
If you want to correct it, depending on what can be inserted you can either use Apex Trigger with logic: https://trailhead.salesforce.com/ja/trailblazer-community/feed/0D54S00000A8pj6SAB or 3rd party tool with all bells and whistles: https://appexchange.salesforce.com/appxListingDetail?listingId=a0N3000000DpUDTEA3
