google sheets hide row checkbox code example

Example: gosheets checkbox hideshow row

/** 
* TITLE:
*     Hide a row if a value is inputted. 
*/
 
//**GLOBALS**
// Sheet the data is on.
var SHEET = "D&D Miniatures";
// The value that will cause the row to hide. 
var VALUE = "Yes";
// The column we will be using 
var COLUMN_NUMBER = 6
 
function onEdit(e) {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var activeSheet = ss.getActiveSheet();
  
  //Ensure on correct sheet.
  if(SHEET == activeSheet.getName()){
    var cell = ss.getActiveCell()
    var cellValue = cell.getValue();
    
    //Ensure we are looking at the correct column.
    if(cell.getColumn() == COLUMN_NUMBER){
      //If the cell matched the value we require,hide the row. 
      if(cellValue == VALUE){
        activeSheet.hideRow(cell);
      };
    };
  };
}