format phone number, remove "+1" | Community
Skip to main content
August 6, 2016
Solved

format phone number, remove "+1"

  • August 6, 2016
  • 2 replies
  • 3918 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jenn_DiMaria2

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

2 replies

August 8, 2016

Hi Daniel

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

Rajesh Talele

Jenn_DiMaria2
Jenn_DiMaria2Accepted solution
New Participant
August 8, 2016

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

August 8, 2016

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