+ Start a Discussion
HNT_NeoHNT_Neo 

Convert ID to Text from formula

Hello, 

I created a custom formula text field in the opportunity object called, MAS__c.

It should pull the first name and last name referenced to the User object. But what i get is the 15 digit ID vs the text name. 

This is the formula syntax I used in the MAS__c formula text field: 
 
$User.MAS__c

Any idea on how to do this via a formula or process builder? 

I tried process builder but not sure what the syntax would be and my attempt was to create a custom field MASda__c, then populate it using the User object:
[Opportunity].MASda__c = $User.FirstName

 
Murali AnandampillaiMurali Anandampillai
Hi,

If you want to display the firstname of the user who has logged in currently.

Create a formula field using the formula provided below.

$User.FirstName

The same formula should work in Process Builder as well.

Thanks,
 
HNT_NeoHNT_Neo
Thanks for the quick reply, however, MAS__c contains the name of a user assigned to the User object. 

MAS__c renders as first name and last name when you are in the user page. 

But my formula renders the ID instead of the First Name and Last Name. 
HNT_NeoHNT_Neo
This is what the custom field, MAS, looks like on the User object:

User-added image
swati_sehrawatswati_sehrawat
User-added image

Instead of refering $User, find the field under object and then use it, as attached in the screenshot.
HNT_NeoHNT_Neo
Hello,

I'm not trying to locate the user's first / last name, but a user's first / last name that is on the user object in the custom field MAS__c. 

MAS__c is pulling in as a 15 character ID, but is related to the user object via a hiereachy as shown in the previous screen shot. 

Thanks!
Murali AnandampillaiMurali Anandampillai
Hey,

The reason why you are getting the 15 character ID is because Mas__c is of type Hierarchy.

 try using User__r.Mas__r.FirstName(I am not sure if this is is going to work.Let me know)

Thanks,
Murali AnandampillaiMurali Anandampillai
or try using $User.Mas__r.FirstName