Relational Table feature comparison
Compare Relational Table features, support, and compatibility with Airtable, Feishu Base.
12 categories, 62 features; Univer supports 37, partially supports 8, and does not support 17.
Integration guide · All features
Comparison scope
Compares the paid cloud products Airtable and Feishu Base. Univer includes the complete Office SDK and optional modules. Only non-AI capabilities of the product itself are included; separate external products and add-ons are excluded. External agents may call APIs for data preparation, synchronization, and import, with conditions noted separately from built-in automation orchestration. Application-built entry points, scheduling, and permissions are distinguished from native features. Plan, mobile, and integration requirements are stated per feature.
“Open source” marks full support in the open-source edition. Unmarked items may include basic subsets, optional modules, or commercial licensing; consult the corresponding module documentation.
62 of 62 items
Fields and data types
| Feature and scope | Univer Relational TableComplete Office SDK · optional modules | AirtablePaid cloud product · excludes separate products | Feishu BasePaid cloud product · excludes separate products |
|---|---|---|---|
| Text, URLs, email addresses, and phone numbers | ✓ Supported | ✓ Supported | ✓ Supported |
| Number, currency, and date fields | ✓ Supported | ✓ Supported | ✓ Supported |
| Single-select and multi-select fields | ✓ Supported | ✓ Supported | ✓ Supported |
| Checkbox and rating fields | ✓ Supported | ✓ Supported | ✓ Supported |
| People fields | ✓ SupportedThe integrating application supplies candidate people and identities. | ✓ Supported | ✓ Supported |
| Images and file attachments | ✓ SupportedProduction applications provide upload, storage, and access control. | ✓ Supported | ✓ Supported |
| Created/modified authors and timestamps | ✓ Supported | ✓ Supported | ✓ Supported |
| Auto-number fields | ✓ Supported | ✓ Supported | ✓ Supported |
| Barcode fields and mobile scanning | — Not supportedNo built-in barcode field. Scanning controls require separate integration. | ✓ SupportedBarcode values are supported; camera scanning uses mobile clients. | ✓ SupportedMobile clients scan barcodes/QR codes into fields. |
| Dedicated Duration fields | — Not supportedNo dedicated Duration type. Numbers or formulas can represent durations. | ✓ Supported | — Not supportedNo separate Duration field currently. |
| Button fields | — Not supportedNo built-in Button field. Applications can add custom buttons. | ✓ Supported | ✓ Supported |
Record relationships and calculation
| Feature and scope | Univer Relational TableComplete Office SDK · optional modules | AirtablePaid cloud product · excludes separate products | Feishu BasePaid cloud product · excludes separate products |
|---|---|---|---|
| Link records across tables in one Relational Table | ✓ Supported | ✓ Supported | ✓ Supported |
| Link multiple records from one field | ✓ Supported | ✓ Supported | ✓ Supported |
| Parent/child records and hierarchy | ✓ SupportedSupports five levels. Self-links and cycles are not allowed. | ✓ SupportedOrganize through linked records and hierarchical lists; nesting depends on layout. | ✓ SupportedUp to four subrecord levels below a parent record. |
| Lookup fields | ◐ PartialFormulas can retrieve values from linked records. No independently configured Lookup field. | ✓ Supported | ✓ Supported |
| Rollup fields | ◐ PartialFormulas can sum linked records and recalculate when sources change. No independently configured Rollup field. | ✓ Supported | ✓ SupportedCalculate through lookup-field aggregation. |
| Count linked records | ◐ PartialFormulas can count IDs in linked lists. No dedicated Count field; handling invalid links depends on the formula. | ✓ Supported | ✓ SupportedCalculate through lookup-field counting. |
| Automatically calculated formula fields | ✓ Supported | ✓ Supported | ✓ Supported |
Views and project planning
| Feature and scope | Univer Relational TableComplete Office SDK · optional modules | AirtablePaid cloud product · excludes separate products | Feishu BasePaid cloud product · excludes separate products |
|---|---|---|---|
| Grid view | ✓ Supported | ✓ Supported | ✓ Supported |
| Kanban view | ✓ Supported | ✓ Supported | ✓ Supported |
| Calendar view | ✓ Supported | ✓ Supported | ✓ Supported |
| Gallery/card view | ✓ Supported | ✓ Supported | ✓ Supported |
| List and hierarchical list views | — Not supportedNo independent List view. Custom list interfaces belong to the application. | ✓ Supported | ✓ SupportedApp mode provides ordinary, detail, card, aggregate, and collapsible list components. |
| Gantt view | ✓ Supported | ✓ Supported | ✓ Supported |
| Gantt task dependencies | ✓ SupportedRequires a configured dependency field. | ✓ SupportedDependency connectors are supported. | — Not supportedPredecessor/successor task dependencies are not supported currently. |
| Standalone Timeline view | — Not supportedGantt is available. No independent Timeline view. | ✓ Supported | — Not supportedGantt and calendar views are available, without a separate Timeline view. Gantt capabilities are listed separately. |
Forms and data collection
| Feature and scope | Univer Relational TableComplete Office SDK · optional modules | AirtablePaid cloud product · excludes separate products | Feishu BasePaid cloud product · excludes separate products |
|---|---|---|---|
| Form pages and submissions | ◐ PartialWeb Apps can collect input into linked spreadsheets. No standalone form view in Relational Table. | ✓ Supported | ✓ Supported |
| Required fields and conditional form visibility | ◐ PartialWeb Apps can implement validation and conditional visibility. Rules are configured in the Web App. | ✓ Supported | ✓ Supported |
| Public form submissions and sharing | ◐ PartialWeb Apps can provide forms and share entry points. Public access/submission depend on deployment and data permissions. | ✓ Supported | ✓ Supported |
Filtering, sorting, and display
| Feature and scope | Univer Relational TableComplete Office SDK · optional modules | AirtablePaid cloud product · excludes separate products | Feishu BasePaid cloud product · excludes separate products |
|---|---|---|---|
| Conditional filtering | ✓ Supported | ✓ Supported | ✓ Supported |
| Sort by fields | ✓ Supported | ✓ Supported | ✓ Supported |
| Group by fields | ✓ Supported | ✓ Supported | ✓ Supported |
| Conditional record coloring | ✓ Supported | ✓ Supported | ✓ Supported |
Dashboards and analytics
| Feature and scope | Univer Relational TableComplete Office SDK · optional modules | AirtablePaid cloud product · excludes separate products | Feishu BasePaid cloud product · excludes separate products |
|---|---|---|---|
| Dashboards combining charts and metrics | ✓ SupportedRequires Dashboard and the appropriate chart plugins. | ✓ Supported | ✓ Supported |
| Dimension aggregation and chart analytics | ✓ SupportedPivot plugins aggregate data by row and column fields. | ✓ SupportedPaid desktop/web dashboards support pivot tables. | ✓ SupportedAggregate by dimensions through dashboard components. |
| Interactive dashboard filtering | ✓ Supported | ✓ Supported | ✓ Supported |
Application UI and extensions
| Feature and scope | Univer Relational TableComplete Office SDK · optional modules | AirtablePaid cloud product · excludes separate products | Feishu BasePaid cloud product · excludes separate products |
|---|---|---|---|
| Drag-and-drop application builder | ◐ PartialWeb Apps can create custom business interfaces using views and dashboards. No built-in drag-and-drop application builder. | ✓ Supported | ✓ Supported |
| Custom record-detail layouts | ◐ PartialField order follows the current view. Panels support resizing/fullscreen, but no independent grouped, multicolumn, or component layout design. | ✓ Supported | ✓ Supported |
| Installable extensions and custom plugin components | ✓ SupportedDevelop plugins/components through SDKs. No ready-made extension marketplace. | ✓ SupportedExtend through extensions and the application/component system. | ✓ SupportedApp mode supports plugin components and custom plugins. |
Realtime collaboration and history
| Feature and scope | Univer Relational TableComplete Office SDK · optional modules | AirtablePaid cloud product · excludes separate products | Feishu BasePaid cloud product · excludes separate products |
|---|---|---|---|
| Realtime editing of shared data | ✓ SupportedShared editing requires collaboration services. | ✓ Supported | ✓ Supported |
| Record comments | ✓ SupportedShared discussions require comment services, data sources, and permissions. | ✓ Supported | ✓ Supported |
| Historical versions and change records | ✓ SupportedRequires history plugins and versions retained by the server. | ✓ SupportedRecord-history retention varies by plan. | ✓ SupportedHistory capabilities vary by database version and plan. |
Permissions and sharing
| Feature and scope | Univer Relational TableComplete Office SDK · optional modules | AirtablePaid cloud product · excludes separate products | Feishu BasePaid cloud product · excludes separate products |
|---|---|---|---|
| Role-based editing permissions | ✓ SupportedApplications provide identity and enforce server-side authorization. | ✓ Supported | ✓ Supported |
| Field and table editing permissions | ✓ SupportedRequires application users and server-side checks. | ✓ Supported | ✓ Supported |
| Row-level record read access | — Not supportedRecord editing restrictions are supported. Per-user read isolation must be implemented by the application server. | ✓ SupportedAuthenticated Interfaces can restrict records by current user; also restrict direct access to the full Base. | ✓ SupportedAdvanced permissions restrict reads by role and record conditions. |
| Share read-only views or application links | — Not supportedRelational Table can be read-only. Sharing links, publication, and access control are application responsibilities. | ✓ Supported | ✓ Supported |
| Link passwords and sharing scope | — Not supportedNo built-in link-password or sharing-scope panel. Integrate existing identity/access controls. | ✓ SupportedPaid Base/view sharing links support passwords or email-domain restrictions. | ✓ SupportedLink-access passwords are supported; sharing scope depends on enterprise policies and document classification. |
File import and export
| Feature and scope | Univer Relational TableComplete Office SDK · optional modules | AirtablePaid cloud product · excludes separate products | Feishu BasePaid cloud product · excludes separate products |
|---|---|---|---|
| Import records from Excel | ✓ SupportedRequires file conversion. Imports record data; full workbook behavior requires separate handling. | ✓ SupportedImports tabular data. | ✓ SupportedImport files are subject to format and size limits. |
| Export table data to CSV | ✓ SupportedExports one table's data. CSV does not retain complete Relational Table configuration. | ✓ SupportedDownload CSV by view. | ✓ SupportedExport scope depends on permissions. |
APIs and data synchronization
| Feature and scope | Univer Relational TableComplete Office SDK · optional modules | AirtablePaid cloud product · excludes separate products | Feishu BasePaid cloud product · excludes separate products |
|---|---|---|---|
| Create, query, and update records through APIs | ✓ SupportedAPIs support record operations, including writes after external-agent processing. Remote endpoints are provided by the application. | ✓ SupportedAccess cloud Bases through Airtable Web APIs. | ✓ SupportedAccess cloud Bases through open-platform APIs. |
| One-way synchronization across Relational Tables | ✓ SupportedExternal agents can read, transform, and write between Relational Tables. Field mapping and scheduling belong to the external workflow. | ✓ Supported | ✓ SupportedSynced records are read-only; manual or hourly refresh is available, with field-type restrictions. |
| Two-way synchronization across Relational Tables | ✓ SupportedExternal agents can read/write both sides. Record mapping, scheduling, and conflict handling belong to the external workflow. | ✓ SupportedBusiness/Enterprise Scale supports this when the source permits other Bases to edit. Synced fields cannot be written back through APIs or script steps. | — Not supportedSource records in native cross-Base synced tables are read-only; editing, adding, and deleting cannot write back. |
| Combine multiple sources into one table | ✓ SupportedExternal agents transform sources and write a shared target. Mapping, merging, and deduplication belong to the external workflow. | ✓ SupportedCombine multiple sources into one destination table. Multi-source sync is unavailable when linked-record syncing is enabled. | — Not supportedEach source table creates its own synced table; sources cannot be combined into one synced table. |
Automation triggers and orchestration
| Feature and scope | Univer Relational TableComplete Office SDK · optional modules | AirtablePaid cloud product · excludes separate products | Feishu BasePaid cloud product · excludes separate products |
|---|---|---|---|
| Visual multistep automation | — Not supportedAutomation is driven by external agents. No built-in visual workflow orchestrator. | ✓ Supported | ✓ Supported |
| Trigger on record creation, updates, or conditions | — Not supportedRecord/cell events are available. External agents manage trigger rules and follow-up actions; no built-in conditional workflow engine. | ✓ Supported | ✓ Supported |
| Scheduled and recurring triggers | — Not supportedExternal agents or schedulers drive timed jobs. No built-in schedule trigger. | ✓ Supported | ✓ Supported |
| Trigger workflows from webhooks | — Not supportedExternal agents or companion services receive webhooks and start workflows. No built-in webhook workflow trigger. | ✓ Supported | ✓ Supported |
| If/Else branches | — Not supportedExternal agents orchestrate conditions and branches. No built-in If/Else workflow node. | ✓ SupportedIf/Else branches are supported; execute the first matching branch in order. | ✓ SupportedIf/Else and Switch multi-branch logic are supported. |
| Loop over record lists | — Not supportedExternal agents iterate records and run batch actions. No built-in loop step. | ✓ Supported | ✓ Supported |
| JavaScript automation steps | — Not supportedExternal agents run scripts in appropriate environments. No built-in automation script step. | ✓ Supported | ◐ PartialAutomation triggers and actions are configurable, without a built-in JavaScript script step. |
| No-code HTTP request actions | — Not supportedExternal agents or companion services manage HTTP requests and credentials. No built-in HTTP workflow action. | — Not supportedNo general HTTP-request action; use fetch inside Run a script. | ✓ SupportedA native Send HTTP request action is available. |
| Third-party connectors and notifications | — Not supportedExternal agents or companion services handle integrations and notifications. Corresponding connectors/actions are not built in. | ✓ SupportedBuilt-in automation actions include Slack, Teams, Outlook, and Google Workspace. | ✓ SupportedConnector actions include Outlook email and Feishu messages, calendars, and tasks. |
Official documentation: Univer Relational Table · Airtable · Feishu Base
How is this guide?