I want to run a daily report that checks the ...

[Jonathon]

I want to run a daily report that checks the created_date of their latest entry and sends them a notification if its been over a month. It needs to do this for each unique user.

My formula is as follows and appears to work when I test it in the app. Yet, the reports are not being sent at the scheduled time.

AND( [created_date]=(MAX(SELECT(bips[created_date],[user]=[_THISROW].[user]))), (TODAY())>=(MAX(SELECT(bips[created_date],[user]=[_THISROW].[user]))+30) )

I suspect the problem may be a security filter I have on the bips table to restrict users to only their records. This security filter is vastly preferable to a slice to reduce loading times. Does this mean I won’t be able to issue reports for each user, though?