Scheduled report by record non existent

[Joshsbk]

I would like to make a scheduled report for if a employee has not created a daily time card record within 5 minutes of arrival. For the “if this is true…” portion would I use a ISBLANK(SELECT()) expression to see if a specific type of row is missing?

[Steve]

Joshsbk:

would I use a ISBLANK(SELECT()) expression to see if a specific type of row is missing?

Yep!

[Joshsbk]

Ok so I have been using this report for a while and I like the feature. I used this “If True” expression:

ISBLANK(FILTER(Job Board, AND([Account Name].[Account Name] = “Sign In Sheet”, [Date] = TODAY(),[Crew Leader].[First Name] = “Josh”)))

I am having a hard time figuring out how to scale this up to iterate through the [Crew Leader] table to see if each crew leader has created a “Sign in Sheet” and if not send that crew leader a text to remind him to sign in.