{"id":914,"date":"2015-05-29T17:29:02","date_gmt":"2015-05-29T16:29:02","guid":{"rendered":"http:\/\/www.myfatblog.co.uk\/?p=914"},"modified":"2015-05-29T17:36:44","modified_gmt":"2015-05-29T16:36:44","slug":"5-minute-fix-lookup-column-links","status":"publish","type":"post","link":"http:\/\/www.myfatblog.co.uk\/index.php\/2015\/05\/5-minute-fix-lookup-column-links\/","title":{"rendered":"5 Minute Fix &#8211; Lookup Column Links"},"content":{"rendered":"<p>A colleague of mine (Thank you Iain!)\u00a0posed a question to me today of how to remove the links that appear whenever you use a lookup column to another list. Sometimes this behaviour doesn\u2019t make any sense and just confuses the end user. (Microsoft.. please add a tick box when creating lookup fields to remove this!)<\/p>\n<p>My first inclination was to create a Field display template to just display the value, but a quick Bing soon found the solution buried in one of the MSDN forums. An almost as quick test proved that the solution works just nicely in Office 365 so I figured I\u2019d write it up here with some nice pictures for future reference!<\/p>\n<p>So just to be clear, I didn\u2019t come up with this solution, I\u2019m just reposting it here with pictures for the benefit of others!<\/p>\n<p>For the demo, I have a very simple list of names, with a Job Description column which pulls in from an available list of Job Descriptions.<\/p>\n<p><a href=\"http:\/\/www.myfatblog.co.uk\/images\/BlogImages\/5-Minute-FixLookup-Column-Links_F1AF\/SNAGHTML1d9f3d9.png\"><img loading=\"lazy\" decoding=\"async\" style=\"margin: 5px; border: 0px currentcolor; display: inline; background-image: none;\" title=\"SNAGHTML1d9f3d9\" src=\"http:\/\/www.myfatblog.co.uk\/images\/BlogImages\/5-Minute-FixLookup-Column-Links_F1AF\/SNAGHTML1d9f3d9_thumb.png\" alt=\"SNAGHTML1d9f3d9\" width=\"319\" height=\"239\" border=\"0\" \/><\/a><\/p>\n<p>You can see by the colour that the Job Description field is actually a link and if the user hovers over it behaves as you would expect. However clicking on that link serves no purposes at all, it just pops up another modal dialog with the Job Description displayed.<\/p>\n<p><a href=\"http:\/\/www.myfatblog.co.uk\/images\/BlogImages\/5-Minute-FixLookup-Column-Links_F1AF\/SNAGHTML1db72b8.png\"><img loading=\"lazy\" decoding=\"async\" style=\"margin: 5px; border: 0px currentcolor; display: inline; background-image: none;\" title=\"SNAGHTML1db72b8\" src=\"http:\/\/www.myfatblog.co.uk\/images\/BlogImages\/5-Minute-FixLookup-Column-Links_F1AF\/SNAGHTML1db72b8_thumb.png\" alt=\"SNAGHTML1db72b8\" width=\"481\" height=\"312\" border=\"0\" \/><\/a><\/p>\n<p>You\u2019ll agree I\u2019m sure that this serves no purpose to the user and ideally we\u2019d like to remove the behaviour. In SharePoint 2007\/2010 we could just manipulate the XSLT for the list view and in SharePoint Designer this was a really quick fix. In SharePoint 2013, we could do similar using a Field Rendering Display Template, but that involves a lot more effort than is really necessary. Instead, we just need to configure an additional field for display, and then make a couple of quick edits.<\/p>\n<p>If you go into the list settings and then look at the configuration of our Lookup Column, you can see that I\u2019ve selected the Title column to be displayed, but you can also select Title as one of the additional columns to be displayed. if we go ahead and do that, we now have two fields in the view, JobDescription and JobDescription:Title.<\/p>\n<p><a href=\"http:\/\/www.myfatblog.co.uk\/images\/BlogImages\/5-Minute-FixLookup-Column-Links_F1AF\/SNAGHTML1e02767.png\"><img loading=\"lazy\" decoding=\"async\" style=\"margin: 5px; border: 0px currentcolor; display: inline; background-image: none;\" title=\"SNAGHTML1e02767\" src=\"http:\/\/www.myfatblog.co.uk\/images\/BlogImages\/5-Minute-FixLookup-Column-Links_F1AF\/SNAGHTML1e02767_thumb.png\" alt=\"SNAGHTML1e02767\" width=\"541\" height=\"283\" border=\"0\" \/><\/a><\/p>\n<p>Back in our list settings, you now see JobDescription:Title in the field list. If you click on that version of the JobDescription column, you\u2019ll see that you can edit the display name of the field, which we can now rename to Job Description.<\/p>\n<p>Once that\u2019s done, we then edit our current view and remove the JobDescription field and leave the old JobDescription:Title field which is now displayed as Job Description WITHOUT the clickable URL behaviour.<\/p>\n<p><a href=\"http:\/\/www.myfatblog.co.uk\/images\/BlogImages\/5-Minute-FixLookup-Column-Links_F1AF\/SNAGHTML1e2b0e1.png\"><img loading=\"lazy\" decoding=\"async\" style=\"margin: 5px; border: 0px currentcolor; display: inline; background-image: none;\" title=\"SNAGHTML1e2b0e1\" src=\"http:\/\/www.myfatblog.co.uk\/images\/BlogImages\/5-Minute-FixLookup-Column-Links_F1AF\/SNAGHTML1e2b0e1_thumb.png\" alt=\"SNAGHTML1e2b0e1\" width=\"442\" height=\"339\" border=\"0\" \/><\/a><\/p>\n<p>There\u2019s a couple of little gotchas though, You can\u2019t rename the additional column to a reserved or existing field name, which is why you\u2019ll see that I added the original JobDescription field without a space (Which of course you should all be doing anyway to avoid Internal Name Pain!)<\/p>\n<p>I hope this helps you.<\/p>\n<p>Paul.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A colleague of mine (Thank you Iain!)\u00a0posed a question to me today of how to remove the links that appear whenever you use a lookup column to another list. Sometimes this behaviour doesn\u2019t make any sense and just confuses the end user. (Microsoft.. please add a tick box when creating lookup fields to remove this!) &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"http:\/\/www.myfatblog.co.uk\/index.php\/2015\/05\/5-minute-fix-lookup-column-links\/\">Continue reading<\/a><\/p>\n","protected":false},"author":2,"featured_media":920,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[157,96,31,70,39,103],"tags":[158],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>5 Minute Fix - Lookup Column Links - Blog of an overweight SharePoint addict<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.myfatblog.co.uk\/index.php\/2015\/05\/5-minute-fix-lookup-column-links\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"5 Minute Fix - Lookup Column Links - Blog of an overweight SharePoint addict\" \/>\n<meta property=\"og:description\" content=\"A colleague of mine (Thank you Iain!)\u00a0posed a question to me today of how to remove the links that appear whenever you use a lookup column to another list. Sometimes this behaviour doesn\u2019t make any sense and just confuses the end user. (Microsoft.. please add a tick box when creating lookup fields to remove this!) &hellip; Continue reading\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.myfatblog.co.uk\/index.php\/2015\/05\/5-minute-fix-lookup-column-links\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog of an overweight SharePoint addict\" \/>\n<meta property=\"article:published_time\" content=\"2015-05-29T16:29:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2015-05-29T16:36:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.myfatblog.co.uk\/wp-content\/uploads\/2015\/05\/Feature-e1432917314764.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"269\" \/>\n\t<meta property=\"og:image:height\" content=\"201\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Cimares\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@cimares\" \/>\n<meta name=\"twitter:site\" content=\"@cimares\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Cimares\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.myfatblog.co.uk\/index.php\/2015\/05\/5-minute-fix-lookup-column-links\/\",\"url\":\"https:\/\/www.myfatblog.co.uk\/index.php\/2015\/05\/5-minute-fix-lookup-column-links\/\",\"name\":\"5 Minute Fix - Lookup Column Links - Blog of an overweight SharePoint addict\",\"isPartOf\":{\"@id\":\"http:\/\/www.myfatblog.co.uk\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.myfatblog.co.uk\/index.php\/2015\/05\/5-minute-fix-lookup-column-links\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.myfatblog.co.uk\/index.php\/2015\/05\/5-minute-fix-lookup-column-links\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.myfatblog.co.uk\/wp-content\/uploads\/2015\/05\/Feature-e1432917314764.jpg\",\"datePublished\":\"2015-05-29T16:29:02+00:00\",\"dateModified\":\"2015-05-29T16:36:44+00:00\",\"author\":{\"@id\":\"http:\/\/www.myfatblog.co.uk\/#\/schema\/person\/55ae8f6885bb5b8390dad001f3da83c6\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.myfatblog.co.uk\/index.php\/2015\/05\/5-minute-fix-lookup-column-links\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.myfatblog.co.uk\/index.php\/2015\/05\/5-minute-fix-lookup-column-links\/#primaryimage\",\"url\":\"http:\/\/www.myfatblog.co.uk\/wp-content\/uploads\/2015\/05\/Feature-e1432917314764.jpg\",\"contentUrl\":\"http:\/\/www.myfatblog.co.uk\/wp-content\/uploads\/2015\/05\/Feature-e1432917314764.jpg\",\"width\":269,\"height\":201},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/www.myfatblog.co.uk\/#website\",\"url\":\"http:\/\/www.myfatblog.co.uk\/\",\"name\":\"Blog of an overweight SharePoint addict\",\"description\":\"The rantings of a (not so) food obsessed IT consultant!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/www.myfatblog.co.uk\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"http:\/\/www.myfatblog.co.uk\/#\/schema\/person\/55ae8f6885bb5b8390dad001f3da83c6\",\"name\":\"Cimares\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/www.myfatblog.co.uk\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/www.myfatblog.co.uk\/images\/BlogImages\/About_D057\/TopOfTheWorld.jpg\",\"contentUrl\":\"http:\/\/www.myfatblog.co.uk\/images\/BlogImages\/About_D057\/TopOfTheWorld.jpg\",\"caption\":\"Cimares\"},\"sameAs\":[\"http:\/\/www.myfatblog.co.uk\"],\"url\":\"http:\/\/www.myfatblog.co.uk\/index.php\/author\/reginald\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"5 Minute Fix - Lookup Column Links - Blog of an overweight SharePoint addict","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.myfatblog.co.uk\/index.php\/2015\/05\/5-minute-fix-lookup-column-links\/","og_locale":"en_US","og_type":"article","og_title":"5 Minute Fix - Lookup Column Links - Blog of an overweight SharePoint addict","og_description":"A colleague of mine (Thank you Iain!)\u00a0posed a question to me today of how to remove the links that appear whenever you use a lookup column to another list. Sometimes this behaviour doesn\u2019t make any sense and just confuses the end user. (Microsoft.. please add a tick box when creating lookup fields to remove this!) &hellip; Continue reading","og_url":"https:\/\/www.myfatblog.co.uk\/index.php\/2015\/05\/5-minute-fix-lookup-column-links\/","og_site_name":"Blog of an overweight SharePoint addict","article_published_time":"2015-05-29T16:29:02+00:00","article_modified_time":"2015-05-29T16:36:44+00:00","og_image":[{"width":269,"height":201,"url":"https:\/\/www.myfatblog.co.uk\/wp-content\/uploads\/2015\/05\/Feature-e1432917314764.jpg","type":"image\/jpeg"}],"author":"Cimares","twitter_card":"summary_large_image","twitter_creator":"@cimares","twitter_site":"@cimares","twitter_misc":{"Written by":"Cimares","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.myfatblog.co.uk\/index.php\/2015\/05\/5-minute-fix-lookup-column-links\/","url":"https:\/\/www.myfatblog.co.uk\/index.php\/2015\/05\/5-minute-fix-lookup-column-links\/","name":"5 Minute Fix - Lookup Column Links - Blog of an overweight SharePoint addict","isPartOf":{"@id":"http:\/\/www.myfatblog.co.uk\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.myfatblog.co.uk\/index.php\/2015\/05\/5-minute-fix-lookup-column-links\/#primaryimage"},"image":{"@id":"https:\/\/www.myfatblog.co.uk\/index.php\/2015\/05\/5-minute-fix-lookup-column-links\/#primaryimage"},"thumbnailUrl":"http:\/\/www.myfatblog.co.uk\/wp-content\/uploads\/2015\/05\/Feature-e1432917314764.jpg","datePublished":"2015-05-29T16:29:02+00:00","dateModified":"2015-05-29T16:36:44+00:00","author":{"@id":"http:\/\/www.myfatblog.co.uk\/#\/schema\/person\/55ae8f6885bb5b8390dad001f3da83c6"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.myfatblog.co.uk\/index.php\/2015\/05\/5-minute-fix-lookup-column-links\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.myfatblog.co.uk\/index.php\/2015\/05\/5-minute-fix-lookup-column-links\/#primaryimage","url":"http:\/\/www.myfatblog.co.uk\/wp-content\/uploads\/2015\/05\/Feature-e1432917314764.jpg","contentUrl":"http:\/\/www.myfatblog.co.uk\/wp-content\/uploads\/2015\/05\/Feature-e1432917314764.jpg","width":269,"height":201},{"@type":"WebSite","@id":"http:\/\/www.myfatblog.co.uk\/#website","url":"http:\/\/www.myfatblog.co.uk\/","name":"Blog of an overweight SharePoint addict","description":"The rantings of a (not so) food obsessed IT consultant!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/www.myfatblog.co.uk\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"http:\/\/www.myfatblog.co.uk\/#\/schema\/person\/55ae8f6885bb5b8390dad001f3da83c6","name":"Cimares","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/www.myfatblog.co.uk\/#\/schema\/person\/image\/","url":"http:\/\/www.myfatblog.co.uk\/images\/BlogImages\/About_D057\/TopOfTheWorld.jpg","contentUrl":"http:\/\/www.myfatblog.co.uk\/images\/BlogImages\/About_D057\/TopOfTheWorld.jpg","caption":"Cimares"},"sameAs":["http:\/\/www.myfatblog.co.uk"],"url":"http:\/\/www.myfatblog.co.uk\/index.php\/author\/reginald\/"}]}},"_links":{"self":[{"href":"http:\/\/www.myfatblog.co.uk\/index.php\/wp-json\/wp\/v2\/posts\/914"}],"collection":[{"href":"http:\/\/www.myfatblog.co.uk\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.myfatblog.co.uk\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.myfatblog.co.uk\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.myfatblog.co.uk\/index.php\/wp-json\/wp\/v2\/comments?post=914"}],"version-history":[{"count":4,"href":"http:\/\/www.myfatblog.co.uk\/index.php\/wp-json\/wp\/v2\/posts\/914\/revisions"}],"predecessor-version":[{"id":921,"href":"http:\/\/www.myfatblog.co.uk\/index.php\/wp-json\/wp\/v2\/posts\/914\/revisions\/921"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.myfatblog.co.uk\/index.php\/wp-json\/wp\/v2\/media\/920"}],"wp:attachment":[{"href":"http:\/\/www.myfatblog.co.uk\/index.php\/wp-json\/wp\/v2\/media?parent=914"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.myfatblog.co.uk\/index.php\/wp-json\/wp\/v2\/categories?post=914"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.myfatblog.co.uk\/index.php\/wp-json\/wp\/v2\/tags?post=914"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}