Hi Community
Im trying to run an automation to send an email when there are no records entered for the day.
So I created a slice called TodaysRecords where the Date column is equal to Today.
I’ve then created a scheduled automation.
I’ve scheduled it to run at 3pm and only if
and (ISBLANK (TodaysRecords [TR_ID]), OR (TODAY()<>1, TODAY()<>7))
This is not running at all when I use the Monitor function.
What else can I try?
To be clear: Automation runs appear in the Automation Monitor only if their event, including any condition, triggers.
The TODAY function returns a date, such as 1/23/2023, not a number like 1 or 7. Potentially, the problem in your expression is simply one of data types. Regardless, if you test an expression comparing TODAY to an integer from 1-7, you’ll see that it returns false in every case:
Perhaps you intend to exclude Sundays and Saturdays, in which case you likely should use instead the WEEKDAY function. If that’s your goal, then you also wouldn’t use OR. Here’s a new draft to modify and experiment with.
AND(
ISBLANK(
TodaysRecords[TR_ID]
),
WEEKDAY(TODAY()) <> 1,
WEEKAY(TODAY()) <> 7
)