AnsweredAssumed Answered

format phone number, remove "+1"

Question asked by 102ab804232b1e12e84d988f4a2f35d76f2b6b88 on Aug 6, 2016
Latest reply on Aug 8, 2016 by 15142a9527862a8049b3391154c47bd9d731620c

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?