Notifications

[papa181]

I am the father of a special boy. Nurses take care of him 24 hours a day and visit various specialists.
I created an application that we use to control the parameters.
I would like to make a Bot where I notify (email or notifications) if more than a certain number of days go by without depositions (Deposiciones), but I can't get it.
Any ideas?

Gracias!!

[bowker6789 · Accepted solution]

Have you tried creating a virtual column with the following should give you the last date where the Egresos column contains "Deposiciones":

MAX(SELECT(Respuestas de formulario 1[Fecha], CONTAINS([Egresos], "Deposiciones")))

Then you get a scheduled bot to run each day with the condition set to

TODAY()-2 > [Your New Virtual Column]

That might work or at least get you closer to your goal.

[papa181]

Thank you so much!
The virtual column hadn't occurred to me.

[SkrOYC]

Me parece una excelente idea, espero poder ayudarte.

En AppSheet siempre hay varias formas de hacer prácticamente lo mismo.

Como veo que estás empezando te recomiendo estudiar la documentación antes de embarcarte en hacer la app que planeas, de esa forma será más útil y tendrás menos dolores de cabeza.

App design 101 - AppSheet Help