Custom SFDC Text field being translated to ID field on the Marketo side | Community
Skip to main content
Nina_Valtcheva5
Level 4
Jul 17, 2018 10:08 PM UTC
Solved

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

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.
Grégoire_Miche2
Grégoire_Miche2Accepted solution
Level 10
Jul 17, 2018 10:47 PM UTC

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

3 replies

Grégoire_Miche2
Grégoire_Miche2Accepted solution
Level 10
Jul 17, 2018 10:47 PM UTC

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

Translate
Nina_Valtcheva5
Level 4
Jul 18, 2018 3:38 PM UTC

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

Translate
Grégoire_Miche2
Level 10
Jul 18, 2018 8:17 PM UTC

You are welcome.

-Greg

Translate