I’ve started creating an AppSheet app a few days ago for the company I work at. In this app users can make entries which sets the value for the column “verified” to “false” once and entry is created as well as the date the entry was created. Now I want the user to get notified once a day as long as the “verified” column is set to “false”. Once the user verifies the entry (aka “the value is set to ‘true’”) the notifications shouldn’t pop up anymore. But I don’t have an idea how to tackle this. Any help would be greatly appreciated!
Also I’ve got another question for which I didn’t find a satisfying answer: What’s the difference between “Send Email” and “Send notification”? Both seem to be sending out emails so. Or do notifications additionally work like push notifications?
EDIT: There will be a total of 7 users with their own email addresses which is saved in the Google Sheet as well. The notifcation should only be sent to the user which created the entry.