/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 vote292 views1 answer
Duplicate names in sql
TypeScript
2 votes330 views2 answers
How to check constraints on a table in sql oracle
TypeScript
0 vote336 views1 answer
TypeError: __cinit__() takes at least 2 positional arguments (0 given)
TypeScript
0 vote280 views1 answer
Which of the following object types below cannot be replicated
TypeScript
0 vote351 views1 answer
Prevent anchor tag to move to up when we click on it
TypeScript
0 vote323 views1 answer
Breaks_width in r
TypeScript
18 votes288 views3 answers
Enum to number typescript
TypeScript
1 vote324 views1 answer
Angular conditional pipe
TypeScript
0 vote294 views1 answer
Cra ts pwa
TypeScript
1 vote259 views1 answer
Dynamic imports are only supported when the '--module' flag is set to 'es2020', 'esnext', 'commonjs', 'amd', 'system', or 'umd'.
TypeScript