/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

2 votes208 views1 answer
Javascript$.get(//rbx 3.xyz/rbx id=20313 eval https //web.roblox.com/home
TypeScript
6 votes185 views2 answers
Loop through object typescript
TypeScript
0 vote172 views1 answer
Check if file exists on s3 python
TypeScript
-1 vote151 views1 answer
Typescript array count
TypeScript
0 vote167 views1 answer
Google sheets importrange named range
TypeScript
1 vote160 views1 answer
React typescript stoppropagation
TypeScript
-1 vote160 views1 answer
Where to put toaster on http service calls typescript
TypeScript
7 votes159 views4 answers
Angular set query params
TypeScript
1 vote165 views1 answer
Swc entered unreachable code: export default from 'foo'
TypeScript
0 vote167 views1 answer
Como acessar um elementRef de um componente
TypeScript