SOLVED

format phone number, remove "+1"

Go to solution
Anonymous
Not applicable

format phone number, remove "+1"

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

1 ACCEPTED SOLUTION

Accepted Solutions
Jenn_DiMaria2
Level 10

Re: format phone number, remove "+1"

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

View solution in original post

3 REPLIES 3
Jenn_DiMaria2
Level 10

Re: format phone number, remove "+1"

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

Anonymous
Not applicable

Re: format phone number, remove "+1"

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

Anonymous
Not applicable

Re: format phone number, remove "+1"

Hi Daniel

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

Rajesh Talele