Skip to content

Core Features

SmartTable provides a complete set of tools for personal productivity, team collaboration and plugin-based extensibility. This page summarizes the main capabilities you will use every day.

Multiple Views

SmartTable supports 7 view types. Each view is a different lens on the same table data, with its own filters, sorts, and display options:

ViewDescription
Table ViewClassic grid with virtual scroll, column freeze, and field filtering
Grouped ViewGroup records by one or more fields with collapsible sections
Kanban ViewCard-based board with drag-and-drop column movement
Calendar ViewDate-based layout for events and deadlines
Gantt ViewProject timeline with task bars and dependencies
Form ViewPublic-facing data collection form
Gallery ViewImage and media card grid

Rich Field Types

SmartTable offers 27 field types across 10 categories. See Field Types for full details.

CategoryExamples
TextSingle Line Text, Long Text, Rich Text
NumericNumber (integer/decimal/currency/percent)
DateDate, Date Time
SelectionSingle Select, Multi Select, Checkbox
People & ContactMember, Phone, Email, URL
MediaAttachment (images, files, thumbnails)
ComputedFormula with 47 built-in functions
RelationLink, Lookup with aggregation
SystemCreated By, Created Time, Updated By, Updated Time, Auto Number
GeolocationGeolocation (province/city/district, country/region, lat-lng, map picker, multi-language)
OthersRating, Progress

Data Processing

Work with large datasets using advanced data tools:

  • Filtering — Combine multiple conditions with AND/OR logic and 20+ operators.
  • Sorting — Sort by multiple fields and drag to change priority.
  • Grouping — Group by up to 3 fields with group-level statistics.
  • Formula Engine — Reference fields and nest 47 functions for math, text, date, logic, and statistics.
  • Streaming Data Loading — First screen renders in seconds for 10,000+ rows; remaining pages load asynchronously in the background.
  • Import & Export — Move data in and out using Excel, CSV, or JSON.

Workflow Automation

The visual workflow engine (new in v1.6.0) helps you automate repetitive tasks:

  • Triggers — Specified time, record creation, or record update.
  • Action Nodes — Create record, update record, call webhook, or branch on conditions.
  • Versioning — Save snapshots, view history, and roll back changes.
  • Management — Pause, resume, edit, and bind workflows to tables.

Read more in Workflow Automation.

Plugin System (Extensibility)

SmartTable ships with a plugin mechanism that extends the table beyond built-in features while keeping clear security boundaries:

  • Two plugin types
    • UI plugins run inside a sandboxed iframe (sandbox="allow-scripts", opaque origin — no access to host cookies, localStorage or DOM). The host injects a Vue 3 runtime, so plugins can be written with standard Vue template syntax (v-model, v-for, @click, reactive data) as a single file — no build step required.
    • Script plugins run in a restricted subprocess (module allowlist, dangerous builtins removed); data operations are proxied and authorized as the triggering user.
  • Lifecycle: upload/install, global enable/disable, base-level install/enable/remove, upgrade, rollback to a previous version, and uninstall — all from the plugin management page. Base pages have no install entry: enabled plugins are ready to use.
  • Two-level configuration: global and base scopes (base is deep-merged over global), validated against the plugin's configSchema.
  • Two-layer permissions: plugin manifest declarations plus user RBAC, deny by default, enforced per method on the host side.
  • Selection channel: records selected in the table are passed to the plugin as an open-time snapshot (IDs only, capped at 1000, with select-all/truncated flags). Extension points may declare requiresSelection / maxSelection; the host disables the entry with a hint when unsatisfied.
  • Safety: short-lived signed URLs for the sandbox, zip path-traversal and zip-bomb protection, script timeouts and concurrency limits, automatic error state after consecutive failures.
  • Run logs: status, duration, output, result and stack traces, queryable per base with a result dialog and log detail view.

Collaboration & Sharing

SmartTable is built for teams:

  • Sharing — Share an entire base, a form view, or a dashboard with fine-grained permissions.
  • Member Management — Invite members and assign roles from Owner to Viewer.
  • Real-time Collaboration — Optional WebSocket collaboration with presence, view sync, cell locking, conflict detection, and offline replay.
  • Request Tracking — Full-chain request IDs and standardized API responses.
  • Local Cache — IndexedDB caching reduces configuration requests by 90%+.

For details, see Collaboration.

Permissions & Security

  • Authentication — JWT tokens with refresh tokens, email verification, and password reset.
  • RBAC Roles — Owner, Admin, Editor, Commenter, Viewer.
  • Security Controls — Dynamic password rules, session timeout, public config endpoint.
  • Protection — XSS/CSRF protection, security headers, API rate limiting, file upload validation, and sanitized logs.

User Experience

  • Drag sorting for tables, fields, views, and kanban cards.
  • Star bases and dashboards for quick access.
  • Global search across table names and record content.
  • Element Plus icon system and keyboard shortcuts.

Released under the MIT License.