/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 vote180 views1 answer
User acceptance testing vs system testing
TypeScript
0 vote204 views4 answers
Typescript hello world
TypeScript
0 vote183 views2 answers
Does word start with vowel typescript
TypeScript
0 vote184 views1 answer
Function to find the unique elements from two arrays
TypeScript
1 vote207 views2 answers
Typescript convert readonly
TypeScript
0 vote233 views2 answers
Prestashop show all products in category
TypeScript
3 votes207 views3 answers
C# check list of objects for value
TypeScript
1 vote191 views1 answer
Function isEmptyOrSpaces(str){ return str.replace(/\s/g,"") == ""
TypeScript
2 votes205 views2 answers
Constraints in database
TypeScript
0 vote193 views2 answers
Convert java to typescript
TypeScript