I cannot get setTimeout to work, I finally got to this code that does not generate a “note definded” error for setTimeout, but I cannot get the delay to work, this Execution Log immediately registers the correct output. Admittingly I am a newbie newbie to all of this, however I am tireless in trying to learn with a lot of help from stackoverflow, however I do not understand this issue. Here is one of many code attempts:
function myTimer(){
setTimeout(()=>{mySetTimer()},10000)}
function mySetTimer(){
Logger.log("Hello Old Dog")
var spreadsheet = SpreadsheetApp.getActive()
var sheet = spreadsheet.getActiveSheet()
Logger.log(SpreadsheetApp.getActive().getActiveSheet().getName()
var values = sheet.getRange("A5:O5").getValues()
Logger.log(values)tion mySetTimer(){
}
Could someone please explain this, Regards,Rand