Syncing to User Lookup Fields in SFDC

Question

We have a custom user lookup field in our Salesforce environment.  That field is integrated with our Marketo environment.  In Salesforce, that field shows the user's name, but in Marketo, the user ID is populated.  Is this a normal/expected outcome?  Is there a way to have the user's name populate without having to create a formula field in SFDC?

Oz_Platero · Accepted Answer

Hello @jace_garside1

Is this a normal/expected outcome?

Yes, when connecting tables the default way it to use Foreign Keys and Primary keys so that is why you see an integer.

Is there a way to have the user's name populate without having to create a formula field in SFDC?

Yes, try the following to output a name (text) value: https://developer.salesforce.com/forums/?id=906F0000000AxcXIAS

Jace_Garside1 · Answer

Based on the conversation below, looks like a formula field is required to populate the user display name in Marketo. https://nation.marketo.com/message/130611#comment-130611

Sign up

Login with SSO

Login to the community

Login with SSO