remind you of a nearby expiration date, with an email

[Benni]

I'm having difficulty creating an email notifying me of an impending deadline. I would like to set up 30 days before the deadline, sending an email. To do this, the system reads the "expiration date" field and sends the email.

Given that my app is not published and therefore, if I understand correctly, I cannot use the schedule tools; What approach do you suggest?

[WillowMobileSys · Accepted solution]

---

@Benni wrote:

Given that my app is not published and therefore, if I understand correctly, I cannot use the schedule tools; What approach do you suggest?

---

What is your plan for the app?  

If it to be used ONLY by you, then you can set the app for "Personal use" which will allow you to deploy and use the app for free, including Scheduled bots.  See image.

If the app will be used by others, it will need to be deployed at some point.  I believe Scheduled Bots will require the Core Plan.

I hope this helps!

App Setting for Personal Use apps

 

[Suvrutt_Gurjar]

I think you have understood it correctly. Such a regular intervals based,  automatic reminder is possible only with scheduled bots. In turn, scheduled bots are possible only with deployed app and certain pricing plan. Pricing plans  and associated features are available on Appsheet pricing page.

[WillowMobileSys · Accepted solution]

---

@Benni wrote:

Given that my app is not published and therefore, if I understand correctly, I cannot use the schedule tools; What approach do you suggest?

---

What is your plan for the app?  

If it to be used ONLY by you, then you can set the app for "Personal use" which will allow you to deploy and use the app for free, including Scheduled bots.  See image.

If the app will be used by others, it will need to be deployed at some point.  I believe Scheduled Bots will require the Core Plan.

I hope this helps!

App Setting for Personal Use apps

 

[Benni]

Hi thanks everyone for the replies. The application will be used by 5 volunteers from our Volunteer Organization. I never thought of publishing it, I don't think this application is useful to anyone else because it is too specific. The app is already set to "personal use" and the operating bots are the ones that send emails when you perform an update or insert a new record.

I don't know if I will change this decision in the future.
Returning to the question, I wonder if there isn't an "alternative" way to create a reminder that will certainly use a string of code.

[WillowMobileSys · Accepted solution]

---

@Benni wrote:

I never thought of publishing it

---

Publishing is different than deploying.  Publishing implies submitting the app to the app stores.

Deploying takes the app out of prototype mode in the test environment and runs it as a "live" app in the "production" environment AS WELL AS enabling certain features that are not allowed while under prototype - such as Scheduled Bots.

To use Scheduled Bots the app must be deployed.  If you have 5 other volunteers who will be using the app, then you would need to purchase 5 licenses.

An alternative to using Scheduled Bots to send reminders? 

You could use a Google Apps Script.  It can look at the same datasource, be triggered on a schedule and be built to send emails.  Such a script can run completely independent of AppSheet so would not be subjected to AppSheet pricing.  

[Benni]

😳

"

An alternative to using Scheduled Bots to send reminders? 

You could use a Google Apps Script.  It can look at the same datasource, be triggered on a schedule and be built to send emails.  Such a script can run completely independent of AppSheet so would not be subjected to AppSheet pricing.  "

WillowMobileSys you opened a world to me...
I'm going to look for these scripts and hopefully be able to figure out what I need and how to use that.

thank you for your valuable advice.