Google Spreadsheet Script

gistfile1.txt

function findDateFromCalendarByName( find , timer ){

  if ( find == '' ) { return; }

  var ss = SpreadsheetApp.getActiveSpreadsheet(), output = [];
  // var searchData = ss.getSheetByName('Calendar').getDataRange().getValues();

  var searchData = ss.getSheetByName('Calendar').getRange("A1:P10").getValues();
  
    for(var j=0, jLen=searchData.length; j<jLen; j++) {
      for(var k=0, kLen=searchData[0].length; k<kLen; k++) {
        if(find == searchData[j][k]) {
         // output.push([find, "row "+(j+1)+"; "+"col "+(k+1)]);
          // output.push([find, searchData[1][(k)] ]);
          output.push([searchData[1][k]]);
        }
      }
    }
  if ( output.length > 0 ) {    
    return output;
  } else {
    return 'n/a';
  }
  Logger.log(timer);
}

function findTimeFromCalendarByName( find , timer ){

  if ( find == '' ) { return; }
  
  var ss = SpreadsheetApp.getActiveSpreadsheet(), output = [];
  var searchData = ss.getSheetByName('Calendar').getDataRange().getValues();

    for(var j=0, jLen=searchData.length; j<jLen; j++) {
      for(var k=0, kLen=searchData[0].length; k<kLen; k++) {
        if(find == searchData[j][k]) {
         // output.push([find, "row "+(j+1)+"; "+"col "+(k+1)]);
          // output.push([find, searchData[j][(0)] ]);
          output.push([searchData[j][0]]);
        }
      }
    }
  if ( output.length > 0 ) {
    return output;
  } else {
    return 'n/a';
  }
}


function myFind( find ) {
  var ss = SpreadsheetApp.getActive(), output = [];

  var searchData = ss.getSheetByName('Calendar').getDataRange().getValues();

    for(var j=0, jLen=searchData.length; j<jLen; j++) {
      for(var k=0, kLen=searchData[0].length; k<kLen; k++) {
        if(find == searchData[j][k]) {
          // output.push(["row "+(j)+"; "+"col "+(k)]);
          output = ["row "+(j)+"; "+"col "+(k)];
        }
      }
    }

  return output;
}

/*
function onEdit(e){
  // Set a comment on the edited cell to indicate when it was changed.
  var range = e.range;
  range.setNote('Last modified: ' + new Date());
}
*/