/TypeScript/Google sheets automatic update rook

Google sheets automatic update rook

function storeFollowers(){
    var sheet = SpreadsheetApp.getActiveSheet();
    var datarange = sheet.getDataRange();
    var numRows = datarange.getNumRows();
    var numColumns = datarange.getNumColumns();
    var nextColumn = numColumns + 1;
    sheet.getRange(1, nextColumn).setValue(new Date());
    for (var i=2; i <= numRows; i++){
      var numLikes = sheet.getRange(i, 3).getValue();
      sheet.getRange(i, numColumns + 1).setValue(numLikes);
    }
}

Source: computerworld.com

Similar codes

5 votes148 views2 answers
Validation minlength angular
TypeScript
152 votes365 views6 answers
Create react app ts
TypeScript
2 votes152 views1 answer
Angular send mailto html
TypeScript
0 vote145 views1 answer
Module '"@angular/fire/firestore"' has no exported member 'AngularFirestoreDocument'
TypeScript
2 votes152 views2 answers
Print digits of a number in c
TypeScript
10 votes110 views1 answer
Online javascript to typescript compiler
TypeScript
0 vote185 views2 answers
Test reports in unit tests flutter
TypeScript
6 votes150 views4 answers
Property 'style' does not exist on type 'Element'.ts(2339)
TypeScript
0 vote191 views1 answer
Bibtex remove brackets in note field
TypeScript
0 vote158 views1 answer
Piechart am4charts legend with actual values
TypeScript