/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 vote145 views1 answer
Type script array declaration
TypeScript
0 vote174 views1 answer
Typescript arr numbers and strings
TypeScript
0 vote161 views1 answer
Does any event get triggered when checked value changes programatically?
TypeScript
4 votes163 views2 answers
Initialize empty array typescript
TypeScript
4 votes153 views3 answers
Find distance between two points in opencv python
TypeScript
9 votes149 views3 answers
Typescript onclick event type props
TypeScript
3 votes172 views1 answer
Aggregate in r
TypeScript
0 vote145 views1 answer
InsertSheet() at the beginning of active sheets google script
TypeScript
0 vote229 views1 answer
Apexcharts colors function
TypeScript
0 vote171 views1 answer
Angular closest element
TypeScript