Oct 04, 2021 10:35 AM
I’m looking for an automation that can change a date field. Basically I want any dates before today to update to today’s date (in a date field).
Trigger: if Status Due is before today
Action: Update Status Due date to today’s date
Oct 04, 2021 02:11 PM
One approach:
Et voilà! Only trick here is, you need to run this manually.
.
I tried to write an automation for this but ran into a triggering problem I don’t have time to think about. Approach above, while manual, is otherwise solid and easy. One advantage of the Batch Update app is that it knows on its own when Today is. The Automation setup process doesn’t: I think you’d have to create a formula field whose result is Today().
.
Final, important note: I NEVER do this and for what it’s worth, apps like Todoist don’t do this either. In my view, this approach destroys data. There is a difference between
In other words, it’s useful to be able to identify overdue tasks and further, to be able to see how overdue they are. So all I do is create a view called “Overdue”, filter as suggested at the top in step 1, and leave it at that.
But if you want to do this, there’s your answer. :slightly_smiling_face: