Validation rules
Keep Notion databases clean with consistent, automated checks.
12 rules
Schema
Required properties
Ensure every record has required fields like Name and Status.
Integrity
Unique identifiers
Prevent duplicates by enforcing unique IDs or codes.
Workflow
Allowed status values
Restrict status fields to the approved workflow stages.
Dates
Date order
Flag items where a start date is after the end date.
Dates
Date range
Keep dates within the expected reporting window.
Format
Email format
Validate that email fields use a valid address format.
Format
URL validation
Check that URLs are well-formed and use https when possible.
Numbers
Number ranges
Enforce min/max values for budgets, scores, and counts.
Relations
Relation integrity
Ensure linked records exist and are active.
Automation
Rollup freshness
Detect stale rollups or mismatched formula outputs.
Content
Text length
Apply min/max length limits to titles and descriptions.
Governance
Owner assigned
Require an owner to keep accountability clear.