Google Scripts Seems To Be Caching Cell Values - Any Way To Avoid?

Hello Stack Overlords! I'm currently trying to put together a little coding project. Something simple, but I'm having a rather difficult time. The objective, clear out three cells

Solution 1:

Your assumption

This indicates to me it's because it's caching the value of K12

is correct. The values are cached as to retrieve the data much more efficiently and quickly. The easiest way to refresh the cache is by making a dummy setValue() or clearContent() calls, before you retrieve the value using getValue(). Like so

function ClearCells() {

    var s =    SpreadsheetApp.getActiveSpreadsheet().getSheetByName('AutoDeleteCellsOnTimeExpired');
    s.getRange("A1").setValue("DummyValue")  //Dummy Call
    Logger.log("SetValue")
    s.getRange("A1").clearContent()  //Delete Dummy Value// You can use either just clearContent() or setValue() and clearContent() calls// To achieve the same resultvar Check = s.getRange("K12").getValue();
    Logger.log(Check)
    if (Check == 0){
      s.getRange('D6').clearContent();
      s.getRange('D9:G9').clearContent();
    }
    Logger.log("New Version")
}

Alternatively, you can check the time value to the current time in the google app script directly and perform the required function, like so:

functionClearCells2() {

  var s =    SpreadsheetApp.getActiveSpreadsheet()
             .getSheetByName('AutoDeleteCellsOnTimeExpired');
  var curTime = newDate()
  var expTime = s.getRange("G9").getValue().split(":")
  Logger.log(curTime.getHours() +":"+curTime.getMinutes())
  Logger.log(expTime[0]+":"+expTime[1])

  if (curTime.getHours() >= expTime[0] && curTime.getMinutes() > expTime[1]){
    Logger.log("Clear")
    s.getRange('D6').clearContent();
    s.getRange('D9:G9').clearContent();
  }

}

References: Date(),date.getHours(),date.getMinutes()