+ Start a Discussion

Cross Object formula in fields

I want to populate some lookup fields based on selection of value in other lookup fields...
I tried to autopopulate lookup field (some person name) based on some other lookup field... this is the formula... Apps__r.Business_person__c
But in the detail page it displays values like: ythhWFv12GD... why so? It should display person name..
Hello Snehak,

Can you share your formula for better understanding? Are you using triggers for this functionality or you are using workflows for this?
I am writing formula in formula field. I modified the formula... It is displaying the name correctly now.
HYPERLINK( App__r.person_contactname__r.Id,  App__r.person_contactname__r.FirstName & " " &  App__r.person_contactname__r.LastName )

I am facing another issue. When I click on the person name, it does not navigate to that user record. Rather it shows the current record itself. Any solutions?