color in the field of a particular row.column in the list view fields added by H5 scripting.

Hi,
I have added columns in the list view/ sub file through H5 script. One of the column fields is the sum(Qty) of each item in last six months. I want to highlight the field added with a color or entire record with a color of the particular row.column which has a sum (qty) greater than 100
Is this color highlight possible through H5 script the way we use for M3 fields through personalization ?

I am looking for the last columns field whose value is above 100 I want to hightlight it with a color.

Anybody added color through H5 script or worked on this kind of requirement?

All the last 7 fields in below screenshot are added through H5 script.

Find more posts tagged with

Accepted answers

Jack Rubillar

Hi,

Try using a custom formatter when you define the custom column.

//Create a custom formatter
function MyCustomFormatter(row, cell, value, columnDef, dataContext)
{
var html = "<b>" + value + "</b>";
return html;
}

var newColumn = {
id: columnId,
field: columnId,
name: "Custom Column " + columnNum,
width: 100,
formatter: MyCustomFormatter //set the formatter to be used
};

All comments

reginald-reyes

Hi,
Since the custom columns are not part of the list coming from BE, it is not possible to add personalizations to it.
Regards,
Reggie

Jack Rubillar

Hi,

Try using a custom formatter when you define the custom column.

Legacy Contributor

Hi,

I would say thank you very much. The code you shared above worked.

I have modified your code as follows while adding my eighth column

//Create eighth column header
var columnId8 = "C" + (columnNum + 7);
this.columnAppended = true;
var columns8 = list.getColumns();
//Create a custom formatter
function MyCustomFormatter(row,cell,value)
{
console.log(row);
console.log(cell);
console.log(value);
var color = "black" ;
if (parseFloat(value)> 100){
color = "red";}
var html = "<span style='color:" + color +"'>" + value + "</span>";

return html;

}
var newColumn8 = {
id: columnId8,
field: columnId8,
name: "Last six months quantity",
width: 100,
formatter: MyCustomFormatter //set the formatter to be used

};
if (columns.length < (columnNum + 7)) {
columns.push(newColumn8);
}
//add the eighth column header
list.setColumns(columns);

It highlights the value according to my condition greater than 100 and it also highlights the entire column values as below.

Copyright © 2025 Infor. All rights reserved.