{"id":1616,"date":"2012-03-26T13:14:36","date_gmt":"2012-03-26T13:14:36","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=1616"},"modified":"2012-03-26T13:14:36","modified_gmt":"2012-03-26T13:14:36","slug":"display-sr-no-column-in-listgrid","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/03\/26\/display-sr-no-column-in-listgrid\/","title":{"rendered":"Display Sr No Column in List\/Grid"},"content":{"rendered":"

In Sage CRM we are able to view the Customer related details in a list format for e.g. Customer Address, Cases, Communication, documents. These details are displayed in List or Grid format in CRM.
\nUsing list format we can provide a variety of functionalities in CRM for e.g. we can add a hyperlink for customer\u2019s \u2018name\u2019 column, display images in \u2018status\u2019 column of case and communication list etc. We can apply sorting on column header as well.
\nMostly client\u2019s requirements are similar to what is explained above; but in other scenarios client\u2019s requirement were altogether different wherein client wanted to add checkbox, image column in list. On the same lines I once encountered a requirement wherein client had asked to display \u2018Sr. No\u2019 (Serial No) column in case list screen (Refer the attached screen-shot 1 below).
\n\"\"<\/a>
\nTo further add to the complications, the \u2018Sr. No\u2019 should still be applied even if the end user has filtered the search and a new list had to be displayed. (Refer the attached screen-shot 2 below).
\n\"\"<\/a>
\nSo in order to implement this customization we analyzed the functionality and followed the below given steps to achieve the same.
\n1. Log on to Sage CRM
\n2. Go to Administration-> Customization-> Case ->Fields
\n3. Click on the new button to create new field with name of Sr No
\n4. Click on the save button
\n5. Go to Administration-> Customization-> Case ->List
\n6. Click on the list name hyperlink column
\n7. Select Sr No field from field list
\n8. Click on the Add button and save button
\n9. We have created below given JavaScript code to implement Sr No column value.
\n< script for=window event=onload >
\nDisplay Sr No in List
\nMyGrid = getGrid();
\nif(MyGrid)
\n{
\nAddSRNo (MyGrid);
\n}
\n< \/script >
\n< script >
\n\/\/\u2019 This Function user for find List or Grid object from List
\nfunction getGrid()
\n{
\nvar allCells = document.getElementsByTagName(“TD”);
\nvar boolGridPresent = false;
\nfor(i=0;I < allCells.length;i++)
\n{
\nif(allCells[i].className==”GRIDHEAD”)
\n{
\nvar parentspan = allCells[i].parentNode;
\nwhile (parentspan.nodeName != “TABLE”)
\n{
\nparentspan = parentspan.parentNode;
\n}
\ntargetTable = parentspan;
\nreturn targetTable;
\nbreak;
\n}
\n}
\n}
\n\/\/’ This function use for display SR No in column
\nfunction AddSRNo(Grid)
\n{
\nCommLinkColm = 1
\ncheckboxcolno = 0
\nSrNoClolNo=2;
\nvar CurrRowNo = 1
\nvar CurrRowEle
\nvar SrNoCol;
\niPageNumberCount=0;
\n\/\/’ Get GridSize form Server Side
\niGridRowCount=’ < %=iGridSize% >’
\niSrNoCount=0;
\n\/\/’ Get Current Page Count
\nif(document.EntryForm.EnterPageNumber_BulkReassignmentGrid)
\niPageNumberCount=document.EntryForm.EnterPageNumber_BulkReassignmentGrid.value;
\n\/\/’ Page Count is Greater than Zero
\nif(iPageNumberCount>0)
\n{
\niSrNoCount=parseInt(iGridRowCount*iPageNumberCount)
\niSrNoCount=iSrNoCount-iGridRowCount+1;
\n}else
\n{
\niSrNoCount=1
\n}
\nwhile (CurrRowNo < Grid.rows.length)
\n{
\n\/\/’Get current row
\nCurrRowEle = Grid.rows[CurrRowNo];
\nSrNoCol = CurrRowEle.cells[SrNoClolNo];
\n\/\/’Get InnerHTML of next column and current id from the hyperlink
\nNextCol = CurrRowEle.cells[CommLinkColm]
\nNextColInHtml = new String(NextCol[“innerHTML”])
\nif(NextColInHtml==”” || NextColInHtml==”undefined” || NextColInHtml==”\u00a0“)NextColInHtml=””;
\nif(NextColInHtml!=””)
\n{
\n\/\/’ Display SR No in List colnum
\nSrNoCol[“innerHTML”] = iSrNoCount++;
\n}
\n\/\/’Increment row number
\nCurrRowNo++;
\n}
\n}
\n< \/script ><\/p>\n","protected":false},"excerpt":{"rendered":"

In Sage CRM we are able to view the Customer related details in a list format for e.g. Customer Address, Cases, Communication, documents. These details are displayed in List or Grid format in CRM. Using list format we can provide a variety of functionalities in CRM for e.g. we can add a hyperlink for customer\u2019s\u2026 Read More »<\/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":[1],"tags":[],"class_list":["post-1616","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\nDisplay Sr No Column in List\/Grid - 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\/03\/26\/display-sr-no-column-in-listgrid\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Display Sr No Column in List\/Grid - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"In Sage CRM we are able to view the Customer related details in a list format for e.g. Customer Address, Cases, Communication, documents. These details are displayed in List or Grid format in CRM. Using list format we can provide a variety of functionalities in CRM for e.g. we can add a hyperlink for customer\u2019s\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/03\/26\/display-sr-no-column-in-listgrid\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2012-03-26T13:14:36+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/03\/Image1.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=\"2 minutes\" \/>\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\/03\/26\/display-sr-no-column-in-listgrid\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/03\/26\/display-sr-no-column-in-listgrid\/\",\"name\":\"Display Sr No Column in List\/Grid - 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\/03\/26\/display-sr-no-column-in-listgrid\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/03\/26\/display-sr-no-column-in-listgrid\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/03\/Image1.jpg\",\"datePublished\":\"2012-03-26T13:14:36+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/03\/26\/display-sr-no-column-in-listgrid\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/03\/26\/display-sr-no-column-in-listgrid\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/03\/26\/display-sr-no-column-in-listgrid\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/03\/Image1.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/03\/Image1.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/03\/26\/display-sr-no-column-in-listgrid\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Display Sr No Column in List\/Grid\"}]},{\"@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 & 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":"Display Sr No Column in List\/Grid - 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\/03\/26\/display-sr-no-column-in-listgrid\/","og_locale":"en_US","og_type":"article","og_title":"Display Sr No Column in List\/Grid - Sage CRM \u2013 Tips, Tricks and Components","og_description":"In Sage CRM we are able to view the Customer related details in a list format for e.g. Customer Address, Cases, Communication, documents. These details are displayed in List or Grid format in CRM. Using list format we can provide a variety of functionalities in CRM for e.g. we can add a hyperlink for customer\u2019s\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/03\/26\/display-sr-no-column-in-listgrid\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2012-03-26T13:14:36+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/03\/Image1.jpg","type":"","width":"","height":""}],"author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/03\/26\/display-sr-no-column-in-listgrid\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/03\/26\/display-sr-no-column-in-listgrid\/","name":"Display Sr No Column in List\/Grid - 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\/03\/26\/display-sr-no-column-in-listgrid\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/03\/26\/display-sr-no-column-in-listgrid\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/03\/Image1.jpg","datePublished":"2012-03-26T13:14:36+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/03\/26\/display-sr-no-column-in-listgrid\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/03\/26\/display-sr-no-column-in-listgrid\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/03\/26\/display-sr-no-column-in-listgrid\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/03\/Image1.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/03\/Image1.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/03\/26\/display-sr-no-column-in-listgrid\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Display Sr No Column in List\/Grid"}]},{"@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 & 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\/1616","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=1616"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/1616\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=1616"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=1616"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=1616"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}