/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

13 votes177 views4 answers
Tsc.ps1 cannot be loaded because running scripts is disabled on this system
TypeScript
5 votes222 views1 answer
Heroku database error unknow attribute first_name for user
TypeScript
3 votes159 views2 answers
Angular formgroup validate manually
TypeScript
-1 vote208 views1 answer
Mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given in
TypeScript
2 votes170 views5 answers
Ng class in angular
TypeScript
1 vote153 views1 answer
Benefits eat halim plant leaves
TypeScript
4 votes131 views1 answer
Typescript convert image base64 librarie
TypeScript
0 vote175 views1 answer
'platformNativeScriptDynamic' is deprecated
TypeScript
0 vote161 views1 answer
Dynamic key interface typescript
TypeScript
0 vote164 views1 answer
Get one property from list of objects linq
TypeScript