In my sandbox when a new lead is created its assigned to a TCC queue. Then someone from TCC team queue will accept the ownership of queue.

Now i want to see report of : who accepted how many Leads from TCC queue.

I have enabled history tracking for ownership field but since we can not filter report using the OLD or NEW value of owner, i am thinking of creating a text field to store the value of first user who accepted the ownership from TCC queue.

Is my approach correct? Any suggestions on how can i achieve this functionality.


Your approach seems correct for me. To achieve this functionality you can create a text field called Record Assigned Owner.

Then create a workflow rule and update the field when owner is changed. You can write following formula in workflow.

if(AND(OwnerId = "Queue_ID", ISBLANK(Record_Assigned_Owner__C)), OwnerId,null)

The formula is checking specific queue id and Record Assigned Owner as blank then it will update the Ownerid. You could achieve it through trigger also, but workflow approach is always preferable.

  • Hi Prabhat, Thanks for reply but i think workflow won't run after the user accepts the ownership of lead from queue. And if it is so then how that field will be updated with owner? Nov 28 '16 at 18:41
  • Also i tried workflow solution its not working Nov 28 '16 at 19:17
  • Where you are facing the problem exactly. Does the owner field is not getting update ?
    – MIX DML
    Nov 29 '16 at 8:06
  • Custom owner field is still blank : unsee.cc/gedupito Nov 29 '16 at 9:25
  • 1
    Never Mind....I found the error. (i was updating wrong field ;) ) Nov 29 '16 at 9:41

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.