I need to be able to test for an interesting condition.
We are collecting data from a phone app.
People are required to upload a minimum of one record for two consecutive days out of the last 7 days.
A nightly script will do the checking and send out test messages to the deficient people.
Here is the minimum acceptable uploads in a 7 day period.
|x = uload|
|day 0||day -1||day -2||day -3||day -4||day -5||day -6|
Anything more than this is good.
Anything less and they should receive a message.
I have a person id and an upload timestamp in the table
How can I script a find to detect the people that need to have messages?
Adding fields to the table is acceptable as are any new TO's or relationships.