setInterval is not defined

Asked Jul 01 '16 at 05:21

Active Jul 01 '16 at 05:21

Viewed 604 times

I have a project in google sheets, and every 5 minutes I would like a function to run that scrolls down to the last row that contains text. I have a function that works fine, however, I can't get the setInterval to work; I keep getting the reference error "setInterval is not defined."

function autoScroll() {
var s = SpreadsheetApp.getActiveSheet(),
    v = s.getRange('A:A').getValues(),
    l = v.length,
    r = 1;
while (l > 0) {
    if (v[l] && v[l][0].toString().length > 0) {
        r = (l + 2);
        break;
    } else {
        l--;
    }
}
SpreadsheetApp.setActiveRange(s.getRange(r, 1));

}

setInterval (autoScroll, 300,000);

asked Jul 01 '16 at 05:21

Gregg

1

Not the problem, but you need to remove the comma from `300,000`. – nnnnnn Jul 01 '16 at 05:23
5

http://stackoverflow.com/questions/22388143/google-application-script-using-setinterval-in-in-onopen-trigger-error-unde – jfriend00 Jul 01 '16 at 05:24

setInterval is not defined

0 Answers0