Help! I’m trying to create an automation that sends a Slack message IF it finds today’s date in the table. For some reason, my IF condition is resulting in true even when today’s date isn’t present in the table.
My automation looks like this:
WHEN
Monday at 9am
IF
[FTFL Schedule].Filter([FTFL Schedule].Date= Today())
(if this condition returns true)
THEN
Slack: Post Message
concatenate([FTFL Schedule].Filter(Date = Today()).First(),", it's your week to post to <https://ftfl.herokuapp.com/sign_in|FTFL> and host retro!")
When I test this rule, it posts a slack message regardless of what date is found, but is just blank rather than tagging a user.
