Notifications and creator email

AppSheet AppSheet Q&A
1

Hi all,

Thanks for all the great content! I have a desired outcome and I’m not sure how to achieve it. Well, maybe 2 requests for help.

  1. How do I remove the creator email from my apps? On start up, users are required to “accept” and it says the creators email address. I’d like to not have my private email displayed.

  2. Id like notifications in a read-only table. The factors change automatically based on equations and live data pulled into the table from google sheets. When a cell turns from “no” to “yes” I’d like to be notified with a push notification. Can this be done? The file isn’t being updated or edited by a person - just a formula. That seems to be impossible

Thank you!

2

Travis:

How do I remove the creator email from my apps? On start up, users are required to “accept” and it says the creators email address. I’d like to not have my private email displayed.

That message will only ever display the app owner’s email address. To display a different email address, the app must be owned by that other email address.

3

Travis:

Id like notifications in a read-only table. The factors change automatically based on equations and live data pulled into the table from google sheets. When a cell turns from “no” to “yes” I’d like to be notified with a push notification. Can this be done? The file isn’t being updated or edited by a person - just a formula. That seems to be impossible

Correct, it is impossible: AppSheet can only respond to data changes made by or through AppSheet; AppSheet cannot respond automatically to changes made directly within the spreadsheet itself.

4

Steve:

AppSheet cannot respond automatically to changes made directly within the spreadsheet itself.

@Steve
May I humbly add this option with your kind permission:
Provided you construct a script within the spreadsheet and enclose the code within an onEdit(e) or onChange(e) simple trigger which makes an UrlFetchApp call to the AppSheet REST API, then it seems it’s possible.

2 Likes
5

I stand corrected, sir!

1 Like
6

Do you have any examples for something like this? Perhaps a public sheet I can look at / copy the code

7

So if i were to make the app public everyone would see my private email address? How are others getting around this?

8

Travis:

Do you have any examples for something like this? Perhaps a public sheet I can look at / copy the code

Actually no, as it’s a tailor made approach. Regarding what you want to do or your final goal, the code can change a lot.