/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 vote327 views1 answer
COPY FROM instructs the PostgreSQL server process to read a file. You may want a client-side facility such as psql's \copy.
TypeScript
0 vote321 views1 answer
Text input detect return key react native
TypeScript
0 vote318 views1 answer
Remove wordpress products all at once
TypeScript
0 vote275 views1 answer
Exits adn copy file in java
TypeScript
22 votes342 views4 answers
Cmd listening ports
TypeScript
0 vote258 views0 answer
TypeScript
-1 vote310 views1 answer
How to separate a string into 2 lists of numbers and letters python
TypeScript
1 vote297 views4 answers
How to execute scripts when a button gui is pressed roblox
TypeScript
0 vote308 views2 answers
How to find geopoints radius in mongoose
TypeScript
1 vote331 views1 answer
Check if file.properties is exits android
TypeScript