Skip to main content
1. I have created a custom formula field on the User object. The Data Type is Auto Number. The name of this field is User_Identified__c

 

2. On the Case object I would like to create a field that displays the value of User_Identified__c

 

How can I do this? What formula would I have to write to accomplish this? Thank you for your help! 

 

 
5 answers
  1. Jan 7, 2017, 6:30 PM
    Hi Minhaj,

     

    There are two fields in the Case objects which relates to the User Object. One is the Owner field and other is the CreatedBy field. So, depending upon whether you want to fetch the User Identified value of the Owner or the CreatedBy user, your formula will differ. In either of the scenarios, you need to create of a Custom formula field of the type TEXT with one of the below formulas.

     

    If you want to fetch the User Identified value of the Owner (User), then your formula will be this

     

     

    Owner:User.User_Identified__c

     

    If you want to fetch the User Identified value of the CreatedBy (User), then your formula will be this

     

     

    CreatedBy.User_Identified__c

     

    Hope that helps !
0/9000