function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
VK86VK86 

Formula Field Help

Hello All,

 

I have created a formula field on Lead which evaluates to CreatedBy.EmployeeNumber

 

I want the field to show record owners' Employee Number but couldnt find a way to do this.

Any help in suggesting how to do this is much appreciated.

 

Thanks much!

VK86VK86

I have found a temporary solution to this issue.

 

I used the following formula to meet the requirement:

 

IF( OwnerId = "00Q7000000Mi6Tf", "005",

IF( OwnerId = "00Q7000000Np4Us", "007", null))

 

Hope this helps to other facing same problem.

 

Thanks,

VK86

ahab1372ahab1372

the problem is that a lead owner can be a user or a queue, and queues do not have all the fields that users have. That makes all the fields unavailable in formulas which really is annoying.

Only way to do what you want is to create a trigger that updates the field with the employee number.

VK86VK86

Thanks for your reply ahab1372!

 

In this case, i am not using any queue as a lead owner.

 

Yes, using a trigger to update the Employee number field is the solution when using Queues as lead owners.

 

Thanks,

VK86