/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

51 votes322 views3 answers
Remove duplicates from a list of lists python
TypeScript
0 vote236 views1 answer
Init Lambda based on typescript
TypeScript
1 vote227 views1 answer
Check if string include numbers in typescript
TypeScript
0 vote230 views1 answer
How to choose automation over manual testing
TypeScript
0 vote240 views1 answer
Event
TypeScript
1 vote242 views2 answers
Common legend for multiple plots in r
TypeScript
0 vote218 views1 answer
Styled components gatsby
TypeScript
5 votes210 views2 answers
Typescript css variables html
TypeScript
0 vote211 views1 answer
"A neutron star's immense gravitational attraction is due primarily to its small radius and"
TypeScript
0 vote237 views1 answer
FIFA 21 esports temas
TypeScript