+ Start a Discussion
nickfs92840nickfs92840 

Account ID showing up on field

 

 

 

Have a custom object name "Overview", created a new custom field data type "formula" named Account. The Account field is being pulled from another custom object "Highlight". Below is my formula:

 

Highlight__r.Account__c

 

However, when pulling the fied into the Overview field, i get the ID format instead (see screenshot: http://cl.ly/HXhM). 

 

Is there any way I can get it to show the text instead of the ID? 

 

Thanks!

Best Answer chosen by Admin (Salesforce Developers) 
Steve MolisSteve Molis

Hi Nick, you need to select Account>Name not Account

All Answers

Steve MolisSteve Molis

Hi Nick use the insert field button in the formula builder to navigate through the lookup field to the account name field, like this: 

 Account__r.Name

 

nickfs92840nickfs92840

Hi Steve, when I input that formula, I get this error. Click on this link

 

 

Steve MolisSteve Molis

Hi Nick, did you use the Insert Field button on the Formula Builder to navigate thru the Lookup Field to the Account Name field? 

 

Can you post a screenshot of you Formula from the Formual Builder and the Insert Field Mapping you used?

 

How many beers do you owe me now???

nickfs92840nickfs92840

Check it out, click here

 

my API name has changed but still does not work.

Steve MolisSteve Molis

You're almost there, you need to click on Account> and get the Account Name

nickfs92840nickfs92840

tried that but the field content goes blank.

 

click here

nickfs92840nickfs92840

Help! cough cough :)

 

 

Steve MolisSteve Molis

Hi Nick, you need to select Account>Name not Account

This was selected as the best answer
nickfs92840nickfs92840

Here's what the Formula looks like:

 

Highlight__r.Account__r.Name

 Thanks Stevemo!