How to customize Grid’s column header caption in Sage CRM on runtime?

By | January 16, 2020

The Grid or List in Sage CRM allows user to view the multiple records on a single page. Sage CRM also allows Users to personalize the settings i.e. chose the number of records they wish to see in the list; from the Preferences tab. Besides this, these lists can be customized to a greater extent where the users can see particular records highlighted based on a condition, or displaying specific columns based on user’s team condition and so on. In this blog, I will explain you we customized the grid’s column header caption while loading the list in Sage CRM.

New Stuff: Report on Combined Note records for Custom Entity

One of our client came up with the requirement that, he wants to change the field caption while loading the list in Sage CRM. The reason to change the Column header was because of the huge field caption. Adding this field column in the list consumed a ton of unnecessary space. You can refer the below screen shot for same.

List with huge column header
List with huge column header

Thus we customized the list in such a way that the Column header caption will display an alternate name rather than the actual field name. To achieve this we used Client side API through the JavaScript codes. Below are the steps to follow –

  1. Go To, Administration–>Customization–> Opportunity and click on Screens Tab. From the list of screens find the search screen for example OpportunitySearchBox and click on hyperlink.
  2. From OpportunitySearchBox screen, Add below code in Custom Content of the screen and save the screen.
Custom Content script
Custom Content script

Once you save the changes, you can see that the grid’s column header caption displays the alternate name rather than actual field name. Below is the screen shot of the same.

List with Modified Column Headers
List with Modified Column Headers

In this way you can easily set the Grid’s column header caption as per your convenience in Sage CRM using java script codes.

About Us

Greytrix – a globally recognized and one of the oldest Sage Gold Development Partner is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience and expertise, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation competence.

Greytrix has some unique integration solutions developed for Sage CRM with Sage ERPs namely Sage X3Sage IntacctSage 100Sage 500 and Sage 300. We also offer best-in-class Sage ERP and Sage CRM customization and development services to Business Partners, End Users and Sage PSG worldwide. Greytrix helps in migration of Sage CRM from Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes addons like  Greytrix Business ManagerSage CRM Project ManagerSage CRM Resource PlannerSage CRM Contract ManagerSage CRM Event ManagerSage CRM Budget PlannerGmail IntegrationSage CRM Mobile Service Signature and Sage CRM CTI Framework.

Greytrix is a recognized Sage Champion ISV Partner for GUMU™ Sage X3 – Sage CRM integration also listed on Sage Marketplace.

For more information on our integration solutions, please contact us at sage@greytrix.com. We will be glad to assist you.