Im trying to set up a log to track a cleints stool and urine cylce… and want to set reminders if he hasnt passed a stool in 3 days. how can i program this?
Here is what I have in mind.
I am assuming that you have a table with the clients and a table with the log entries.
Create a bot that has a for each row scheduled event on the clients table.
In the process have an If/Else step that checks if there is a row in the log table in the last 3 days. You can write a Count/Select expression that will do that COUNT() | AppSheet Help Center and check that its bigger than 1.
If its not send an email, otherwise do nothing.
Hope this helps
User | Count |
---|---|
43 | |
29 | |
24 | |
22 | |
13 |