function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Christine MatthewsChristine Matthews 

Auto populate a text field with the same information in a lookup field

I need to duplicate the value in a lookup field to a text field. I'm having a hard time figuring out the formula. 
Andrew GAndrew G
Hi Christine
Some examples that my help.
For a straight value simply place the name of the field in the formula 
User_Test__c
If you want to draw a value from the lookup record, something like: 
User_Test__r.Department
Or a slightly more complex verson: 
IF( 
  LEFT(OwnerId,3)=='00G', 
  Owner:Queue.QueueName , 
  IF(  
    LEFT(OwnerId,3)=='005', 
    Owner:User.FirstName + ' ' +Owner:User.LastName, 
    'N/A' 
  ) 
)

Hope the above helps
Regards
Andrew