/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 vote269 views1 answer
Typescript create map
TypeScript
10 votes269 views2 answers
How to declare a boolean in typescript
TypeScript
0 vote289 views1 answer
Flutter scroll view when draggable item reaches edge
TypeScript
1 vote300 views1 answer
Whats the file path for the documents folder linux
TypeScript
0 vote297 views1 answer
"Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryInterface", but its service could not be found. Make sure the service exists and is tagged with "doctrine.repository_service".
TypeScript
1 vote272 views3 answers
An attempt was made to access a socket in a way forbidden by its access permissions.
TypeScript
0 vote264 views1 answer
Compare two lists and remove duplicates java
TypeScript
1 vote278 views1 answer
Property 'mozRequestFullScreen' does not exist on type 'HTMLElement'. Did you mean 'requestFullscreen'?
TypeScript
0 vote272 views1 answer
Keynote Invite multiple users to make edits to the same document:
TypeScript
0 vote276 views1 answer
Export of name 'matMenu' not found!
TypeScript