{"id":7754,"date":"2014-05-03T06:12:31","date_gmt":"2014-05-03T06:12:31","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=7754"},"modified":"2014-05-03T06:12:31","modified_gmt":"2014-05-03T06:12:31","slug":"control-column-visibility-in-sage-crm-grids-and-lists","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/05\/03\/control-column-visibility-in-sage-crm-grids-and-lists\/","title":{"rendered":"Control Column Visibility in Sage CRM Grids and Lists"},"content":{"rendered":"<p>Sage CRM allows us to customize Lists, Grids, and Screens in such way that with little bit of a trick; Sage CRM users can add data security. Data security can be provided at various levels for an entity, for screens, tabs or at the field level. In this blog, we will explain how security can be applied for a particular column of a list.<br \/>\n<span style=\"color: #993300;\"><b><i>See how:<\/i><\/b><\/span> <a href=\"http:\/\/bit.ly\/aZqR9J\" target=\"_blank\" rel=\"noopener\">GUMU Sage 100 ERP &#8211; Sage CRM Integration Keeps your Sales Team More Productive<\/a><br \/>\n<span style=\"line-height: 1.6em;\">Consider an example where Customer Service Support manager wants \u2018Assigned to\u2019 column to be visible only for Admin users.<br \/>\n<a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/05\/Case_1.jpg\"><img fetchpriority=\"high\" decoding=\"async\" alt=\"Case_1\" src=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/05\/Case_1.jpg\" width=\"627\" height=\"331\" \/><\/a><br \/>\nTo do the same, one just needs to follow below instructions.<br \/>\n<\/span>1) Navigate to Administration | Customization | Cases.<br \/>\n2) Select <b>Lists<\/b> tab and select Case List from the list.<br \/>\n3) Select \u2018<b>Assigned To\u2019<\/b> column from Case List and add the below lines of code in the <b>Create Script<\/b> section.<\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/05\/Case_2.jpg\"><img decoding=\"async\" class=\"size-full wp-image-7756 aligncenter\" alt=\"Case_2\" src=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/05\/Case_2.jpg\" width=\"626\" height=\"368\" \/><\/a><\/p>\n<p><span style=\"line-height: 1.6em;\">4) Click on <\/span><b style=\"line-height: 1.6em;\">Update<\/b><span style=\"line-height: 1.6em;\"> button and then click on <\/span><b style=\"line-height: 1.6em;\">Save<\/b><span style=\"line-height: 1.6em;\"> button.<br \/>\n<\/span>5) Now whenever a user other than the admin is logged in Sage CRM, they will not be able to see \u2018Assigned To\u2019 column. However the Admin will be able see the same.<\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/05\/Case_3.jpg\"><img decoding=\"async\" class=\"size-full wp-image-7757 aligncenter\" alt=\"Case_3\" src=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/05\/Case_3.jpg\" width=\"628\" height=\"292\" \/><\/a><\/p>\n<p><span style=\"line-height: 1.6em;\">In this way, one can easily secure any column in the list from other users just by adding the condition as per his requirement as explained above.<\/span><br \/>\n<span style=\"line-height: 1.6em;\"><b style=\"line-height: 1.6em;\"><span style=\"color: #993300;\">Also Read<\/span>:<br \/>\n<\/b><\/span>1) <a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/01\/06\/iis-security-in-sage-crm-v7-2\/\" target=\"_blank\">IIS Security in Sage CRM v7.2<br \/>\n<\/a>2) <a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/06\/06\/enhanced-data-security-restriction-on-custom-entity-screen-buttons\/\" target=\"_blank\">Enhanced Data Security \u2013 Restriction on Custom entity screen buttons<br \/>\n<\/a>3) <a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/04\/25\/user-administration-and-info-admin-rights\/\" target=\"_blank\">User Administration and Info Admin Rights<br \/>\n<\/a>4) <a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/12\/13\/restrict-sensitive-information\/\" target=\"_blank\">Restrict Sensitive Information<br \/>\n<\/a>5) <a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/07\/20\/permissions-to-modify-the-crm-configurations\/\" target=\"_blank\">Permissions To Modify The CRM Configurations<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sage CRM allows us to customize Lists, Grids, and Screens in such way that with little bit of a trick; Sage CRM users can add data security. Data security can be provided at various levels for an entity, for screens, tabs or at the field level. In this blog, we will explain how security can\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/05\/03\/control-column-visibility-in-sage-crm-grids-and-lists\/\">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":[68,83,169,219,220,332,336,337,426],"tags":[702,833,1231,1532,2010,2031,2033,2568],"class_list":["post-7754","post","type-post","status-publish","format-standard","hentry","category-column","category-crm72","category-grids","category-list","category-lists","category-sage-crm","category-sage-crm-7-1-sp2","category-sage-crm-7-2","category-visibility","tag-column","tag-crm7-0","tag-grids","tag-list","tag-sage-crm","tag-sage-crm-7-1","tag-sage-crm-7-2","tag-visibility"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Control Column Visibility in Sage CRM Grids and Lists - 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\/control-column-visibility-in-sage-crm-grids-and-lists\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Control Column Visibility in Sage CRM Grids and Lists - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Sage CRM allows us to customize Lists, Grids, and Screens in such way that with little bit of a trick; Sage CRM users can add data security. Data security can be provided at various levels for an entity, for screens, tabs or at the field level. In this blog, we will explain how security can\u2026 Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/05\/03\/control-column-visibility-in-sage-crm-grids-and-lists\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2014-05-03T06:12:31+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/05\/Case_1.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\/2014\/05\/03\/control-column-visibility-in-sage-crm-grids-and-lists\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/05\/03\/control-column-visibility-in-sage-crm-grids-and-lists\/\",\"name\":\"Control Column Visibility in Sage CRM Grids and Lists - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/05\/03\/control-column-visibility-in-sage-crm-grids-and-lists\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/05\/03\/control-column-visibility-in-sage-crm-grids-and-lists\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/05\/Case_1.jpg\",\"datePublished\":\"2014-05-03T06:12:31+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/05\/03\/control-column-visibility-in-sage-crm-grids-and-lists\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/05\/03\/control-column-visibility-in-sage-crm-grids-and-lists\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/05\/03\/control-column-visibility-in-sage-crm-grids-and-lists\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/05\/Case_1.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/05\/Case_1.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/05\/03\/control-column-visibility-in-sage-crm-grids-and-lists\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Control Column Visibility in Sage CRM Grids and Lists\"}]},{\"@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":"Control Column Visibility in Sage CRM Grids and Lists - 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\/control-column-visibility-in-sage-crm-grids-and-lists\/","og_locale":"en_US","og_type":"article","og_title":"Control Column Visibility in Sage CRM Grids and Lists - Sage CRM \u2013 Tips, Tricks and Components","og_description":"Sage CRM allows us to customize Lists, Grids, and Screens in such way that with little bit of a trick; Sage CRM users can add data security. Data security can be provided at various levels for an entity, for screens, tabs or at the field level. In this blog, we will explain how security can\u2026 Read More &raquo;","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/05\/03\/control-column-visibility-in-sage-crm-grids-and-lists\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2014-05-03T06:12:31+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/05\/Case_1.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\/2014\/05\/03\/control-column-visibility-in-sage-crm-grids-and-lists\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/05\/03\/control-column-visibility-in-sage-crm-grids-and-lists\/","name":"Control Column Visibility in Sage CRM Grids and Lists - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/05\/03\/control-column-visibility-in-sage-crm-grids-and-lists\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/05\/03\/control-column-visibility-in-sage-crm-grids-and-lists\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/05\/Case_1.jpg","datePublished":"2014-05-03T06:12:31+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/05\/03\/control-column-visibility-in-sage-crm-grids-and-lists\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/05\/03\/control-column-visibility-in-sage-crm-grids-and-lists\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/05\/03\/control-column-visibility-in-sage-crm-grids-and-lists\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/05\/Case_1.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/05\/Case_1.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/05\/03\/control-column-visibility-in-sage-crm-grids-and-lists\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Control Column Visibility in Sage CRM Grids and Lists"}]},{"@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\/7754","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=7754"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/7754\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=7754"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=7754"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=7754"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}