I created a button in a table which sends a message to Slack when I click on it.
I want to do a time based automation based on Today’s date. Each row has a due date and I want to push that button when Due date = Today and then Due date = Today + 14 days etc. But for some reason SwitchIf is not working…
Ohh this looks like since fiction. But I don’t really get how is it connected to my challenge? I do not have duration. I have exact dates and I want to compare them to Today’s date and send message if it will be due, 14 days later, 7 days later, 1 day later and so on.
Or maybe I did not catch the meaning of your article right?
@Egyesek_Youth_Association , it can all feel rather overwhelming, however a bit down in that tread you find my contribution that deals with the 9 month question. I used a check box in this context to flag it it is time to set some action (delete in the example, but it can be any action). You can do something like that. Have a look, it is not that difficult.
Since this is a Time-based automation, I can’t really refer to “thisrow” as there is no action which would actually point to what is “thisrow” and in this way I can’t match Today() to thisrow.DueDate. So indeed, I will need some sort of .filter. So I should actually .Filter(Today()) or .Filter(Today()+Days(14)) but then how can I refer to only those Buttons in which are in the rows matching the Filter criteria? Since thisrow will still not work after .Filter.