Hi! Iโm stuck trying to solve how to automate the most important part of the app Iโm building.
The use case would be like this.
When user logs the current date and time via a form [time1]
Then send a notification to that user 240 minutes after that time.
I currently have a column called [time1] and virtual column [time2]
I used a formula to calculate the time for column [time2]
[time2] = [time1]+โ000:45:00โ
I first tried an automation with a โwait until condition is metโ. However if the user does nothing between time 1 and time1+45 mins then the notifications is not sent (Or I was unable to do so)
It is my understanding that only a data change can trigger something like this (please correct me if Iโm wrong). I know a couple of people talked about timers but I havenโt found any topics with a solution for this.
Can anyone think of a way to solve this so that 240 minutes after the logged time the user can receive a notification even if they donโt update that row within that time frame? Without a way to send a notification my app wouldnโt be that useful.
Many thanks in advance.
AppSheet cannot send notifications on arbitrary schedules. The best you could do is schedule notifications at preset times, like every hour, that are actually sent if there are any new messages queued.
User | Count |
---|---|
42 | |
33 | |
24 | |
23 | |
14 |