# Checkbox with automation on a due date

**URL:** <https://connect.superhuman.com/t/checkbox-with-automation-on-a-due-date/15776>\
**Category:** Ask the Community\
**Created:** [May 8, 2020, 12:13pm UTC](https://connect.superhuman.com/t/checkbox-with-automation-on-a-due-date/15776 "2020-05-08T12:13:34Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Benjamin\_Bachman](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/benjamin_bachman/32/12410_2.png) [@Benjamin\_Bachman](https://connect.superhuman.com/u/Benjamin_Bachman)\
**Post date:** [May 8, 2020, 12:13pm UTC](https://connect.superhuman.com/t/checkbox-with-automation-on-a-due-date/15776/1 "2020-05-08T12:13:34Z")

</div>

I am wondering if anyone can help me think through how to execute the following.

I have a due date (date field) and a “today” (checkbox field).

I want want to run a workflow at 6:00 am each morning to look at all items that have a due date as today and check the “today” checkbox in the same row.

Thoughts anyone?

---

<div class="post-metadata">

**Author:** ![Paul\_Danyliuk](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/paul_danyliuk/32/27228_2.png) [@Paul\_Danyliuk](https://connect.superhuman.com/u/Paul_Danyliuk)\
**Post date:** [May 8, 2020, 12:30pm UTC](https://connect.superhuman.com/t/checkbox-with-automation-on-a-due-date/15776/2 "2020-05-08T12:30:18Z")

</div>

Well, you can set up an automation to run every day at 6 AM and in the action (“then” step) do the following:

```auto
YourTable.Filter(CurrentValue.[Due date] = Today()).ModifyRows(YourTable.Today, true)

```

But what is it that you’re trying to achieve? I could see a column formula `thisRow.[Due date] <= Today()` working just as well, unless you want to be able to uncheck that? (but then I’d imagine rescheduling a due date would be more logical than setting Today to false)

---

<div class="post-metadata">

**Author:** ![Benjamin\_Bachman](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/benjamin_bachman/32/12410_2.png) [@Benjamin\_Bachman](https://connect.superhuman.com/u/Benjamin_Bachman)\
**Post date:** [May 8, 2020, 12:36pm UTC](https://connect.superhuman.com/t/checkbox-with-automation-on-a-due-date/15776/3 "2020-05-08T12:36:24Z")

</div>

> [@Paul\_Danyliuk](#):
>
> ```auto
> YourTable.Filter(CurrentValue.[Due date] = Today()).ModifyRows(YourTable.Today, true)
> 
> ```

This is great!!! Thank you so much. Sometimes it is the formulas that trip you up. Appreciate it.