Hi there! I need to create a script for to compare two tables. If the value in the table rows matches, then the script will notify the user. Where can I read about it?

You’ll find examples of various scripts in this thread . How would the user be notified - email? As an alternative to scripting, I’d recommend also checking out automation tools such as Zapier or Integromat .

[image] Darren_Murphy: How would the user be notified - email? No, push in app

So on adding a new row to table A, if it matches a row in table B then it should notify the user and vice versa?

Push notifications will not work on IOS, and will only work under very specific circumstances on Android. [image] Notification push Only people who: have also commented on the thread and who are not the author and are not viewing the page when the comment happens and a…

I thought this was the wrong algorithm. better like this: the script compares two tables, and if there is a match (exact or in the period), then it copies the row to the third table, and a notification is already received from there

Then what I would do is create 2 custom forms for the addition of rows to two tables. In those forms, writing to user-specific columns, I would have a relation to check if: 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 no…

Where are you getting stuck with it? How are you currently letting users add rows to each sheet?

while also function moveRows() { var sheet = SpreadsheetApp.openById(“id”); var sheetname = sheet.getSheetByName(‘Feed’); var sheetname = sheet.getSheetByName(‘Alarm-list’); var sheetname = sheet.getSheetByName(‘Notifications’); var rng = sheet.getRange(‘A1:Z200’); var rngA = rng.getValues(); …

Can you go through what that function specifically does in your case?

Script for for to compare

Ask for Help

Antonoff February 25, 2021, 9:14am 12

Writhe here Scripts, scripts, scripts! - #142 by Antonoff

Topic		Replies	Views
Push notification when new row added Ask for Help	3	385	June 14, 2023
Show Notifications or Push notifications Ask for Help push-notifications	2	87	June 28, 2024
Push notifications Feature Requests	2	8216	April 12, 2020
Notifications by mail Ask for Help	3	370	October 1, 2019
Send push notifications in Glide app when new row is added in google sheet Ask for Help actions	4	84	July 30, 2024

Script for for to compare

Related topics