AnsweredAssumed Answered

Search/Find logic question

Question asked by coherentkris on Oct 5, 2016
Latest reply on Oct 6, 2016 by dtcgnet

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 0day -1day -2day -3day -4day -5day -6
xx
xx
xx
xx
xx
xx

 

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.

Outcomes