Agent skill

Yida Table Form

by openyida in openyida/openyida

宜搭表格形态批量表单提交页面开发。支持动态增删行、行内编辑验证、Excel 粘贴导入、草稿暂存、批量 saveFormData 提交。适用于需要一次性录入多条表单数据的场景。

MITAuto-check passedDocuments & Office

Install Yida Table Form

skills CLI
$ npx skills add openyida/openyida --skill yida-table-form -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install openyida/openyida yida-table-form --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/openyida/openyida.git skills-src && mkdir -p .claude/skills && cp -r skills-src/yida-skills/skills/yida-table-form .claude/skills/yida-table-form && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
yida-table-form
GitHub stars
220
Token cost
~827 tokens
SKILL.md length
197 words
Files
2 (incl. references)
Skills in repo
58
Repo updated
First seen
Licence
MIT

At a glance

宜搭表格形态批量表单提交页面开发。支持动态增删行、行内编辑验证、Excel 粘贴导入、草稿暂存、批量 saveFormData 提交。适用于需要一次性录入多条表单数据的场景。

  • Tasks that involve Excel spreadsheets
  • SKILL.md covers 严格禁止 (NEVER DO), 严格要求 (MUST DO), 适用场景 and 触发条件, plus 9 more sections
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Yida Table Form is an agent skill from openyida/openyida. 宜搭表格形态批量表单提交页面开发。支持动态增删行、行内编辑验证、Excel 粘贴导入、草稿暂存、批量 saveFormData 提交。适用于需要一次性录入多条表单数据的场景。

Its SKILL.md is about 830 tokens, which your agent loads only when the skill is triggered. The skill folder holds 2 other files, including reference files (for example `references/examples.md`).

It sits in Documents & Office, covering Excel spreadsheets. It works with Microsoft Excel. The repository describes itself as: Your own personal YiDA AI assistant! The licence is MIT.

When your agent uses it

  • Tasks that involve Excel spreadsheets

Example prompts

  • “/yida-table-form”

What it can do on your machine

Read from SKILL.md and the folder at commit 3dd4693. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    No scripts in the folder and no shell commands in SKILL.md (its code samples are javascript).

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Yida Table Form loads about 827 tokens when it runs, and up to ~1.6k if it reads all its reference files. Until then it costs about 26 tokens; SKILL.md has 197 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~26
When it runs · the whole SKILL.md, loaded when a task matches
~827
With references · SKILL.md plus every file in references/, read only if the agent opens them
~1.6k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from openyida/openyida at commit 3dd4693, republished under its MIT licence (© openyida). 197 words, ~827 tokens.

Download SKILL.mdSave it as .claude/skills/yida-table-form/SKILL.md (or your agent's skills folder). This skill also uses 1 other file; get the full folder from GitHub.
name
yida-table-form
description
宜搭表格形态批量表单提交页面开发。支持动态增删行、行内编辑验证、Excel 粘贴导入、草稿暂存、批量 saveFormData 提交。适用于需要一次性录入多条表单数据的场景。

宜搭自定义页面表格表单提交技能

严格禁止 (NEVER DO)

  • 不要在前端做批量提交时使用串行(逐条等待),必须用 Promise.all 并发提交
  • 不要在提交前跳过行验证,必须先 validateRow 再提交
  • 不要硬编码 FORM_UUID,必须从 project/config.json 或用户提供的信息中获取
  • 不要在提交成功后保留草稿,必须调用 clearDraft() 清除 localStorage
  • 不要忽略提交失败的行,必须在 UI 上标红并提示用户修正后重新提交

严格要求 (MUST DO)

  • 批量提交前必须确认:执行批量提交前,必须向用户展示待提交数据的摘要(行数、关键字段),获得用户明确同意后再执行
  • 必须在 COLUMNS 配置区定义所有列,字段 ID 从表单 Schema 中提取
  • 必须实现草稿自动保存(localStorage),防止用户刷新丢失数据
  • 必须在提交结果中区分成功/失败数量,失败行保留可编辑状态
  • 批量提交必须使用 Promise.all 并发,不得串行等待

适用场景

用户意图触发条件
批量录入同类数据"批量添加"、"批量录入"、"Excel 导入"
行内编辑 + 批量保存"表格形式填写"、"多行同时编辑"
Excel 粘贴导入"从 Excel 粘贴"、"复制粘贴数据"

触发条件

正向触发:

  • "批量添加"、"批量录入"、"Excel 导入"
  • "表格形式填写"、"多行同时编辑"
  • "从 Excel 粘贴"、"复制粘贴数据"

⚠️ 表格表单在移动端体验差,移动端场景建议使用标准表单。

异常处理

异常场景处理方式
批量提交部分失败失败行在 UI 上标红,保留可编辑状态,提示用户修正后重新提交
提交前未验证必须先 validateRow 验证所有行,再执行批量提交
提交成功后草稿未清除必须调用 clearDraft() 清除 localStorage
串行提交导致超时必须使用 Promise.all 并发提交,不得串行等待
FORM_UUID 硬编码必须从 project/config.json 或用户提供的信息中获取,不得硬编码
fieldId 不存在先执行 yida-get-schema 获取真实 fieldId
草稿恢复失败提示用户 localStorage 可能被清空,重新录入数据
接口超时减少单次提交条数(建议 ≤50 条),分批提交
数据量过大建议分批录入,每批不超过 100 条

Agent 错误处理策略

当 Agent 执行本技能遇到错误时,必须遵循以下默认行为:

错误类型默认处理策略
代码生成失败停止执行,向用户展示错误信息,询问是否重试或调整需求
参数缺失(FORM_UUID/字段 ID 等)主动询问用户补充,或引导用户使用 yida-get-schema 获取
权限不足 / 登录态失效停止执行,提示用户执行 openyida auth status 检查登录态
批量提交部分失败展示失败行详情,保留可编辑状态,引导用户修正后重试
字段类型不支持停止执行,提示用户该字段类型暂不支持,建议调整表单设计
未知错误停止执行,完整展示错误信息,建议用户反馈问题

概述

在批量录入同类数据(如批量添加商品、批量录入考勤、批量创建任务)的场景下,标准表单页面每次只能提交一条记录,效率低下。本技能提供表格形式的批量表单提交方案,支持行内编辑、验证和批量提交。


何时使用

  • 批量录入同类数据(如:批量添加商品、批量录入考勤)
  • Excel 式数据编辑体验
  • 行内编辑 + 批量保存

核心数据结构

javascript
// 每行数据结构
{
  id: 'temp_' + Date.now(),   // 临时行 ID(提交后替换为 formInstId)
  fieldA: '',                  // 各字段值
  fieldB: '',
  _status: 'valid',            // 'valid' | 'invalid' | 'submitting' | 'submitted'
  _errors: {},                 // { fieldA: '必填', fieldB: '格式错误' }
}

实现内容

表格表单页面需要包含动态增删行、行内验证、Excel 粘贴导入、草稿暂存和批量提交;字段 ID 先从目标表单 Schema 获取,再写入列配置。

功能说明

动态增删行
  • 点击「+ 添加行」在表格末尾新增空行
  • 点击行末的 🗑 按钮删除该行(已提交成功的行不可删除)
  • 表格始终保留至少一行
Excel 粘贴导入

点击「📋 粘贴 Excel 数据」后,将从 Excel 复制的内容粘贴到剪贴板,系统自动按 Tab 分隔解析列,按换行分隔解析行,追加到现有数据后。

注意:列顺序需与 COLUMNS 定义一致。

行内验证

提交前自动验证所有行:

  • 必填字段为空 → 标红并显示错误信息
  • 验证失败的行背景变为浅红色
  • 全部通过后才发起提交请求
草稿暂存

每次修改单元格后自动将数据保存到 localStorage,key 为 yida_table_form_draft_{formUuid}。刷新页面后自动恢复草稿。提交全部成功后自动清除草稿。

批量提交

使用 Promise.all 并发提交所有行,每行独立调用 saveFormData:

  • 提交中的行显示 loading 状态
  • 提交成功的行背景变绿,显示 ✓
  • 提交失败的行背景变红,显示错误信息,可修正后重新提交

自定义配置

修改文件顶部的配置区即可适配不同表单:

javascript
var FORM_UUID = 'FORM-XXX';   // 替换为实际表单 UUID

var COLUMNS = [
  // type 支持:'text' | 'select' | 'date'
  { label: '字段名', field: 'fieldId_xxx', type: 'text', required: true },
  { label: '下拉字段', field: 'selectField_xxx', type: 'select', required: false,
    options: ['选项A', '选项B', '选项C'] },
];

注意事项

  • 本技能不读写 memory:表格表单的草稿数据通过 localStorage 在浏览器本地持久化,不依赖跨会话的 memory 状态

© openyida, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

SKILL.md and 1 other file (references) in yida-skills/skills/yida-table-form of openyida/openyida.

  • SKILL.md
  • references/examples.md

Open the folder on GitHubat commit 3dd4693

Compare with similar skills

Yida Table Form next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Yida Table Form compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Yida Table Form this skillopenyida/openyida220—~827Automated safety check: PassMIT
MarkitdownImCa0/just-laws78114 repos~3.2kAutomated safety check: NotesMIT
Data Table Managern8n-io/n8n207k—~2.3kAutomated safety check: PassCustom licence
Docx4jplutext/docx4j2.4k—~2.5kAutomated safety check: PassNone
Instrument Data To Allotropeaws-samples/amazon-bedrock-agents-healthcare-lifesciences2742 repos~2.7kAutomated safety check: PassApache-2.0
Cyber Pptcrazyykhllc-bit/CyberPPT1.8k—~10kAutomated safety check: PassMIT

Similar skills

  • Markitdown

    ImCa0/just-laws

    Convert files and office documents to Markdown. An agent skill from ImCa0/just-laws.

    781 GitHub starsUsed in 14 repos~3.2k tokens
    Documents & OfficeAuto-check: notes
  • Official

    Load before calling data-tables or parse-file. An agent skill from n8n-io/n8n.

    207k GitHub stars~2.3k tokensUpdated today
    Documents & OfficeAuto-check passed
  • Docx4j

    plutext/docx4j

    A skill your agent uses when writing Java code that creates, reads or edits Word (.docx), PowerPoint (.pptx) or Excel (.xlsx) files with docx4j — including generating documents, editing existing…

    2.4k GitHub stars~2.5k tokensUpdated yesterday
    Documents & OfficeAuto-check passed
  • Instrument Data To Allotrope

    aws-samples/amazon-bedrock-agents-healthcare-lifesciences

    Official

    Convert laboratory instrument output files (PDF, CSV, Excel, TXT) to Allotrope Simple Model (ASM) JSON format or flattened 2D CSV.

    274 GitHub starsUsed in 2 repos~2.7k tokens
    Documents & OfficeAuto-check passed
  • Cyber Ppt

    crazyykhllc-bit/CyberPPT

    当用户需要把 DOCX、PDF、TXT、XLSX、研究报告、业务材料或原始数据转成高密度、可编辑、咨询风格 PPTX 时使用;也适用于需要 SCR 论证、视觉风格探索、详细图表和渲染质检的 PPT。

    1.8k GitHub stars~10k tokensUpdated 2 mo ago
    Documents & OfficeAuto-check passed
  • Markit

    shift-labs-ai/markit

    Convert files and URLs to Markdown. An agent skill from shift-labs-ai/markit.

    1.3k GitHub stars~299 tokensUpdated 1 mo ago
    Documents & OfficeAuto-check passed

More from openyida/openyida

All 58 skills in this repo
  • Yida Canvas Custom Page

    openyida/openyida

    宜搭自定义页面开发规范,使用 YidaCodeCanvas 组件实现现代 React18 自定义页面。用于官网、看板、工作台、列表、详情、门户壳、可视化、hooks 交互、表单入口,以及需要门户组件、数据管理视图、成员、部门或上传组件的场景;发布层自动注入 yida/utils window 桥。

    220 GitHub stars~4.3k tokensUpdated 8 days ago
    Auto-check passed
  • Openyida Release

    openyida/openyida

    快速发布 OpenYida npm 正式版或测试版。用户说“发布正式版”“发布测试版”“发 beta”或要求按当天日期生成版本 tag 时使用;不用于宜搭应用或自定义页面发布。

    220 GitHub stars~520 tokensUpdated 8 days ago
    Auto-check passed
  • Yida Design Plan

    openyida/openyida

    Plan 模式的视觉设计分支。基于需求选择视觉方向,再结合业务页面规划维护 build-plan.json 的 visualStyle,供 CLI 派生 design.md。

    220 GitHub stars~756 tokensUpdated 8 days ago
    Auto-check passed
  • Prevent stale local OpenYida custom page source from overwriting live designer edits.

    220 GitHub stars~1.2k tokensUpdated 8 days ago
    Auto-check passed
  • Codemap

    openyida/openyida

    Generate, update, or drift-check agent-facing CodeMaps as progressive code terrain indexes for projects, features, capabilities, functions, modules, or bug chains.

    220 GitHub stars~1k tokensUpdated 8 days ago
    Auto-check passed
  • Sdd Riper One Light

    openyida/openyida

    面向 GPT-5.5 等强模型和熟练用户的轻量 AI Agent Harness / checkpoint-driven coding skill。默认用户已经把任务切到基本可执行的最小混沌单元;模型自行分解、探索与推进,人类通过最终目标、最小 spec、复述、checkpoint、证据验证与回写来低干扰控盘。

    220 GitHub stars~1.5k tokensUpdated 8 days ago
    Auto-check passed

Works with

Questions about Yida Table Form

What does Yida Table Form do?

宜搭表格形态批量表单提交页面开发。支持动态增删行、行内编辑验证、Excel 粘贴导入、草稿暂存、批量 saveFormData 提交。适用于需要一次性录入多条表单数据的场景。. Yida Table Form is an agent skill from openyida/openyida.

When should I use Yida Table Form?

Yida Table Form fits situations like: tasks that involve Excel spreadsheets.

How do I install Yida Table Form in Claude Code?

Run `npx skills add openyida/openyida --skill yida-table-form -a claude-code`. Or copy the skill folder (yida-skills/skills/yida-table-form in openyida/openyida) into .claude/skills/yida-table-form in your project. Claude Code loads it when a task matches its description.

How do I install Yida Table Form in Codex?

Run `npx skills add openyida/openyida --skill yida-table-form -a codex`. Or copy the skill folder (yida-skills/skills/yida-table-form in openyida/openyida) into .agents/skills/yida-table-form in your project. Codex loads it when a task matches its description.

Can I use Yida Table Form in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add openyida/openyida --skill yida-table-form -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/yida-table-form, .gemini/skills/yida-table-form, .github/skills/yida-table-form and .opencode/skills/yida-table-form in your project.

What does Yida Table Form need to run?

SKILL.md names no scripts, command-line tools or credentials: Yida Table Form is instructions for the agent only.

Does Yida Table Form access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Yida Table Form safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Yida Table Form use?

Yida Table Form is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Yida Table Form use?

About 827 tokens (SKILL.md is roughly 3.3k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 787 tokens, read only when the agent opens those files.

What are the alternatives to Yida Table Form?

Skills that share tags, products or a category with Yida Table Form: Markitdown (ImCa0/just-laws, 781 stars), Data Table Manager (n8n-io/n8n, 207k stars), Docx4j (plutext/docx4j, 2.4k stars) and Instrument Data To Allotrope (aws-samples/amazon-bedrock-agents-healthcare-lifesciences, 274 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Yida Table Form?

openyida (a GitHub organization) maintains it in openyida/openyida, which has 220 GitHub stars. The repository holds 58 skills in this directory. The repository was last updated on September 30, 2026.

Source: openyida/openyida on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.