1. Create a database template.
2. Create database automation.
3. Set trigger (e.g., weekly time).
4. Set action: Create new entry, select template.
To enable recurring database entries based on a template, first create the database template, then configure database automation to periodically trigger (e.g., weekly) and set the action to ‘Create new entry’, selecting that template. Copy-paste this setup method.
The Syntax Breakdown
- Database Template: A predefined page structure within a database, including pre-filled properties and page content. Templates serve as blueprints for new database entries.
- Database Automation Trigger: A time-based schedule (repeating daily, weekly, monthly, or yearly) or property change that initiates the automation sequence. For recurring tasks, this is always a repeating time interval.
- Database Automation Action: The specific operation executed when the trigger is activated. In this scenario, the action must be set to
Create new entry. Crucially, the desired database template must be selected within this action to pre-populate the new entry.
Real-World Example: Daily Infrastructure Checks
An operations manager requires a new Daily Infrastructure Check entry to be generated automatically every weekday morning in the System Logs database.
Mock Data Table (before automation):
| Check Name | Date | Status | SRE | Notes |
| – | – | – | – | – |
Application of Setup:
- Define Template: Create a database template named
Infrastructure Check Template, pre-fillingCheck Name(perhaps with@todaytoken in Title, though not natively dynamic in title without@todaybeing part of the title configuration, often better handled in properties or just naming template conceptually),Statusproperty asPending, and empty properties forSREandNotes. - Configure Automation: Navigate to database
Automations, creating a new automation.- Set
Trigger: ChooseRepeating, configuring forEvery Weekdayat 8:00 AM. - Set
Action: ChooseCreate new entry, and selectInfrastructure Check Template.
- Set
Output: Every weekday at 8:00 AM, a new entry (e.g., Infrastructure Check Template) is automatically created in the database. The Date property will default to the current date if configured as @today in a text title/property, Status will be Pending, and the SRE/Notes properties will be blank, ready for the engineer to fill out.
Common Errors & How to Fix Them
- Automated entries are created, but they are blank or don’t use the pre-filled template information. Fix: Edit the automation action, click ‘Select template’, and choose the correct template.
- Recurring entries are not being generated on schedule. Fix: Review automation trigger settings, verify frequency and time are accurate, and ensure automation is toggled ON.