/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

0 vote123 views1 answer
How to get value from observable
TypeScript
5 votes127 views3 answers
How to reload same page in angular 8
TypeScript
1 vote115 views6 answers
Could not find a declaration file for module implicitly has an 'any' type.
TypeScript
3 votes117 views1 answer
Mysql insert exists update
TypeScript
0 vote132 views1 answer
Text size in plots in r
TypeScript
0 vote125 views1 answer
How to define functional component types
TypeScript
2 votes112 views1 answer
Ts sorting
TypeScript
0 vote148 views1 answer
Nginx ERR_TOO_MANY_REDIRECTS when i try redirect to https
TypeScript
0 vote163 views1 answer
Express typescript error handling
TypeScript
1 vote66 views1 answer
<edit-config> changes in this plugin conflicts with <edit-config> changes in config.xml. Conflicts must be resolved before plugin can be added.
TypeScript