/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 vote270 views2 answers
Roblox Script wait
TypeScript
2 votes250 views1 answer
UseStae with array of strings typescript
TypeScript
0 vote284 views1 answer
Access single document with its id flutter
TypeScript
10 votes296 views3 answers
Foreach typescript
TypeScript
0 vote270 views1 answer
Separate subplots in python
TypeScript
0 vote287 views1 answer
Distributed Cron Job
TypeScript
0 vote285 views1 answer
Asciidots helloworld
TypeScript
2 votes283 views1 answer
State in react typescript
TypeScript
0 vote348 views1 answer
How to create an unknown amount of objects in c++
TypeScript
0 vote268 views1 answer
Environ 2.020.000 résultats (0,60 secondes) << Add Grepper Answer (a) Résultats de recherche Résultats Web
TypeScript