How to make column value null/apply style based on another column's value?

mkleinosky

How to make column value null based on another column value?

1. This code works to change any cell in columns 4,5 or 6 with value "z-ALL" to hidden.

2. what is needed is to also change cell in same row column 7 to hidden (and null value) when column 6 = "z-ALL" in that row

   "aoColumnDefs": [ {

   "aTargets": [4, 5,6],

   "fnCreatedCell": function (nTd, sData, oData, iRow, iCol) {

   if ( sData == "z-ALL" ) {
   
     $(nTd).css('visibility', 'hidden')
   
      //  sData=null
   
      // need to set value in this row in column 7 to null and/ make invisible
   
    }
   

   }
   } ] ,