/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 vote204 views4 answers
C++ sort vector of objects by property
TypeScript
0 vote173 views2 answers
Comparison method violates its general contract!
TypeScript
0 vote178 views1 answer
Aruments in C#
TypeScript
0 vote167 views2 answers
How to check is null or empty in typescript
TypeScript
14 votes175 views2 answers
Upgrade to typescript in react js
TypeScript
0 vote152 views1 answer
Angular firestore timestamp date pipe
TypeScript
0 vote171 views1 answer
Sort an arraylist of objects in java
TypeScript
1 vote167 views1 answer
Adonis load many
TypeScript
0 vote168 views1 answer
Four basic components that information system consists of
TypeScript
1 vote220 views1 answer
Change textinputlayout color
TypeScript