+ Start a Discussion
jvolkovjvolkov 

Primary_Contact__r Values

Has anyone had any luck using the Primary_Contact__r field values in formula fields?  They appear to all return null values even though the opportunity has a primary contact.

 

Example:  An opportunity has a primary contact selected but Primary_Contact__r.Id = null.  Would expect Primary_Contact__r.Id to equal the primary contact's Id.

sfdcfoxsfdcfox

__r means "custom relationship", just as __c means "custom field." Someone in your organization made that field, and it has no value until the lookup is populated. Using a OpportunityContactRole won't automatically fill in this custom field. You'll need a trigger to set the value. You can see this custom field under Setup > Customize > Opportunity > Fields.

jvolkovjvolkov

Ya, for some reason wasn't thinking it was a custom field.  Makes sense now.