{"id":1011,"date":"2012-02-13T09:46:53","date_gmt":"2012-02-13T09:46:53","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=1011"},"modified":"2012-02-13T09:46:53","modified_gmt":"2012-02-13T09:46:53","slug":"remove-hyperlink-from-list-column-based-on-value-in-other-column","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/02\/13\/remove-hyperlink-from-list-column-based-on-value-in-other-column\/","title":{"rendered":"Remove hyperlink from list column based on value in other column"},"content":{"rendered":"<p>We can create List objects for CRM entities and add them to custom pages to load on specific tab. We can link list columns to existing entities or custom pages using Hyperlink to or custom junk functionalities available in List editing feature. However we came across the requirement where hyperlink on person name needed to be disabled based on the status value of list entity record. Please refer the screenshot below.<br \/>\n<a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/02\/untitled.jpg\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-1012\" title=\"List\" src=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/02\/untitled.jpg\" alt=\"\" width=\"1172\" height=\"193\" \/><\/a>We can see the hyperlink on person name for the status Approved. Clicking this hyperlink opens the new pop up window in which you can see the summary page for that particular entity record, however when status is Submitted the hyperlink needed to be disabled. Below is the client side script we had designed to achieve the functionality.<br \/>\n<em>function RemoveUserHyperlink(oMyGrid)<\/em><br \/>\n<em>{<\/em><br \/>\n<em>if(oMyGrid)<\/em><br \/>\n<em>{<\/em><br \/>\n<em> var rowNum =1<\/em><br \/>\n<em> var rowElem<\/em><br \/>\n<em> while (rowNum &lt; oMyGrid.rows.length)<\/em><br \/>\n<em> {<\/em><br \/>\n<em> rowElem = oMyGrid.rows[rowNum];<\/em><br \/>\n<em> \/\/to get the fourth row values<\/em><br \/>\n<em> LinkTo = new String(rowElem.cells[rowElem.cells.length-1].innerText);<\/em><br \/>\n<em> if(LinkTo==&#8221;Submitted&#8221;) \/\/if submitted found<\/em><br \/>\n<em> {<\/em><br \/>\n<em> \/\/to get the third row values<\/em><br \/>\n<em> LinkText = new String(rowElem.cells[rowElem.cells.length-2].innerText);<\/em><br \/>\n<em> rowElem.cells[rowElem.cells.length-2].innerText=LinkText;<\/em><br \/>\n<em> }<\/em><br \/>\n<em> rowNum++<\/em><br \/>\n<em> }<\/em><br \/>\n<em>}<\/em><br \/>\n<em>}<\/em><br \/>\nYou have to pass the grid object to this function. You can find the below article on partner community to understand how to access grid objects from client side script.<br \/>\n<a href=\"https:\/\/community.sagecrm.com\/partner_community\/b\/hints_tips_and_tricks\/archive\/2009\/07\/27\/the-clientside-of-control-of-lists-and-columns.aspx\" target=\"_blank\" rel=\"noopener\">https:\/\/community.sagecrm.com\/partner_community\/b\/hints_tips_and_tricks\/archive\/2009\/07\/27\/the-clientside-of-control-of-lists-and-columns.aspx<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>We can create List objects for CRM entities and add them to custom pages to load on specific tab. We can link list columns to existing entities or custom pages using Hyperlink to or custom junk functionalities available in List editing feature. However we came across the requirement where hyperlink on person name needed to\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/02\/13\/remove-hyperlink-from-list-column-based-on-value-in-other-column\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29,219,332],"tags":[],"class_list":["post-1011","post","type-post","status-publish","format-standard","hentry","category-asp","category-list","category-sage-crm"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Remove hyperlink from list column based on value in other column - Sage CRM \u2013 Tips, Tricks and Components<\/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.greytrix.com\/blogs\/sagecrm\/2012\/02\/13\/remove-hyperlink-from-list-column-based-on-value-in-other-column\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Remove hyperlink from list column based on value in other column - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"We can create List objects for CRM entities and add them to custom pages to load on specific tab. We can link list columns to existing entities or custom pages using Hyperlink to or custom junk functionalities available in List editing feature. However we came across the requirement where hyperlink on person name needed to\u2026 Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/02\/13\/remove-hyperlink-from-list-column-based-on-value-in-other-column\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2012-02-13T09:46:53+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/02\/untitled.jpg\" \/>\n<meta name=\"author\" content=\"greysagecrm\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagecrm\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/02\/13\/remove-hyperlink-from-list-column-based-on-value-in-other-column\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/02\/13\/remove-hyperlink-from-list-column-based-on-value-in-other-column\/\",\"name\":\"Remove hyperlink from list column based on value in other column - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/02\/13\/remove-hyperlink-from-list-column-based-on-value-in-other-column\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/02\/13\/remove-hyperlink-from-list-column-based-on-value-in-other-column\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/02\/untitled.jpg\",\"datePublished\":\"2012-02-13T09:46:53+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/02\/13\/remove-hyperlink-from-list-column-based-on-value-in-other-column\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/02\/13\/remove-hyperlink-from-list-column-based-on-value-in-other-column\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/02\/13\/remove-hyperlink-from-list-column-based-on-value-in-other-column\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/02\/untitled.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/02\/untitled.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/02\/13\/remove-hyperlink-from-list-column-based-on-value-in-other-column\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Remove hyperlink from list column based on value in other column\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\",\"name\":\"Sage CRM \u2013 Tips, Tricks and Components\",\"description\":\"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips &amp; tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\",\"name\":\"greysagecrm\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"greysagecrm\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Remove hyperlink from list column based on value in other column - Sage CRM \u2013 Tips, Tricks and Components","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.greytrix.com\/blogs\/sagecrm\/2012\/02\/13\/remove-hyperlink-from-list-column-based-on-value-in-other-column\/","og_locale":"en_US","og_type":"article","og_title":"Remove hyperlink from list column based on value in other column - Sage CRM \u2013 Tips, Tricks and Components","og_description":"We can create List objects for CRM entities and add them to custom pages to load on specific tab. We can link list columns to existing entities or custom pages using Hyperlink to or custom junk functionalities available in List editing feature. However we came across the requirement where hyperlink on person name needed to\u2026 Read More &raquo;","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/02\/13\/remove-hyperlink-from-list-column-based-on-value-in-other-column\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2012-02-13T09:46:53+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/02\/untitled.jpg","type":"","width":"","height":""}],"author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/02\/13\/remove-hyperlink-from-list-column-based-on-value-in-other-column\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/02\/13\/remove-hyperlink-from-list-column-based-on-value-in-other-column\/","name":"Remove hyperlink from list column based on value in other column - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/02\/13\/remove-hyperlink-from-list-column-based-on-value-in-other-column\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/02\/13\/remove-hyperlink-from-list-column-based-on-value-in-other-column\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/02\/untitled.jpg","datePublished":"2012-02-13T09:46:53+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/02\/13\/remove-hyperlink-from-list-column-based-on-value-in-other-column\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/02\/13\/remove-hyperlink-from-list-column-based-on-value-in-other-column\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/02\/13\/remove-hyperlink-from-list-column-based-on-value-in-other-column\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/02\/untitled.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/02\/untitled.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/02\/13\/remove-hyperlink-from-list-column-based-on-value-in-other-column\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Remove hyperlink from list column based on value in other column"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/","name":"Sage CRM \u2013 Tips, Tricks and Components","description":"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips &amp; tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f","name":"greysagecrm","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"greysagecrm"},"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/1011","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/comments?post=1011"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/1011\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=1011"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=1011"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=1011"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}