Report returning Contact name instead of ID in a lookup field

Question

I need an opportunity report that shows a custom contact lookup fields ID instead of their name. How do I do this? Is this possible?

Jeff May · Accepted Answer

If you have a lookup(Contact) on the Opp, you can create a custom formula text field that returns the related Contact Id:   Contact__r.Id

Mayank Srivastava · Answer

Taylor, sure you can. Create a formula field on Opportunity of date type -  Text  and use the following formula: CASESAFEID( Primary_Contact__c ) Then add it to the report and you will be able to see the 18 digit Contact ID. I used a custom field of my own so you need to replace it with yours.

Report returning Contact name instead of ID in a lookup field

Reports & Dashboards

관련 학습

도움 더 받기