Aeion Views vs Airtable, Notion & Retool
Airtable charges $20/user/mo for saved views. Notion charges $15/user/mo. Retool charges $5/user/mo. Aeion Views is included free for every user in every tenant — filter presets, column management, 5 view types, custom dashboards, and conditional formatting.
Airtable: The Reference Implementation
Airtable invented the "saved views as a product" concept. It's the benchmark. Let's compare point by point.
What Airtable Does Well
Airtable's saved views are genuinely good:
- 5 view types — Table, Gallery, Kanban, Calendar, Gantt ✓
- Filter builder — AND/OR logic, relative dates ✓
- Column management — Reorder, resize, hide ✓
- Grouping — Group by any field, count/sum/avg ✓
- Conditional formatting — Color-coding rules ✓
- Shared views — Share with other Airtable users ✓
- Default views — Per-user default per view ✓
Aeion Views implements all of these. Same concepts, same capabilities, same UX patterns — in the Aeion admin, across every collection, from every module.
What Airtable Doesn't Do
Airtable's views are scoped to a single Airtable base. You can't:
- Share a view across bases
- Create a dashboard pulling from CRM deals + Commerce orders + Helpdesk tickets + Finance invoices in one screen
- Have a view that filters a collection defined by another module
- Use views as triggers in automation workflows
Aeion Views lives inside Aeion OS. A saved view on the "deals" collection works with the CRM module's deal-specific logic. A dashboard pulls from any module's widgets. The views layer isn't a separate tool — it's the OS's personalization system.
Where Your Data Actually Lives
Airtable's saved views live in Airtable's proprietary cloud, accessible only through Airtable's own API. If you ever move off Airtable, your view configurations don't come with you — they're locked to the platform.
Aeion's saved views live in your own tenant database, right next to the records they filter. Every view captures the same configuration — filter, sort, columns, grouping, conditional formatting, view type, sharing, and default status — using an open data model your team can query, export, or migrate at any time.
Same capabilities. Your database. Your data.
Notion: Wiki-First, Not Data-First
Notion has saved views for databases. But Notion is a wiki tool that added databases, not a data tool that added wiki features.
Notion's View Limitations
- No server-side saved views — Notion views are local/browser state. If you open Notion in a second browser, your view state is gone. Shared views require the other person to also open the same page.
- No dashboard workspaces — Notion has databases and pages, but no concept of a dashboard with widgets from multiple databases.
- No column management API — You can't programmatically create a view with specific columns. Everything is manual.
- No conditional formatting on relational fields — Limited to the current record's fields.
Notion's filter model:
AND conditions only at the top level
OR requires creating separate views
No field substitution ($currentUser, $today)
No arrayContains
Aeion's filter model — full QueryBuilder with 30+ operators:
AND, OR, NOT at any nesting level
$currentUser — current user substitution
$today, $week, $month, $quarter, $year — relative dates
arrayContains — array membership
exists/notExists — null checks
The fundamental difference: Notion's "views" are URL state (sort of like query params). Aeion's saved views are database records that persist across sessions, devices, and tabs.
Retool: Dashboards Yes, List Views No
| Feature | Retool | Aeion Views |
|---|---|---|
| List view saved filters | ❌ (not Retool's model) | ✅ |
| Column presets | ❌ | ✅ |
| Kanban boards | ❌ (needs custom component) | ✅ |
| Calendar views | ❌ | ✅ |
| Dashboard from multiple sources | ✅ | ✅ |
| No-code widget setup | ❌ (developer-built) | ✅ |
| Server-side persistence | ✅ | ✅ |
| Per-user defaults | Limited | ✅ |
| Shared team views | Limited | ✅ |
The Architecture Difference: Where Views Live
Airtable / Notion / Retool: Separate Product, Separate Database
Your Aeion CRM (orders, customers, products)
↓ (manual sync or third-party integration)
Airtable base
↓
Airtable's saved views
↓ (separate auth, separate permissions)
Your team accesses Airtable
Problems:
- Data sync lag between Aeion and Airtable
- Separate authentication (users have two logins)
- Separate permissions model (admins manage Airtable separately)
- Separate billing (Airtable adds to your SaaS stack)
- Separate backup/restore (two systems to protect)
Aeion Views: Same Database, Same Auth, Same Permissions
Your Aeion CRM (orders, customers, products)
↓ (zero sync — same data)
Aeion Views (same tenant database)
↓ (same auth, same tenant)
Your team accesses views in Aeion admin
Benefits:
- Zero sync lag (it's the same PostgreSQL database)
- Same authentication (Aeion login)
- Same permissions (tenant-level sharing controls)
- Same billing (no extra SaaS tool)
- Same backup (one database to protect)
This is the fundamental architectural advantage of a platform vs a point solution. Airtable saved views are a feature of Airtable. Aeion Views is a feature of the OS — it has access to every module's data natively.
Feature-by-Feature Comparison
| Feature | Airtable | Notion | Retool | Aeion Views |
|---|---|---|---|---|
| Filter operators (30+) | ✅ | ⚠️ (limited) | ❌ | ✅ |
| Relative dates ($today, $month) | ✅ | ❌ | ❌ | ✅ |
| Current user substitution | ❌ | ❌ | ❌ | ✅ |
| OR groups | ⚠️ (complex) | ⚠️ (separate views) | ❌ | ✅ |
| Array contains | ❌ | ❌ | ❌ | ✅ |
| Column reordering | ✅ | ⚠️ (limited) | ⚠️ (developer) | ✅ |
| Column visibility toggle | ✅ | ✅ | ⚠️ (developer) | ✅ |
| Server-side persistence | ✅ | ❌ (local state) | ✅ | ✅ |
| Shared views | ✅ | ⚠️ (manual) | ⚠️ (limited) | ✅ |
| Per-user defaults | ✅ | ❌ | ⚠️ (limited) | ✅ |
| Cost | $20/user/mo | $15/user/mo | $5/user/mo | **$0** |
| Feature | Airtable | Notion | Retool | Aeion Views |
| ---------- | ----------- | ------------ | ---------- | ----------- |
| List/Table | ✅ | ✅ | ✅ | ✅ |
| Kanban | ✅ | ⚠️ (limited) | ❌ | ✅ |
| Calendar | ✅ | ✅ | ❌ | ✅ |
| Gallery | ✅ | ✅ | ❌ | ✅ |
| Gantt | ✅ | ⚠️ (basic) | ❌ | ✅ |
| Cost | $20/user/mo | $15/user/mo | $5/user/mo | **$0** |
| Feature | Airtable | Notion | Retool | Aeion Views |
| ------------------------ | -------------------- | --------------- | ------------ | ---------------- |
| Multi-source widgets | ⚠️ (linked records) | ⚠️ (cross-page) | ✅ | ✅ |
| Module-native widgets | ❌ | ❌ | ⚠️ (custom) | ✅ (all modules) |
| No-code widget setup | ❌ | ⚠️ (basic) | ❌ | ✅ |
| 12-column grid layout | ❌ | ❌ | ✅ | ✅ |
| Per-widget configuration | ❌ | ❌ | ✅ | ✅ |
| Shared dashboards | ✅ | ⚠️ (manual) | ⚠️ (limited) | ✅ |
| Cost | Included (with base) | $15/user/mo | $5/user/mo | **$0** |
| Feature | Airtable | Notion | Retool | Aeion Views |
| ---------------------- | ----------- | ------------------ | -------------- | ----------- |
| Color-coded rows | ✅ | ⚠️ (property only) | ⚠️ (developer) | ✅ |
| Badge/indicator colors | ✅ | ❌ | ⚠️ (developer) | ✅ |
| Numeric thresholds | ✅ | ❌ | ⚠️ (developer) | ✅ |
| Date-based (overdue) | ✅ | ❌ | ⚠️ (developer) | ✅ |
| Multiple rules | ✅ | ⚠️ (limited) | ⚠️ (developer) | ✅ |
| Cost | $20/user/mo | $15/user/mo | $5/user/mo | **$0** |
The Hidden Cost: Context Switching
Your team is already using Aeion OS for CRM, Commerce, Finance, Helpdesk, and more. Adding Airtable for saved views means:
- Two logins — Users maintain credentials for Aeion and Airtable
- Two interfaces — The mental context switch between Aeion's workflow and Airtable's interface
- Two permission models — Admins manage Aeion users and Airtable users separately
- Two billing cycles — Airtable adds to your SaaS budget
- Two data sync points — Orders in Aeion must sync to Airtable (lag, failure points)
- Two backup strategies — Restore from Aeion backup + Airtable backup
Every sync point is a failure point. The more systems you have, the more places data can get out of sync.
With Aeion Views:
- One login — Aeion authentication
- One interface — The Aeion admin
- One permission model — Tenant-level access control
- One bill — Included in Aeion OS
- Zero sync — Views operate on the same database as the data
- One backup — PostgreSQL full dump
Your team is already in Aeion OS. Keep them there.
Views Are Part of the Platform, Not a Bolt-On
Aeion Views integrates with the broader Aeion OS platform in ways standalone tools cannot:
Views as Part of Automated Workflows
A Blueprint automation can create a personalized default view the moment a trigger fires — for example, when a new sales rep is added to the team, a workflow automatically generates their "Welcome: Your Deals" view, filtered to their own assigned deals and sorted by close date, and notifies them it's ready. No admin has to manually configure the new rep's workspace.
Dashboard Widgets from Any Module
Every Aeion module contributes its own widgets to the dashboard catalog — CRM's pipeline overview, Commerce's revenue-today tile, and so on. When a user builds a dashboard, they see widgets from CRM, Commerce, Helpdesk, Finance, Fulfillment, and every other installed module automatically. No manual integration required — the widget catalog is simply the list of modules you've installed.
The Integration Advantage: Views and the Broader OS
| Integration | What Happens |
|---|---|
| **CRM** | Saved view on deals applies CRM-specific filters (owner, stage, temperature) |
| **Commerce** | Saved view on orders applies order-specific filters (fulfillment status, payment status) |
| **Helpdesk** | Saved view on tickets applies SLA-based filters (first response due, priority escalation) |
| **Fulfillment** | Saved view on shipments applies tracking-specific filters (carrier, delivery window) |
| **Finance** | Saved view on invoices applies accounting-specific filters (aging bucket, GL account) |
| **Blueprint** | Saved views can be created/updated/deleted as workflow steps |
| **Notifications** | Get notified when a teammate shares a new view with you |
FAQ
The filter `{ owner: { equals: "$currentUser" } }`is evaluated at query time against the authenticated user making the request. A shared view using`$currentUser` shows different records to each user — User A sees their deals, User B sees their deals. This is a saved view that personalizes itself.
When you set a new default, Aeion automatically unsets the previous one as part of the same save — the moment your new default is confirmed, the old one is cleared. If two teammates set different defaults for themselves at the same moment, each person's own default is handled independently and deterministically — no conflicting state, no manual cleanup.
Yes — export any view as CSV or JSON directly from the admin, the same way you'd export any collection. Exporting as JSON preserves the full filter, sort, and grouping configuration.
Airtable shared views are shareable by URL — anyone with the link can view. Aeion shared views are tenant-scoped: a user must be authenticated to the Aeion tenant and must have read access to the collection to see a shared view. It's more secure, but requires Aeion authentication.
Yes — the Saved Views API accepts view definitions as JSON, which is exactly what Blueprint workflows use to auto-create views for new users. See the API reference.
Every module ships its own set of dashboard widgets, and they all appear automatically in a shared widget catalog. When you add a widget to your dashboard, Aeion places it at the grid position you choose — no manual wiring between modules required.
The view remains available to the team. Other users can continue to use it. Only admins can delete it, and the original creator is preserved for audit purposes.
Yes — the Saved Views API returns the full view configuration, including its filter definition, which you can reuse in subsequent collection queries. Filters use the same operator syntax everywhere in Aeion, whether applied through the UI or the API.
Filters using `$today`, `$week`, `$month`, `$quarter`, `$year` are evaluated at query time. A view named "Closing This Month" with `{ closeDate: { gte: "$today", lt: "$month" } }` will always show deals closing in the current month, regardless of when the view was saved.