format phone number, remove "+1"

[Anonymous]

Hey Marketo community,

We have an integration setup between Marketo and Facebook Lead Ads so that when someone submits through a Facebook Lead ad form, a Marketo Lead record is either created or updated. These Facebook Ad forms include a phone number field. Those who submit through these forms don't include "+1" before the phone number field value, but these records are created/updated in Marketo with +1 proceeding the phone number value, causing issues for us in SFDC.  Is there a way to reformat these field values and remove "+1" from each record's phone number?

Daniel

[Jenn_DiMaria2 · Accepted solution]

You could potentially use an Excel formula in Marketo (the webhook is available for free). See this article: Using Formulas in Marketo

[Anonymous]

Thank you so much, Jennifer! That worked like a charm. I'm going to explore other products offered by Hoosh as well.

[Anonymous]

Hi Daniel

Check out BrightHooks.com. There might be something there that might be useful for your journey to Marketo mastery.

Rajesh Talele