Send Notification to Specific Users on Public App


I am making a covid tracking app. The only data users give me is the context(“device”) code. Is it possible to send a specific set of users a notification to alert them of potential exposure to covid?

Also, this app is receiving a lot of attention and I would be happy to work with you to refine the app. Please let me know!

What is your condition to select the list of “users” you want to send the notifications? The distance / position where the user sit from a certain location with the certain amount of distance etc?

Or any other logics to pick up app users who interacted the app?

If someone tests positive, they would ideally notify us and tell us what event they attended. Then we would check all devices that checked-in to that event and send a notification everyone who attended that event.

Otherwise, we could use the distance idea as you suggested but I fear that will introduce privacy issues.

Thanks you for your help!

I got it.

I believe the tricks introduced by @Steve should be a point of visit for you to implement mechanism to capture the user data, such as user email address, which venue they visit, what time etc.

Once the user interact your app, the first thing they need to do is to fill the form on demands of yours to captures those set of data.

Then consume that table to send the notification as you want.

Yes, there is privacy issue as always, which is not an issue of Appsheet, but you should be deal with it by asking for “concensus” how you deal with private info over the app. For instance, before they go deeper into your app, app pose a question for concensus, and you keep record that concent in the separate table etc.

Bunch of works around which make impossile to possible.


With permission of app interactors, you can caputure lat/long data where the form was filled, then user that value to dynamically calculate the distance with distance() expression from a target location. Then do valid test if it is within short distance or long to decide if you submit the notification etc in combination of REPORT features to fire those valid test on schedule + automatically submit the notification etc.


Perfect!! I really appreciate your help.

1 Like