how to add a JS code to a sql view list

[rongame]

hi

I'm trying to add a js code to change the background color of a td based on a value. i created a js file named list_47.js the number is the id of the list respectively. i added a js list plugin and called the file. unfortunately it is not working. this is my code

thanks

var allTableCells = document.getElementsByTagName("td class");
for(var i = 0, max = allTableCells.length; i < max; i++) {
    var node = allTableCells[i];
    var currentVal = parseFloat(node.childNodes[0].nodeValue);
    if(currentVal != NaN){
        if (currentVal <0)
            node.style.backgroundColor = "red";
    }
    else if (currentVal != NaN) {
        if (currentVal >=1 && currentVal <=10  )
            node.style.backgroundColor = "yellow";
}
}

 

[startpoint]

Try:

var allTableCells = document.getElementsByTagName("td");console.log(allTableCells);

instead:

var allTableCells = document.getElementsByTagName("td class");console.log(allTableCells);

 

[rongame]

hi

thank you for your reply

but it doesnt work.

 

[startpoint]

Place link to your list and I'll try to help you.

 

[startpoint]

var allTableCells = jQuery(".fabrikDataContainer td");
//console.log(allTableCells);
for(var i = 0, max = allTableCells.length; i < max; i++) {
    var node = allTableCells[i];
    //console.log(node);
    var currentVal = parseFloat(node.textContent);
   // console.log(currentVal);
   
    if(currentVal != NaN){
        if (currentVal <0)
            node.style.backgroundColor = "red";
        if (currentVal >=1 && currentVal <=10  )
            node.style.backgroundColor = "yellow";
    }
}

Change this code for your needs.

 

[rongame]

hi thank you.

its working...

i wanted to customise this code further by selecting a particular column.

si i added a class to the element but its not working...

.stock-inc is my class

var allTableCells = jQuery(".fabrikDataContainer.stock-inc td");
//console.log(allTableCells);
for(var i = 0, max = allTableCells.length; i < max; i++) {
    var node = allTableCells[i];
    //console.log(node);
    var currentVal = parseFloat(node.textContent);
   // console.log(currentVal);
  
    if(currentVal != NaN){
        if (currentVal <0)
            node.style.backgroundColor = "red";
        if (currentVal >=1 && currentVal <=10  )
            node.style.backgroundColor = "yellow";
    }
}

thanks again

 

[startpoint]

var allTableCells = jQuery(".fabrikDataContainer td.stock-inc");