Check out example codes for "gosheets checkbox hideshow row". It will help you in understanding the concepts better.

Code Example 1

*     Hide a row if a value is inputted. 
// 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 
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){

Learn ReactJs, React Native from