/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 vote147 views1 answer
Python check if property exists in dictionary
TypeScript
3 votes135 views1 answer
Github screenshots resize
TypeScript
0 vote135 views1 answer
R merge list
TypeScript
0 vote139 views1 answer
Styled components last child
TypeScript
0 vote147 views2 answers
Typescript array of mixed types
TypeScript
0 vote153 views1 answer
Cannot show Automatic Strong Passwords for app bundleID: com.williamyeung.gameofchats due to error: iCloud Keychain is disabled
TypeScript
0 vote131 views1 answer
Spyon observable
TypeScript
4 votes166 views1 answer
Enumerate multiple lists python
TypeScript
0 vote96 views0 answer
TypeScript
8 votes141 views3 answers
Showing 2 digits of float in python
TypeScript