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?