Custom SFDC Text field being translated to ID field on the Marketo side | Community
Skip to main content
Nina_Valtcheva5
Level 4
July 17, 2018
Solved

Custom SFDC Text field being translated to ID field on the Marketo side

  • July 17, 2018
  • 1 reply
  • 2523 views

Wondering if anyone else has experienced this and how to get around it. I've seen it come up on 2 different fields now where they are created as custom text fields in SFDC but in Marketo the values get translated to 18 Digit ID values for some reason.

SFDC:

Marketo:

Here is the field mapping in Marketo:

Any ideas why this is happening and how to get the actual text value to populate? Is it a setting on the SFDC side somewhere or on the Marketo side?

Thanks,

Nina

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 Grégoire_Miche2

Hi Nina,

this field is a lookup towards another object and contains the ID of the related object instance. This is expected behavior.

To work around this, you will need a formula field that copies the value of the name.

-Greg

1 reply

Grégoire_Miche2
Grégoire_Miche2Accepted solution
Level 10
July 17, 2018

Hi Nina,

this field is a lookup towards another object and contains the ID of the related object instance. This is expected behavior.

To work around this, you will need a formula field that copies the value of the name.

-Greg

Nina_Valtcheva5
Level 4
July 18, 2018

Thanks, Greg! Makes perfect sense now. I'm having our SFDC admins create the formula field.

Grégoire_Miche2
Level 10
July 18, 2018

You are welcome.

-Greg