Hello everyone!
I've made this Table:
The idea with the table is to show different kind of tasks, sorted by Week and Day.
Right now when a task is completed, I will click on the 'Næste gang?' field and choose whether the task should be listed in the daily or weekly view. If it's a daily task, I will choose 'Daglig' and for weekly tasks I will choose 'Ugentlig'.
However when I do that, this happens:
Instead of the task being re-created in the right view, it's being added in an Empty view. I therefore manually have to add it to the right view by clicking in the 'Hyppighed' field and select either Weekly or Daily.
What I want here is the task to automatically be added to the right view.
Also I really want to just be able to click in a check box when the task has been made and then Airtable knows which view the task belongs to instead of have to choose the right one in 'Næste gang?'
Are the 2 above improvements possible to do?
You can't add a formula in the automation, but you can change the formula a little in this way.
So when you check the checkbox, automatically will calculate the new due date and the automation will add the "Weekly/Daily" Status
So I just made a test, and what you just wrote happens. Good!
But what I want is the calculated due date to be inserted into the 'Deadline' field and then the checkbox unchecked, so that when the task is made the next day (it's recurring tasks), the same thing will happen. In other words: the Record to be recreated in a loop. Right now when I check the checkbox, it will just find the new coming due date in the 'Calculation' field which means that I manually have to remake the Record, and that's not what I hope to do.
Does it make sense?
