{"id":7749,"date":"2014-05-03T05:54:44","date_gmt":"2014-05-03T05:54:44","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=7749"},"modified":"2022-02-25T10:07:54","modified_gmt":"2022-02-25T10:07:54","slug":"sage-crm-7-2-client-side-api-manipulate-list-block-columns","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/05\/03\/sage-crm-7-2-client-side-api-manipulate-list-block-columns\/","title":{"rendered":"Sage CRM 7.2 Client Side API Manipulate List Block Columns"},"content":{"rendered":"<p>Grid customizations in Sage CRM are bit time consuming and sometimes need complex coding. But with Sage CRM client side API it has become much easier to work with grid customizations. One of our clients came up with requirement that there should not be an hyperlink on <b>Quote Items<\/b> grid. Now, this hyperlink is not set by using <b>Hyperlink To<\/b> in list customization so that we can change and remove the hyperlink.<\/p>\n<p><strong><span style=\"color: #993300;\"><em>Related Post: <\/em><\/span><\/strong><a title=\"SageCRM 7.2 URL parameters through Client Side API\" href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/04\/11\/sagecrm-7-2-url-parameters-through-client-side-api\/\" target=\"_blank\" rel=\"noopener\">SageCRM 7.2 URL parameters through Client Side API<\/a><\/p>\n<p>This can be achieved by using client side API <b>exec<\/b> function. This executes a function on each of selected cell. This function will get text of the cell and will set it as HTML. Again, there are two methods named <b>getCellText<\/b> and <b>setCellHtml<\/b> which can be used to get text of the cell and set it as html.<br \/>\nHere is the script I have written to remove hyperlink as mentioned above.<br \/>\n<em>&lt;snippet&gt;<\/em><br \/>\n<em>var indexOfColumn = 1;<\/em><br \/>\n<em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 crm.grids(&#8220;0&#8221;).rows().cells(indexOfColumn).exec(function (index, key) {<\/em><br \/>\n<em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 var rowIndex = $(key).parent().index() &#8211; 1; \/\/This is used to get the row index of the cell. $(key) = the current cell<\/em><br \/>\n<em>\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \/\/&#8217;Get CellText and Set it as CellHtml<\/em><br \/>\n<em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 crm.grids().column(&#8216;prod_name&#8217;).setCellHtml(rowIndex, crm.grids().columnIndex(&#8220;prod_name&#8221;), crm.grids().getCellText(rowIndex, crm.grids().columnIndex(&#8220;prod_name&#8221;)));<\/em><br \/>\n<em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 });<\/em><br \/>\n<em>\u00a0&lt;\/snippet&gt;<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Grid customizations in Sage CRM are bit time consuming and sometimes need complex coding. But with Sage CRM client side API it has become much easier to work with grid customizations. One of our clients came up with requirement that there should not be an hyperlink on Quote Items grid. Now, this hyperlink is not\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/05\/03\/sage-crm-7-2-client-side-api-manipulate-list-block-columns\/\">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":[83,155,200,202,204,219,220,332,1],"tags":[685,893,1471,1475,1532,2142],"class_list":["post-7749","post","type-post","status-publish","format-standard","hentry","category-crm72","category-fields","category-javascript-sage-crm","category-jquey","category-js-file","category-list","category-lists","category-sage-crm","category-uncategorized","tag-client-side-api","tag-customization","tag-javascript","tag-jquery","tag-list","tag-sage-crm7-2"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Sage CRM 7.2 Client Side API Manipulate List Block Columns - 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\/2014\/05\/03\/sage-crm-7-2-client-side-api-manipulate-list-block-columns\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Sage CRM 7.2 Client Side API Manipulate List Block Columns - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Grid customizations in Sage CRM are bit time consuming and sometimes need complex coding. But with Sage CRM client side API it has become much easier to work with grid customizations. One of our clients came up with requirement that there should not be an hyperlink on Quote Items grid. Now, this hyperlink is not\u2026 Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/05\/03\/sage-crm-7-2-client-side-api-manipulate-list-block-columns\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2014-05-03T05:54:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-02-25T10:07:54+00:00\" \/>\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\/2014\/05\/03\/sage-crm-7-2-client-side-api-manipulate-list-block-columns\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/05\/03\/sage-crm-7-2-client-side-api-manipulate-list-block-columns\/\",\"name\":\"Sage CRM 7.2 Client Side API Manipulate List Block Columns - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"datePublished\":\"2014-05-03T05:54:44+00:00\",\"dateModified\":\"2022-02-25T10:07:54+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/05\/03\/sage-crm-7-2-client-side-api-manipulate-list-block-columns\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/05\/03\/sage-crm-7-2-client-side-api-manipulate-list-block-columns\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/05\/03\/sage-crm-7-2-client-side-api-manipulate-list-block-columns\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sage CRM 7.2 Client Side API Manipulate List Block Columns\"}]},{\"@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":"Sage CRM 7.2 Client Side API Manipulate List Block Columns - 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\/2014\/05\/03\/sage-crm-7-2-client-side-api-manipulate-list-block-columns\/","og_locale":"en_US","og_type":"article","og_title":"Sage CRM 7.2 Client Side API Manipulate List Block Columns - Sage CRM \u2013 Tips, Tricks and Components","og_description":"Grid customizations in Sage CRM are bit time consuming and sometimes need complex coding. But with Sage CRM client side API it has become much easier to work with grid customizations. One of our clients came up with requirement that there should not be an hyperlink on Quote Items grid. Now, this hyperlink is not\u2026 Read More &raquo;","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/05\/03\/sage-crm-7-2-client-side-api-manipulate-list-block-columns\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2014-05-03T05:54:44+00:00","article_modified_time":"2022-02-25T10:07:54+00:00","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\/2014\/05\/03\/sage-crm-7-2-client-side-api-manipulate-list-block-columns\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/05\/03\/sage-crm-7-2-client-side-api-manipulate-list-block-columns\/","name":"Sage CRM 7.2 Client Side API Manipulate List Block Columns - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"datePublished":"2014-05-03T05:54:44+00:00","dateModified":"2022-02-25T10:07:54+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/05\/03\/sage-crm-7-2-client-side-api-manipulate-list-block-columns\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/05\/03\/sage-crm-7-2-client-side-api-manipulate-list-block-columns\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/05\/03\/sage-crm-7-2-client-side-api-manipulate-list-block-columns\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Sage CRM 7.2 Client Side API Manipulate List Block Columns"}]},{"@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\/7749","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=7749"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/7749\/revisions"}],"predecessor-version":[{"id":26237,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/7749\/revisions\/26237"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=7749"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=7749"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=7749"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}