Is it possible to export only rows edited/added on a certain date from Google Sheets?

Question

JavaScript

Googledox has a table with data that is regularly updated. The task is not to parse the entire table each time, but only the changed, deleted and added rows. The rows of the table have a unique ID that can be compared with the data in the database. There is versioning in Google Spreadsheets, but I didn't find anything related to it in the API or in the help for the tables themselves..

Answer 1

You have an array within an array, you need two loops

for(var i = 0; i<numb.length;i++){
    for(var j = 0; j<numb[i].length;j++){
        if(numb[i][j]>0) numb[i][j] = '+';
        else if(numb[i][j]<0) numb[i][j] = '-';
    }
}

Answer 2

Well, you actually defined an array with initial values, then redefined them as arrays and start iterating over an array of arrays. Also you try to compare an element (array) with number. Of course, nothing will work. Then you really need a nested loop - if your task is to iterate over the values ​​in nested arrays.