You need to sign in to do that
Don't have an account?
HNT_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:
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:
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
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,
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.
Instead of refering $User, find the field under object and then use it, as attached in the screenshot.
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!
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,