/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 vote135 views1 answer
Typescript array count
TypeScript
1 vote187 views1 answer
How to add custom snippets in emmet in visual studio code
TypeScript
8 votes147 views1 answer
If exists sql server
TypeScript
2 votes193 views1 answer
Ionic save base64 as file
TypeScript
0 vote148 views1 answer
Can't bind to 'ngbCollapse' since it isn't a known property of 'div'
TypeScript
-1 vote141 views2 answers
Function that redirects to another page react
TypeScript
0 vote165 views1 answer
Execution failed for task ':app:lint'. > Lint infrastructure error
TypeScript
0 vote158 views1 answer
Cannot show Automatic Strong Passwords for app bundleID: com.williamyeung.gameofchats due to error: iCloud Keychain is disabled
TypeScript
0 vote142 views1 answer
How to gray out the unused imports in vscode
TypeScript
2 votes139 views2 answers
Typescript convert numer to string
TypeScript