Google-sheets – Google App Script – changeType “REMOVE_GRID”

How to use triggers with functions that require parameters from the spreadsheet?

AFAIK, you cannot. The solution is to create one single function, for example called RefreshAll, inside which you call all the wrapper functions (GetValue) containing the actual parameters which need to be passed to the function that actually does the job (RealFunctionThatDoesTheJob).

Note: Sorry if this sounds complicated. If you only have one set of parameters (as opposed to 3, in the example below), you can do away with GetValue and call RealFunctionThatDoesTheJob directly from within the function that is being triggered (RefreshAll).

Lastly, to have your triggers send to your spreadsheet those values that are dependent on parameters, you need to have the script push the values to the spreadsheet using (currentSheet.getRange(Row,Column).setValue(Value);)

Here is the example:

function RefreshAll() {

  var currentSheet = SpreadsheetApp.openById("ID").getSheetByName("MySheet");

  var Value1 = GetValue1();
  currentSheet.getRange(Row,Column).setValue(Value1);

  var Value2 = GetValue2();
  currentSheet.getRange(Row,Column).setValue(Value2);   

  var Value3 = GetValue3();
  currentSheet.getRange(Row,Column).setValue(Value3);

}

function GetValue1() {
  return RealFunctionThatDoesTheJob("Parameter1","Parameter2","Parameter3");
}

function GetValue2() {
  return RealFunctionThatDoesTheJob("Parameter4","Parameter5","Parameter6");
}

function GetValue3() {
  return RealFunctionThatDoesTheJob("Parameter7","Parameter8","Parameter9");
}

You can't use regex that way - getSheetByName does not accept a regex as its parameter, you need to have the full name (a string).

That being said, there's no reason why you need regex to do this.

Simply iterate over the sheets, and examine their name to see if they match the given date:

function getSheetByMonthAndDay(month, day) {
  var dateStr = format2digit(month) + "" + format2digit(day); // Formats the parameters into a 4-length string, e.g. '1231'
  var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();
  for (var i = 0; i < sheets.length; i++) { // Iterate over sheets
    var sheet = sheets[i];
    var name = sheet.getName(); 
    if (name.indexOf(dateStr) == name.length - dateStr.length) { // Check if the sheet name ends with the date (e.g. '1231');
      return name; // You might want to return sheet here, instead of name
    }
  }
  throw Error("No sheet for month " + month + ", day " + day);
}

This function returns the matching sheet's name (if any), or throws an exception if there's no such sheet.

The format2digit function is defined as

function format2digit(integer) {
  if (integer < 10) {
    return "0" + integer;
  } else {
    return integer;
  }
}

I have set up an example spreadsheet that you can look at.