Alarm clock implementation

[Fabrizio]

Hi everyone, 

I would like to create an alarm clock, the user should be able to set alarm at specific hour and the app should alert with a notification.

Any tips of how to implement something similar? I was thinking about collecting information using a form, saving them in a table and then creating automation to check time and trigger alarm when needed (specific time stored in the table)

Thanks in advanced for any support!

 saving

[Aurelien]

Hi @Fabrizio 

I think you are on the right path with a notification triggered by a bot.

I didn't give a try yet, but you may want to try this in your bot process ? 

[Fabrizio]

Hi @Aurelien , 

Thanks much for your hint, just another question, do you know if it is possible to trigger events scheduled every hour/minute?

[Aurelien]

@Fabrizio 

As far as I know you can't.

But you can set various bots, on a weekly period such as here:

So, if you need to check something 7 times a day...you will need to build 7 events. 

The processes attached to these events would be to "call a process" as often as necessary.

I'm afraid this could be tedious, I hope someone will give another idea !

[Fabrizio]

As far as I have learned so far I agree with you @Aurelien . Let's see if someone else have different approach

The point is that as long as I need hour schedule it is tedious but feasible, if the granularity gets finer it would be tough 

🙂

Thanks much for your huge support!

[SkrOYC]

---

@Aurelien wrote:

I'm afraid this could be tedious, I hope someone will give another idea

---

---

@Fabrizio wrote:

Let's see if someone else have different approach

---

Since this is something slightly out of the scope of AppSheet, it will be cumbersome with no doubt IMO

[Fabrizio]

It is definitely as you say @SkrOYC , I'm afraid there is no way around.

[Aurelien · Accepted solution]

A workaround that comes to my mind: Using an Apps Script, which can be triggered on a granular way, and call an AppSheet bot with it, using the AppSheet REST API.

[Fabrizio]

oh great, I thought scripts could just be triggered by bot and not the opposite, I deepen into this one, thanks much @Aurelien