I’ve been trying to solve this thing for almost a month, coming from notion, and now asana because somehow asana offers a rule when due date is approaching, but unfortunately, it doesn’t apply to custom fields.
Here’s some context on what I’m trying to solve:
From asana, basically I want the same feature that the due date rule offers, but instead on the due date, I want it to run on a custom field with the date on it.
I basically want to send a slack message on a specified channel to remind everyone about the said date, for example, “asset deadline” is almost due.
And I basically want this to function on each task on all projects in the workspace. Like a workspace-wide kind of monitoring thing.
Based on the screenshot above, so far, I have come up with a scheduled trigger, don’t mind the by every hour, it’s supposed to be every day, and it finds a static task in asana where it will extract the custom field’s date. Right away, it’ll be updated to 3 days forward for tomorrows’ cycle. Next is the API request, where I try to filter all tasks that contains the extracted date from the find task, however the problem I’ve been facing is that the API completely ignores the condition, and it extracts everything without exception, for as long as that custom field date exists in a task, it will be dragged on the data output.
