"Database Automations" Bring Advanced Functionality to Databases and Views

Follow along with the examples below to see several different ways database automations can be used. The only limit is your imagination!

Note: database automations may take up to three seconds to execute.

<aside> <img src="/icons/gears_gray.svg" alt="/icons/gears_gray.svg" width="40px" /> Automatically capture task completed date

1. Tick the “Done” checkbox

Watch the “Completed Date” property populate with today's date.

</aside>

Database Automations.Tasks

<aside> <img src="/icons/gears_gray.svg" alt="/icons/gears_gray.svg" width="40px" /> Automatically capture last completed date and reset recurring task

1. Tick the “Done” checkbox

Watch the “Last Completed Date” property populate with today's date and the “Done” checkbox reset.

</aside>

Database Automations.Recurring Tasks

<aside> <img src="/icons/gears_gray.svg" alt="/icons/gears_gray.svg" width="40px" /> Automatically change status for tasks assigned to sprints

1. Assign a sprint to each task in the backlog

Watch the task status change from “Backlog” to “Pending”.

</aside>

Database Automations.Task Backlog

<aside> <img src="/icons/gears_gray.svg" alt="/icons/gears_gray.svg" width="40px" /> Automatically reassigned blocked tasks to manager

1. Change task status from “In progress” to “Blocked”

Watch the “Assigned to” property populate with the manager's name (in this example, ME).

</aside>

Database Automations.Task Delegation

<aside> <img src="/icons/gears_gray.svg" alt="/icons/gears_gray.svg" width="40px" /> Automatically create a new status report when a sprint is closed

1. Change sprint status from “In progress” to “Completed”

Watch a new status report generate from a template in the status report database and attach to the sprint.

</aside>

Database Automations.Sprints

Database Automations.Status Reports