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:
Monday at 9am
[FTFL Schedule].Filter([FTFL Schedule].Date= Today())
(if this condition returns
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.