/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 vote201 views2 answers
List of continents
TypeScript
0 vote216 views1 answer
C++ count frequency of elements vector
TypeScript
0 vote237 views1 answer
Append scripts using jquery
TypeScript
1 vote204 views1 answer
Contextual typing in typescript
TypeScript
91 votes525 views5 answers
How to get last element of array in typescript
TypeScript
-80 votes198 views10 answers
Code
TypeScript
21 votes208 views6 answers
How to concatenate two lists in python
TypeScript
0 vote200 views1 answer
Ts loop through days in dates
TypeScript
2 votes256 views1 answer
No suitable injection token for parameter 'path' of class 'BaseModel'
TypeScript
1 vote195 views1 answer
Ion-datetime open programmatically
TypeScript