/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

1 vote134 views1 answer
[ERROR] @ionic/app-scripts is required for this command to work properly.
TypeScript
0 vote124 views1 answer
Tag for bullets in html
TypeScript
5 votes128 views1 answer
Cheats for dino game chrome
TypeScript
1 vote119 views1 answer
Remove all children of node in typescript
TypeScript
0 vote139 views1 answer
Google fonts icons size classes
TypeScript
0 vote136 views1 answer
Tolowercase typescript
TypeScript
35 votes177 views6 answers
Add days to date javascript
TypeScript
5 votes147 views3 answers
Typescript check type of variable
TypeScript
0 vote134 views1 answer
Styled components on vscode
TypeScript
2 votes125 views1 answer
Validation maxlength angular
TypeScript