Recurring Tasks

Fibery Showcase
11

I decided to use Fibery AI build mode to tackle this instead of delegating to another team member. I did make one modification to my strategy: I want to reduce the number of fields in my task database, so I’m leveraging Fibery’s automations to compute the next due date and I am not using a field in my task database: Here is the log
PROMPT

In the Tasks database Create a dropdown called Recurrence
The options should be Weekly, Bi-Weekly, Monthly, Quarterly, Bi-Annually, Annually'
The dropdown needs it's own properties: +Days, +Months, +Year and each should contain the appropriate integer. These integers should default to the largest unit and the columns are mutually exclusive. Ex: Annually should have the value 1 in +Year and no values in +Days and +Months. 
Create an automation where whenever a recurring task is marked as done, the due date is updated to the current due date + the values from the Recurrence select properties AND sets the status to To Do

I did not make any changes when prompted to correct the logic.

OUTPUT

### ✅ Recurrence Setup Complete

* **Recurrence enum** and its integer fields (+Days, +Months, +Year) are created.
* **Recurrence field** is now available on Tasks.
* **Options** (Weekly, Bi-Weekly, Monthly, Quarterly, Bi-Annually, Annually) are set up, each with mutually exclusive values for +Days, +Months, +Year.

---

## 🚦 Automation Logic for Recurring Tasks

Fibery's API does not allow direct automation setup, but you can easily implement this logic using Fibery's built-in automation (via the Automations UI):

### **Automation Steps**

1. **Trigger:**
  * When a Task's State changes to **Done**
  * AND the Task's **Recurrence** field is not empty
2. **Action:**
  * **Update Due Date:**
Set the new Due Date to:

[Due Date] + [Recurrence].[+Days] days + [Recurrence].[+Months] months + [Recurrence].[+Year] years


(You may need to use Fibery's formula/automation builder for this calculation.)
  * **Set State:**
Change the Task's State to **Open** (or "To Do" if that's your preferred status).

---

### **Sample Automation Logic (Pseudocode for Fibery Automation UI):**

* **If:**

[State] changes to “Done”
AND [Recurrence] is not empty


* **Then:**

Update [Due Date] to:
DateAdd(
DateAdd(
DateAdd([Due Date], [Recurrence].[+Days], “days”),
[Recurrence].[+Months], “months”
),
[Recurrence].[+Year], “years”
)
Set [State] to “Open”


> **Tip:** In the Fibery Automation UI, use the "Update Entity" action and the "DateAdd" function (which is available in Fibery's formula language) to add days, months, and years as shown above.

---

If you need a more detailed step-by-step guide for setting up this automation in the Fibery UI, let me know!

**Your Recurrence dropdown and logic are now fully set up.**

When setting up the automation manually, I noticed that Fibery formulas won’t let you add a year to a date. So I removed the +Years column and used months for the Annual recurrence.

All around a good showing from Fibery AI

3 Likes