4

I am trying to write a formula field which will pick the Owner name ... but currently the id is being displayed in the formula field. Is thr any way to capture this

can plz anyone help me... Thanx in advanced

2 Answers 2

4

You can try do the following, which will get the First and Last Name.

Owner:User.FirstName & ' ' & Owner:User.LastName

I got a Field Name does not exist error when I tried to do Owner:User.Name

1
  • no it is giving me wrong answer but ya i made it by Owner.FirstName & ' ' & Owner.LastName
    – Tanmay
    Mar 2, 2015 at 13:36
5

Owner is a tricky field because on some objects (like Case or any custom object) it's a polymorphic field, meaning that it can refer to either a User or a Queue. On others (like Account), only Users can be owners.

So it will be one of the following.

Not polymorphic:

User.FirstName & " " & User.LastName

Polymorphic, not using Queues:

Owner:User.FirstName & " " & Owner:User.LastName

Polymorphic, using Queues. This checks whether Owner:Queue.Id is empty: if it is, then the owner is a User and it returns the user's name; otherwise, the owner is a Queue and it returns the queue's name.

IF( 
  ISBLANK(Owner:Queue.Id),
  Owner:User.FirstName & " " & Owner:User.LastName,
  Owner:Queue.QueueName
)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.