0.0.2

Duowei Table v0.0.2

Highlights

• Field types expanded from 9 to 22.
• Views expanded from 3 to 7.
• Formula, relation, lookup, rollup, long-text, date-time, URL, phone, rating,
  progress, system-time, and auto-number fields are now part of the Community
  Edition.
• Calendar, Timeline, Form, and Dashboard views join Grid, Kanban, and Gallery.
• New folder imports and live read-only vault indexes turn notes, images,
  documents, and media into table data sources.
• Markdown notes can embed table views and individual dashboard charts.
• Editing, backup isolation, conflict recovery, large-table performance, and
  mobile interaction have all received major upgrades.

Added

Fields and computed data

• Thirteen additional field types: Long Text, Date & Time, URL, Phone, Rating,
  Progress, Relation, Lookup, Rollup, Formula, Created Time, Updated Time, and
  Auto Number.
• Formula expressions with field references, arithmetic, comparisons, logical
  functions, aggregate functions, typed results, and recalculation planning.
• Same-file and cross-file relations with record pickers and relation chips.
• Lookup and rollup fields over related records, including count, sum, average,
  minimum, and maximum.
• Reverse relations for discovering records that point to the current record.
• Number formats for plain values, thousands separators, percentages, and
  currencies; configurable date and date-time display formats.
• Required-field indicators, numeric ranges, phone/URL/email validation, rating
  limits, and progress values from 0 to 100.
• Markdown preview for long-text fields and configurable detail-panel groups.

Views and analysis

• Calendar view for records organized by a date field.
• Timeline view for records with start/end dates.
• Form view with descriptions, field selection, required validation, and record
  submission.
• Dashboard view with metric cards, bar charts, pie charts, and line charts.
• A persistent view tab bar for creating, switching, renaming, duplicating, and
  deleting views.
• Up to three grouping levels in Grid view, with nested collapsible groups and
  persisted collapse state.
• Type-aware filters, AND/OR combinations, per-column summaries, conditional
  formatting, and view-level field visibility.
• Search-result highlighting and conditional colors shared by Grid, Kanban, and
  Gallery cards.

Editing experience

• Paste beyond the current table boundary now creates the required rows and
  columns instead of dropping data.
• Fill down, fill right, drag-fill, previewed bulk edits, row multi-selection,
  and a floating batch-action bar.
• Select editors with search, multi-select checkboxes, option creation, rename,
  recolor, and deletion.
• Find and replace for text-like fields.
• Cell background and text colors, automatic text wrapping, hover-to-view full
  values, and double-click-to-fit column widths.
• Boundary navigation with Ctrl/Cmd+Arrow, Home, End, and selection
  extension with Shift.
• Mini-calendar editors for Date and Date & Time fields.
• Record detail navigation, sidebar/card layouts, field groups, and quick record
  expansion from row numbers.

Obsidian and data-source integration

• Editable imports from a folder of Markdown notes, with inferred field types,
  note bindings, and frontmatter synchronization.
• Live read-only indexes for Markdown, images, documents, media, or all files in
  a vault scope.
• Built-in file properties such as file name, path, folder, extension, size,
  tags, created time, and modified time.
• Table embeds through ![[table.duowei]] and configurable duowei code blocks.
• Dashboard chart embeds and a command that inserts chart references into
  Markdown.
• Quick-add command for appending a record without opening the table.
• Commands to insert table-view references and find tables related to the
  current note.
• Vault file pickers, native hover previews, image thumbnails, multi-image
  aggregation, and a zoomable lightbox.

Import, export, and examples

• Expanded CSV/TSV import preview, field mapping, type confirmation, and error
  reporting.
• CSV/TSV export from the current table or view, including a desktop save dialog.
• Five example .duowei files under examples/content-operations, including a
  formula-enabled annual overview and a larger article dataset.

Safety and recovery

• Backup snapshots now use the isolated .duoweibak extension, preventing them
  from appearing in normal table pickers or opening as editable tables.
• Configurable backup folder with {{table}} and {{folder}} placeholders.
• Automatic backup interval and retention controls.
• External-change detection before save, conflict snapshots, difference
  summaries, and cell-by-cell merge for manageable conflicts.
• Backup restore panel and persistent operation log.
• Attachment destinations can be configured; missing folders are created and
  duplicate file names receive a suffix instead of being overwritten.

Performance and mobile

• In-place value patches replace full-document cloning on common cell edits.
• Change-set undo/redo with a 100-entry history limit.
• Cached field, record, relation, formula, and serialization indexes.
• Grid row virtualization plus paginated Kanban and Gallery cards.
• Lightweight state updates for view switching, calendar navigation, and group
  collapsing.
• Touch scrolling, long-press menus, bottom-sheet panels, larger touch targets,
  and touch-friendly Kanban movement for phones and tablets.

Quality and maintainability

• The table engine was split into dedicated modules for field registration,
  formula runtime, cards, calendar/timeline, forms, dashboards, modals, embeds,
  folder import, and external table caching.
• TypeScript source grew from approximately 9,713 to 26,494 lines as the
  feature set expanded and large modules were separated.
• Build/verification scripts grew from 2 to 16, adding regression coverage
  for all field types, formulas, computed recalculation, image previews, IME
  input, backup isolation, Kanban behavior, capability boundaries, examples, and
  large-table virtualization.

Changed

• Plugin ID changed from duowei-table to
  obsidian-multidimensional-table-community.
• Display name changed from Duowei Table to 多维表格（社区版）.
• Obsidian manifest version changed from 0.0.1 to 0.0.3; minimum Obsidian
  version remains 1.10.0.
• The initial 创建示例多维表格 command was replaced by a general
  从 Base 创建多维表格 workflow and checked-in example files.
• The initial Pro-upgrade command was removed from the Community Edition.
• New commands cover folder import, quick record capture, table-view embeds, and
  chart embeds.
• Community capability boundaries now exclude AI generation, external
  calendar/task synchronization, and favorites synchronization while keeping
  the full local field and view engine.
• License metadata and documentation are standardized on GNU GPL v3
  (GPL-3.0-only) with the complete license text in LICENSE.

Upgrade instructions

The plugin ID changed, so treat this as a side-by-side plugin migration rather
than overwriting the initial plugin folder.

1. Back up your vault and all .duowei files.

2. Disable the old plugin with ID duowei-table.

3. Install main.js, manifest.json, and styles.css into:

   <Your Vault>/.obsidian/plugins/obsidian-multidimensional-table-community/
   

4. Enable 多维表格（社区版） in Settings → Community plugins.

5. Recheck plugin settings. Because the plugin ID and folder changed, settings
   stored by the initial plugin may need to be entered again.

6. Open a copied table first and confirm fields, views, relations, and note
   synchronization before continuing normal work.

7. After validation, remove or archive the old plugin folder. Never enable the
   old, Community, and Pro editions at the same time.

Data compatibility

• The .duowei extension and schemaVersion: 1 remain unchanged.
• Initial Community Edition tables can be opened directly by v0.0.3.
• Missing current fields and view options are normalized to safe defaults when
  older files are read.
• Keep a backup before opening a file that contains configuration written by
  Duowei Table Pro; the Community Edition does not implement Pro-only AI or
  external synchronization behavior.

Known limitations

• The interface, commands, and settings are currently in Simplified Chinese.
• Live vault-index tables are read-only; edit their source files instead.
• This is a local database, not a real-time multi-user collaboration service.
• Merged cells are not supported because each row represents one record.
• AI fields, external calendar/task synchronization, and favorites
  synchronization remain Pro-only.

Verification

Run the complete release verification locally with:

npm ci
npm run verify

The verification pipeline performs TypeScript checks, production bundling,
bundle syntax/structure validation, 22-field round-trip checks, formula and
computed-field tests, interaction regressions, capability-boundary checks,
example validation, and the virtual-window benchmark.

Support

• Issues: repository issue tracker
• QQ group: 1094620986 (Simplified Chinese)
• Email: jepicaju862@gmail.com
• Pro: https://peyote.info/plugins/duowei-table-pro/

更新亮点

• 字段类型从 9 种增加到 22 种。
• 视图从 3 种增加到 7 种。
• 公式、关联、查找、汇总、长文本、日期时间、链接、电话、评分、进度、系统时间和自动编号
  均已进入社区版。
• 在表格、看板、画廊之外，新增日历、时间线、表单和仪表盘。
• 新增文件夹导入与 Vault 实时只读索引，笔记、图片、文档和音视频均可成为表格数据源。
• Markdown 笔记可嵌入表格视图和单个仪表盘图表。
• 编辑体验、备份隔离、冲突恢复、大表性能和移动端操作均有大幅升级。

新增功能

字段与计算能力

• 新增长文本、日期时间、链接、电话、评分、进度、关联、查找、汇总、公式、创建时间、
  更新时间和自动编号 13 种字段。
• 公式支持字段引用、四则运算、比较、逻辑函数、聚合函数、结果类型...

0.0.1

🚀 Features / 核心功能

[English]

• Standalone .duowei file type with table, kanban, and gallery views.
• Nine field types: text, number, checkbox, date, single select, multi select, email, note link, attachment.
• Row and column editing: field rename, field type change with migration preview.
• Rich interaction: Range selection, copy and paste, fill down, fill right, drag fill, bulk edit with preview, undo and redo, autosave.
• View configurations: Per-view field visibility, filtering, sorting, and row height, persisted to the file.
• Import: CSV/TSV import with preview, field mapping, and error report.
• Bases integration: duowei-grid layout for the core Bases plugin, plus a command to create a standalone .duowei table from the current .base file.
• Data binding: One-way frontmatter sync from records to bound Markdown notes, with a sync log and retry.
• Data safety: External modification detection with backup-before-overwrite, a conflict recovery panel with per-cell merge, a backup restore panel, an autosave backup policy, and a persistent operation log.

[中文]

• 独立的 .duowei 文件类型，并提供表格、看板、画廊三种视图。
• 9 种字段类型： 文本、数字、勾选、日期、单选、多选、邮箱、笔记链接、附件。
• 行列编辑： 支持增删行列、重命名字段、更改字段类型（更改前会显示迁移预览）。
• 丰富的交互： 单元格预览与编辑、区域选择、复制粘贴、向下/向右填充、拖拽填充手柄，带预览的批量编辑、撤销重做、自动保存。
• 视图配置： 按视图分别设置字段显示、筛选、排序与行高，全部持久化到文件中。
• 数据导入： CSV/TSV 导入，支持预览、字段映射、类型确认与错误报告。
• Bases 兼容： 为核心插件 Bases 注册了 duowei-grid 布局，并支持从当前 .base 文件一键创建独立 .duowei 表格。
• 数据绑定： 支持将记录绑定到 Markdown 笔记，把选定字段单向写回其 frontmatter，带同步日志与失败重试。
• 数据安全： 保存前检测外部修改，冲突时写入备份而非静默覆盖，提供冲突恢复面板（支持逐单元格合并）、备份还原面板、自动保存备份策略与持久化操作日志。

📦 Installation / 安装方式

Manual installation:
Download main.js, manifest.json, and styles.css from the assets below and place them in <vault>/.obsidian/plugins/duowei-table/, then reload Obsidian and enable the plugin in Settings → Community plugins.

手动安装：
下载下方 Assets 中的 main.js、manifest.json 和 styles.css 文件，放入你的库文件夹中的 .obsidian/plugins/duowei-table/ 目录下，重启 Obsidian 后在“第三方插件”设置中启用即可。

**Full Changelog**: https://github.com/jepicaju862-lab/duowei-table/commits/0.0.1