/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

2 votes319 views1 answer
Adonis make model
TypeScript
0 vote324 views1 answer
Difference in minutes between 2 time inputs laravel
TypeScript
0 vote317 views1 answer
Getstaticpaths errors after new posts
TypeScript
2 votes340 views1 answer
Drop table if it exists mysql
TypeScript
2 votes350 views1 answer
Typescript singleton
TypeScript
0 vote372 views1 answer
Discuss climate changes during the Tertiary and Quaternary Periods, and the effects of these changes on geology and vegetation.
TypeScript
0 vote297 views1 answer
Sr.No. 18, Plot No. 5/3, CTS No.205,Behind Vandevi Temple, Karvenagar, Pune, Maharashtra
TypeScript
0 vote355 views1 answer
Les différents types de cours
TypeScript
-2 votes348 views1 answer
Good python projects list github
TypeScript
0 vote319 views1 answer
Ts loop through days in dates
TypeScript