/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 vote176 views1 answer
Json2typescript ionic 5
TypeScript
3 votes172 views1 answer
Dart check if string is contained in list of strings
TypeScript
0 vote185 views1 answer
Pass command line arguments with spaces cmd
TypeScript
0 vote169 views3 answers
Typescript optional parameters
TypeScript
0 vote159 views2 answers
File_get_contents url fail
TypeScript
6 votes137 views2 answers
After effects download
TypeScript
0 vote167 views3 answers
Typescript with babel
TypeScript
0 vote172 views3 answers
Spade operator typescript
TypeScript
2 votes198 views1 answer
Eslint prettier typescript
TypeScript
9 votes196 views2 answers
Delete all child elements jquery
TypeScript