How can I get my app to send push notifications when my data changes?

[Chase_Schlachte]

I can’t get my app to send me push notifications when my data table in google sheets changes. The google sheet is a query table that changes every 12 hours.

I have two behavior workflows set up with the only difference between the two under the “WHEN THIS HAPPENS…” section:

• one where “Update Event: Updates_Only”
• the second where “Update Event: All_Changes”

Then, the “DO THIS” action is “Notify” and I have my email entered (and push notifications for Appsheet enabled locally on my phone).

The thing is, when I open the app and refresh, the “updated” data pulls to the app. It’s almost like the app doesn’t notice the table has changed until I force a refresh… but my understanding was the workflow was meant to remedy that.

[Koichi_Tsuji]

Appsheet only send notification or email in case the data change is made through the appsheet.
Your spreadsheet is updated by query or GAS whichever they are basically nothing to do with Appsheet. To fire the appsheet workflow, data change always need to be made on Appsheet as platform.

To achieve your goals, I m afraid you need to script on your own, or employ other external service wihch listen to data change event on Spreadsheet and trigger notifications.

[Chase_Schlachte]

Got it - thanks for explaining Tsuji.

Is there a workaround where I could set a time-based push notification for every 12 hours?

[Koichi_Tsuji · Accepted solution]

It depends on what sort of contents to put on the notification, but Appsheet “Report” will solve the problem.

help.appsheet.com

Reports

Generate reports and take actions on a schedule that you specify.

set scheule report per 12 hours and pick up notification.

[Chase_Schlachte]

You’ve saved me again Tsuji (Koichi-san?). Thanks for the help.