I have a to-do list with assigned people. I want to setup an automation which sends a Slack private message to the task owner 1 week before the task due.
So there is Task - Due Date - Owner. All 3 columns have different values and I only want to send reminders to Slack from those tasks which due dates are within 1 week and I want to send it to the specific person who is the owner of the task.
I was testing to setup an automation but I can’t get my head around how to formulate the “IF” part in the Automation.
Trigger - daily: Each day 10 a.m. the automation triggers
IF Due date is Today + 7 days —> Tasks.[Due date]= Today() + Days(7)
Then send a private Slack message to the task owner
Now. I understand that there is a flaw in this logic as at the IF part the output will be all those tasks which falls under the condition, but then how can I separate them to send Task 1,2,3 to one person and Task 4,5,6 to another person in Slack.
Also the IF formula always give false somehow, I can’t really set it properly.
Any thought how can I do this?
Link to doc: 155. Solidarity Roots