How to separate part of a field | Community
Skip to main content
Sarah_Way1
Level 2
May 16, 2018
Question

How to separate part of a field

  • May 16, 2018
  • 2 replies
  • 2079 views

Hello Marketo Community!

In our CRM, we track phone numbers in two fields: Area Code and Phone Number. We are in the process of integrating our text messaging program with Vibes and are running into difficulty because Vibes maps their phone numbers with the Mobile Phone Number field, housing both the area code and the phone number in one field. Is it possible to separate the two, so we can have the area code in one field and the phone number in another? We've asked both Marketo and Vibes, and each is saying that they cannot do it from their end.

Thanks for the help!

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

2 replies

Grégoire_Miche2
Level 10
May 16, 2018

Hi Sarah,

Use a webhook platform. They are very good at doing this. Search the Launchpoint for these solutions.

-Greg

SanfordWhiteman
Level 10
May 16, 2018

Love full-fledged webhook platforms but for phone data in particular, you can call the Twilio lookup API as webhook to parse and identify numbers, then map results back into individual fields. See here: Calling the Twilio Lookup API as a Marketo webhook

Grégoire_Miche2
Level 10
May 16, 2018

Hi Sandy,

Thx for the pointer to the post that I had missed.

-Greg