Link in a formula text field – Explained with Use Case

Use Case:I have three objects-·         Application User·         Bank·         Credit Card.Application User is having master detail relationship with both Bank and Credit Card where in both the cases Application User is on the master side and Bank/Credit Card are on the details side.Schema is as below –Now when I click on the Credit Card tab, I would like to display the Application User’s detail in the list. So I need to credit a new view to include the Application User detail. I did that (View Name: All Credit Card)and below is what I can see-Now the problem is – with the above view, from “Credit Card Holder” column, I am not able to identify the Application User. I need to click on individual “Credit Card Holder” entry to go to the details page of the Application User object and then identify the user. OMG!!! Definitely not a good and efficient way. We have to be smart. So let’s think about something innovative –Why not display the “LastName, FirstName” in the Credit Card Holder column so that from this page only, I can understand the owner of the Credit Card. Great good idea. Let’s see how we can do that –Let’s create a formula field which will fetch the Application User’s LastName and FirstName and populate like below-Now let’s add the field in the previously created view i.e. All Credit Card....

Read More