+ Start a Discussion
anillllanillll 

Look Up Formula Fields

I Have two Objects Product_Master__c and Order_Product__c,in Order_Product__c i have given look up to Product_Master__c ,,,,,,,i want to get look up fields of  Product_Master__c in Order_Product__c...........i am getting the value but its in id form how can i get it in text type

KapilCKapilC

Anil,

 

What do you mean by "Text Type" ? As far as i understood when you are writing Product_Master__c it's giving you salesforce id but you need it's name let say samsung is product name and its sfdc id is 0v56XXXXXX. So do you want "samsung"?

PrabhaPrabha
It should be easy with Formula field.

create formula fields of type text, and do something like this ...
"Product_Master__c__r.lookuponproductmaster__r.Name"

"Name" is just the field name inside the third object, u can get anything instead of Name.

HTH
Prabhan
RockDeveloperRockDeveloper

While Referncing that lookup field use like that RefernceobjectName.Name.

You will get Name..