/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

4 votes274 views3 answers
Typescript get current timestamp
TypeScript
-1 vote299 views1 answer
Where to put toaster on http service calls typescript
TypeScript
0 vote292 views2 answers
How to make auto conversion of blogger texts with fonts installed in blog theme
TypeScript
0 vote295 views1 answer
Ubuntu display stdouts of processn
TypeScript
1 vote338 views2 answers
Solitaire
TypeScript
0 vote360 views1 answer
<div>
TypeScript
0 vote324 views1 answer
Difference between scripted testing and exploratory testing
TypeScript
2 votes274 views1 answer
Typescript valueof interface
TypeScript
0 vote323 views3 answers
Typescript type of function
TypeScript
13 votes284 views3 answers
Typescript integer
TypeScript