Hi there
I look for an example script: need to compare two tables and if it finds a match, copy the row to the third table.
Now I have it:
function Alarm ()
{
var sheet = SpreadsheetApp.openById (“id”);
var Data1 = sheet.getSheetByName (‘Feed’);
var Data2 = sheet.getSheetByName (‘Alarm-list’);
var Data3 = sheet.getSheetByName (‘Notifications’);
}
Already suggested (thanks @ThinhDinh ) that it should be the expression “When I add to table A, if the input info matches a row in table B, write both to table A and table C, and show an in-app notification. If no, only write to table A.
Same for table B, if the input info matches a row in table A, write both to table B and table C, and show a notification. If no, only write to table B. "
But how to express it in the code - I don’t know.
Help, please.
1 Like