How to add a reminder if a submission has not occured in 3 days

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