Date Field Trigger
The Date Field trigger fires based on dates stored in your TinyTable columns. Set up rules like "1 day before the due date" or "2 hours after the event date", and the workflow fires automatically for each matching row.
Internal name: SHEET_DATE_FIELD_TRIGGER
Node color: Violet (#8B5CF6)
Setting it up
-
Click the Trigger Setup node
-
Select Spreadsheets → Date Field Trigger
-
Configure the source and timing rules:
Configuration fields
| Field | Description |
|---|---|
| Which spreadsheet? | Dropdown listing all sheets in your workspace |
| Which table? | Dropdown listing tables within the selected sheet |
| Date column | Dropdown filtered to date-type columns only (date, datetime, createdTime, lastModifiedTime) |
| Timing rules | One or more rules defining when to fire relative to the date |
Timing rules
Each rule has three parts:
| Field | Options | Description |
|---|---|---|
| Timing | Before, Exact, After | When to fire relative to the date value |
| Offset value | 1–999 | How far before or after (hidden for "Exact") |
| Offset unit | Minutes, Hours, Days, Weeks | Time unit for the offset (hidden for "Exact") |
You can add multiple rules with the + Add rule button. Each rule fires independently. Minimum 1 rule required.
Examples:
| Rule | Fires when |
|---|---|
| Before · 1 · Day | 24 hours before the date value |
| Exact | At the exact date/time |
| After · 2 · Hours | 2 hours after the date value |
| Before · 1 · Week | 7 days before the date value |
Use cases
Task deadline reminders
- Date column:
due_date - Rule 1: Before · 1 · Day → "Your task is due tomorrow"
- Rule 2: Exact → "Your task is due now"
- Rule 3: After · 1 · Day → "Your task is overdue"
Event follow-ups
- Date column:
event_date - Rule: After · 2 · Hours → Send follow-up survey
Subscription renewals
- Date column:
renewal_date - Rule 1: Before · 7 · Days → Send renewal reminder
- Rule 2: Before · 1 · Day → Send final reminder
- Rule 3: Exact → Process renewal
Output variables
| Variable | What it contains |
|---|---|
{{trigger.row}} | The full row data for the matching record |
{{trigger.row.fieldName}} | A specific field from the row |
{{trigger.dateField}} | The date value that triggered the rule |
{{trigger.rule}} | Which timing rule fired |
Validation
- Spreadsheet and table must be selected
- Date column must be selected (only date-type columns are shown)
- At least one timing rule required
- Non-exact rules must have an offset value of at least 1
Tip
Use multiple timing rules on the same trigger to create reminder sequences (e.g., 7 days before, 1 day before, and on the day).