# Tasks Notification workaround

**URL:** <https://community.noloco.io/t/tasks-notification-workaround/1777>\
**Category:** Ask for Help\
**Created:** [March 7, 2025, 3:18pm UTC](https://community.noloco.io/t/tasks-notification-workaround/1777 "2025-03-07T15:18:53Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![garyGHL](https://dub1.discourse-cdn.com/flex005/user_avatar/community.noloco.io/garyghl/32/555_2.png) [@garyGHL](https://community.noloco.io/u/garyGHL)\
**Post date:** [March 7, 2025, 3:18pm UTC](https://community.noloco.io/t/tasks-notification-workaround/1777/1 "2025-03-07T15:18:53Z")

</div>

Hi all, I’ve had a problem for a while now where I needed to run workflows based on dates, in case it helps anyone I’ve found a way, albeit, a touch amateur and messy 😳. If you know of a better solution please do let me know.

In my scenario I want to check if a task is due today and alert the record owner.

I created a new formula field in the task table as below.

IF(DateDue = TODAY(), “yes”)

Then created a workflow to watch this field for an update, theoretically, if the DueDate is today it fires an email off with the details.

**Edit** Spoke to soon. If a task is created today for a due date 10th March (or any date), it inserts ‘False’ into the field and sends the email ☹ Anyone know how to not have that formula only update if DueDate is today. So close and still miles off 🥲

---

<div class="post-metadata">

**Author:** ![EthosLuke](https://avatars.discourse-cdn.com/v4/letter/e/46a35a/32.png) [@EthosLuke](https://community.noloco.io/u/EthosLuke)\
**Post date:** [March 7, 2025, 4:19pm UTC](https://community.noloco.io/t/tasks-notification-workaround/1777/2 "2025-03-07T16:19:03Z")

</div>

Unless I’m misunderstanding, can’t you add a filter into your workflow to only proceed if your formula field = yes?

---

<div class="post-metadata">

**Author:** ![garyGHL](https://dub1.discourse-cdn.com/flex005/user_avatar/community.noloco.io/garyghl/32/555_2.png) [@garyGHL](https://community.noloco.io/u/garyGHL)\
**Post date:** [March 7, 2025, 5:34pm UTC](https://community.noloco.io/t/tasks-notification-workaround/1777/3 "2025-03-07T17:34:50Z")

</div>

Yes, that’s what I missed 🙂

Thank you

---

<div class="post-metadata">

**Author:** ![garyGHL](https://dub1.discourse-cdn.com/flex005/user_avatar/community.noloco.io/garyghl/32/555_2.png) [@garyGHL](https://community.noloco.io/u/garyGHL)\
**Post date:** [March 10, 2025, 10:13am UTC](https://community.noloco.io/t/tasks-notification-workaround/1777/4 "2025-03-10T10:13:33Z")

</div>

Hmmm, this didn’t work anyway, jumped the gun on it 😳 The workflows wont run unless the field is updated.

So, if I create a task for Friday, the formula is only run when its created.

Back to the drawing board.

---

<div class="post-metadata">

**Author:** ![thecasemaster](https://dub1.discourse-cdn.com/flex005/user_avatar/community.noloco.io/thecasemaster/32/1196_2.png) [@thecasemaster](https://community.noloco.io/u/thecasemaster)\
**Post date:** [March 20, 2025, 7:06pm UTC](https://community.noloco.io/t/tasks-notification-workaround/1777/5 "2025-03-20T19:06:04Z")

</div>

are you building exclusively in noloco or using something like airtable for the back end?

---

<div class="post-metadata">

**Author:** ![garyGHL](https://dub1.discourse-cdn.com/flex005/user_avatar/community.noloco.io/garyghl/32/555_2.png) [@garyGHL](https://community.noloco.io/u/garyGHL)\
**Post date:** [March 20, 2025, 7:19pm UTC](https://community.noloco.io/t/tasks-notification-workaround/1777/6 "2025-03-20T19:19:32Z")

</div>

Noloco only (MySQL backend). I don’t see how I can achieve this with workflows with triggers unfortunately.

Effectively the workflow should only run IF date = today in this example.

---

<div class="post-metadata">

**Author:** ![thecasemaster](https://dub1.discourse-cdn.com/flex005/user_avatar/community.noloco.io/thecasemaster/32/1196_2.png) [@thecasemaster](https://community.noloco.io/u/thecasemaster)\
**Post date:** [April 3, 2025, 7:45pm UTC](https://community.noloco.io/t/tasks-notification-workaround/1777/7 "2025-04-03T19:45:10Z")

</div>

I’ve not verified this can be done but my thought would be to use an external automation service to run the if/then scenario and then update a checkbox field, or something similar, in noloco to trigger the workflow. then just have the workflow watch that specific field for changes.

---

<div class="post-metadata">

**Author:** ![jakeliddell](https://dub1.discourse-cdn.com/flex005/user_avatar/community.noloco.io/jakeliddell/32/1333_2.png) [@jakeliddell](https://community.noloco.io/u/jakeliddell)\
**Post date:** [June 5, 2025, 9:01pm UTC](https://community.noloco.io/t/tasks-notification-workaround/1777/8 "2025-06-05T21:01:52Z")

</div>

I do this on an app with a zapier trigger, that updates once a week. Zapier updates the record, then the Noloco workflow triggers.
