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!!
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.
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.
Thank you so much!
The virtual column hadn’t occurred to me.
