I have two lists: List B has two columns called [name] and [link] (both single line of text). E.g.:
Name: Google Link: www.google.com
In list A I want a look-up to the values in list B. So I added [name] and [name:link] as lookup columns. But essentially I want to display the hyperlink to www.google.com as Google.
If these were normal list columns, I could simply create a calculated column with:
But as [name] and [name:link] are lookup columns, I can not use them within a calculated column. I also tried to create a designer workflow, but filling out a calculated field or a hyperlink field did not do the trick.
Besides CSR, is there a different way around it?