Color code grid column

Hello ​@SandyA,

You can do this using a JS script:

1. Add a JavaScript in screen editor like this:

   

   It is available in Add Controls/Other Controls:

   

    

2. Set IsStartupScript = true and the Script = function FormView_Load() {          if (px_all["ctl00_phG_tab_t0_grid"] && px_all["ctl00_phG_tab_t0_grid"].rows) {                  let lines = px_all["ctl00_phG_tab_t0_grid"].rows.items;                  for (let i = 0; i < lines.length; i++) {                          let currentLine = lines[i];                          if(currentLine) {                                  let field = currentLine.getCell("FullOpenQty");                                  if(field !== undefined) {                                          let fieldValue = field.getValue();                  if (fieldValue && fieldValue > 0) {                      field.style = "green";                          field.repaint();                                      }                              }                      }              }      }}
3. Go to DataSource and set the CommandPerformed under ClientEvents = FormView_Load:

   

    

4. All of this resulted into changing the color in the screen to green: