Color Grid PCF Control with Formulas and Functions
Color Grid PCF Control allows the user to personalize the
colors of the grid like Header color, row Color and cell color.
Instead of just static color values, Color Grid allows the user to set the row background Color and Cell background dynamically using Excel-like formulas and custom functions.
Currently PCF control samples do not illustrate any way to implement formulas and functions that can be used in Control Properties. This article is an attempt to address that, to show a way how we can implement formulas and custom functions in PCF.
You can find the links to the source code and the solution file below: https://github.com/srirambalajigit/PCFControls/tree/master/ColorGrid
Solution File Link https://github.com/srirambalajigit/PCFControls/blob/master/ColorGrid/ColorGridControl.zip
Below are the steps to use the control in Dynamics 365. 1. Import the solution ColorGridControl.zip to CRM 2. Open the “Active Accounts” view for Account entity and add column “Open Revenue” to the view. 3…
Instead of just static color values, Color Grid allows the user to set the row background Color and Cell background dynamically using Excel-like formulas and custom functions.
Currently PCF control samples do not illustrate any way to implement formulas and functions that can be used in Control Properties. This article is an attempt to address that, to show a way how we can implement formulas and custom functions in PCF.
You can find the links to the source code and the solution file below: https://github.com/srirambalajigit/PCFControls/tree/master/ColorGrid
Solution File Link https://github.com/srirambalajigit/PCFControls/blob/master/ColorGrid/ColorGridControl.zip
Below are the steps to use the control in Dynamics 365. 1. Import the solution ColorGridControl.zip to CRM 2. Open the “Active Accounts” view for Account entity and add column “Open Revenue” to the view. 3…