Bot triggered by any record having a value FALSE

[Stobber]

I need a bot to send an email to the superuser when any record in a table has the [notified] column equal to FALSE. The table might have hundreds of records, and I only want to notify the user (via email) of "new" records, which will have [notified] = FALSE.

How can I implement this?

To prevent sending one email per record, I thought to set up the bot to run on an hourly schedule with a condition expression using OR. But I know how to write the expression to look across all rows. And really, I'll need it to SELECT rows with [notified] = FALSE, so that selection can be referenced by the email in the bot's process.

Any help on designing this is appreciated!

[SkrOYC]

[notified] should be of column type "Yes/No" and you can deal with it the following way:

[notified] when wanting to check if it's Yes/True
NOT([notified]) when wanting to check if its No/False

[Stobber]

That works for a row-level action, but I'm trying to do this at table-level. That is, I want to check [notified] on all rows and take an action only on the rows where [notified] is False/No. How can I do that?

[SkrOYC]

With an "execute an action on a set of rows"?