SOLVED

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

Go to solution
Nina_Valtcheva5
Level 5

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:

pastedImage_1.png

Marketo:

pastedImage_0.png

Here is the field mapping in Marketo:

pastedImage_0.png

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

1 ACCEPTED SOLUTION

Accepted Solutions
Grégoire_Miche2
Level 10

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

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

View solution in original post

3 REPLIES 3
Grégoire_Miche2
Level 10

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

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 5

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

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

Grégoire_Miche2
Level 10

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

You are welcome.

-Greg