Skip to main content
Jeremy Whittington (Thinkaholics) 님이 #Formulas에 질문했습니다

Hello all,

I've created a custom field called "Case_Queue__c" on the Case object. I want the field to display the name of the Queue the case is currently assigned to.

I thought I could use a formula on text field but it's not working:

IF( Owner:Queue.Id <> null, Owner:Queue.QueueName, "No Value" )

What am I missing, please?

Thank you,

B
답변 3개
  1. 2019년 10월 25일 오전 4:20
    IF( LEFT( OwnerId ,3) = "00G", Owner:Queue.Name, "Not Queue")

    Remember the OwnerId field can contain either a User or a Queue.  So we test for the prefix for Queues (00G), and if it is a Queue, drive to the Queue name via the lookup field.

    Regards

    Andrew

     
0/9000