Resetting Status daily

Feature requests
1

I need to know on a daily basis which items have new time-tracking information (users have added, deleted or modified time entries). I also need this to query board items by API. For this I tried setting up the following automations:
Columns:
TimeStatus (on-off, default off).
TimeDate column (set to today’s date on item creation).

  1. When Time Tracking Column changes, set TimeStatus to ON.
  2. When TimeStatus changes to ON, push TimeDate by one day.
  3. When TimeDate arrives, if TimeStatus is ON, set it to OFF.

I thought this way I could just filter/Query by TImeStatus=ON. However, if an item’s time tracking doesn’t change at all for one or more days, when it does change, the TimeDate for that item is pushed just one day, which could be a date in the past.

This would be very easy for there was a recipe that said “every period of time, if TimeStatus is ON, change TimeStatus to OFF”.

Suggestions?

2

You could add a step in step 2 that sets the date to today, so it would look like:

When Time Tracking Column changes, set TimeStatus to ON.
When TimeStatus changes to ON, set TimeDate to today, then push TimeDate by one day.
When TimeDate arrives, if TimeStatus is ON, set it to OFF.

Hope this helps!