Run a recurring job on custom days with an equation

In this article, we’ll walk you through creating a dynamic recurring task in Tadabase. This setup allows you to determine if a task should run today…

  • Not yet re-checked
  • Classic builder

Moved from our previous help site and not yet re-checked against the current product. Last edited Aug 5, 2025.

On this page
  1. Creating Dynamic Recurring Tasks in Tadabase
  2. Fields Required
  3. The Equation
  4. Breakdown of the Equation
  5. How to Implement
  6. Step 1: Create the Fields
  7. Step 2: Add the Equation
  8. Step 3: Test the Equation
  9. Example Scenarios
  10. Conclusion

Creating Dynamic Recurring Tasks in Tadabase #

In this article, we’ll walk you through creating a dynamic recurring task in Tadabase. This setup allows you to determine if a task should run today based on specific values in a record. By the end, you’ll have a working equation that dynamically calculates task schedules based on recurrence fields.

Fields Required #

To build this setup, you’ll need the following fields:

  1. Recurring: A field to indicate whether the task is recurring (e.g., a checkbox or toggle).
  2. Frequency: A field to specify how often the task recurs (e.g., 'daily', 'weekly', 'monthly').
  3. Day of the Week: A field to capture the day of the week for weekly tasks (e.g., Sunday, Monday, etc.).
  4. Day of the Month: A field to specify the day of the month for monthly tasks (1-31).
  5. Current Date: An equation field that sets the current date.

The Equation #

Here is the complete equation to determine if today is the day the task should run:

Text
IF({Recurring} = 1 AND {Frequency} = 'daily', 
        1,
        IF({Recurring} = 1 AND {Frequency} = 'weekly' && DAYOFWEEK({Current Date}) = 
            IF({Day of Week} = 'Sunday', 1,
               IF({Day of Week} = 'Monday', 2,
                  IF({Day of Week} = 'Tuesday', 3,
                     IF({Day of Week} = 'Wednesday', 4,
                        IF({Day of Week} = 'Thursday', 5,
                           IF({Day of Week} = 'Friday', 6,
                              IF({Day of Week} = 'Saturday', 7, NULL)
                           )
                        )
                     )
                  )
               )
            ), 
            1,
            IF({Recurring} = 1 AND {Frequency} = 'monthly' &&  DAYOFMONTH({Current Date}) = {Day of the Month},
                1,
                0
            )
        )
    )

Breakdown of the Equation #

  1. Daily Tasks:
  2. — If {Recurring} is checked and {Frequency} is set to 'daily', the task is due today (1).
  3. Weekly Tasks:
  4. — Checks if {Recurring} is checked and {Frequency} is 'weekly'.
  5. — Uses DAYOFWEEK(CURDATE()) to determine if today matches the day stored in the {Day of the Week} field.
  6. — Maps days of the week (e.g., Sunday = 1, Monday = 2) to their respective numeric values.
  7. Monthly Tasks:
  8. — If {Recurring} is checked and {Frequency} is 'monthly', it checks if today’s date (DAYOFMONTH(CURDATE())) matches the value in {Day of the Month}.
  9. Default Case:
  10. — If none of the conditions are met, the output is 0 (not due today).

How to Implement #

Step 1: Create the Fields #

  1. Add a Decision Field field for Recurring.
  2. Add a Select Dropdown field for Frequency with options:
  3. — 'daily'
  4. — 'weekly'
  5. — 'monthly'
  6. Add a dropdown field for Day of the Week with options:
  7. — Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday.
  8. Add a number field for Day of the Month (range: 1-31).
  9. Add an equation field called "Current Date" and set it as CURRENT_DATE()
Screenshot for “How to create a recurring task based on custom values”

Step 2: Add the Equation #

  1. Navigate to the Equations section in Tadabase.
  2. Create a new equation field.
  3. Copy and paste the equation above into the equation editor.
  4. Make sure you're NOT using the Equations V2
  5. Save the equation.
Screenshot for “How to create a recurring task based on custom values”

Step 3: Test the Equation #

  • Input various combinations of values into the fields and verify if the equation outputs 1 when the task is due today and 0 otherwise.

Example Scenarios #

RecurringFrequencyDay of the WeekDay of the MonthIs Due Today
YesdailyNULLNULL1
YesweeklyMondayNULL1 (if today is Monday)
YesmonthlyNULL191 (if today is the 19th)
NoNULLNULLNULL0

Conclusion #

This setup ensures your tasks dynamically adapt based on the values in their records, making scheduling and tracking more efficient. If you have any questions or need further assistance, feel free to reach out to Tadabase support.

Was this page helpful?

Something wrong or missing on this page? Tell us.