Syncing to User Lookup Fields in SFDC | Community
Skip to main content
Jace_Garside1
Level 2
May 27, 2020
Solved

Syncing to User Lookup Fields in SFDC

  • May 27, 2020
  • 2 replies
  • 3321 views

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?

Best answer by Oz_Platero

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

2 replies

Jace_Garside1
Level 2
May 27, 2020

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

Darshil_Shah1
Community Advisor and Adobe Champion
Community Advisor and Adobe Champion
May 27, 2020

This could work I believe: You can develop apex triggers to populate the custom field in sfdc that will sync back to marketo normally. 

Oz_Platero
Oz_PlateroAccepted solution
Level 6
June 8, 2020

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