Agent skill

Yida Business Rule

by openyida in openyida/openyida

宜搭表单业务关联规则与高级函数配置。用于在表单设置中配置业务关联规则,或使用 INSERT、UPDATE、DELETE、UPSERT 高级函数实现跨表增删改。适用于需要表单间数据联动的场景。

MITAuto-check passed

Install Yida Business Rule

skills CLI
$ npx skills add openyida/openyida --skill yida-business-rule -a claude-code

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

GitHub CLI
$ gh skill install openyida/openyida yida-business-rule --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-business-rule .claude/skills/yida-business-rule && 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-business-rule
GitHub stars
221
Token cost
~768 tokens
SKILL.md length
197 words
Files
1
Skills in repo
59
Repo updated
First seen
Licence
MIT

At a glance

宜搭表单业务关联规则与高级函数配置。用于在表单设置中配置业务关联规则,或使用 INSERT、UPDATE、DELETE、UPSERT 高级函数实现跨表增删改。适用于需要表单间数据联动的场景。

  • Works in 9 steps: 确认触发表单和目标表单都在同一应用内。 → 用 openyida get-schema 查清目标字段和来源字段,避免点错。 → 打开触发表单设计器,进入 表单设置 → 表单事件 → 公式执行 →… → …
  • SKILL.md covers 适用范围, 配置入口, 关键原则:必须插入令牌 and 高级函数签名, plus 6 more sections
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Yida Business Rule is an agent skill from openyida/openyida. 宜搭表单业务关联规则与高级函数配置。用于在表单设置中配置业务关联规则,或使用 INSERT、UPDATE、DELETE、UPSERT 高级函数实现跨表增删改。适用于需要表单间数据联动的场景。

Its SKILL.md is about 770 tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

The repository describes itself as: Your own personal YiDA AI assistant! The licence is MIT.

Example prompts

  • “/yida-business-rule”

Workflow steps

9 steps, taken from the first numbered list in SKILL.md.

  1. 确认触发表单和目标表单都在同一应用内。
  2. 用 openyida get-schema 查清目标字段和来源字段,避免点错。
  3. 打开触发表单设计器,进入 表单设置 → 表单事件 → 公式执行 → 添加业务关联规则。
  4. 点击要配置的事件输入框,例如 单据编辑。
  5. 在公式编辑器中只手动输入函数名、括号、逗号、字符串常量。
  6. 目标表、目标列、来源字段全部从左侧列表点击插入令牌。
  7. 每插入一个令牌后暂停并校验公式显示,避免 CodeMirror 光标错位。
  8. 点击公式弹窗「确定」。如果能回到业务关联规则弹窗,说明公式通过编辑器校验。
  9. 点击业务关联规则弹窗「确定」,最后点击表单设计器「保存」并确认保存成功。

What it can do on your machine

Read from SKILL.md and the folder at commit 4932d0b. 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.

    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 Business Rule loads about 768 tokens when it runs. Until then it costs about 29 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
~29
When it runs · the whole SKILL.md, loaded when a task matches
~768

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 4932d0b, republished under its MIT licence (© openyida). 197 words, ~768 tokens.

Download SKILL.mdSave it as .claude/skills/yida-business-rule/SKILL.md (or your agent's skills folder).
name
yida-business-rule
description
宜搭表单业务关联规则与高级函数配置。用于在表单设置中配置业务关联规则,或使用 INSERT、UPDATE、DELETE、UPSERT 高级函数实现跨表增删改。适用于需要表单间数据联动的场景。

yida-business-rule — 业务关联规则高级函数

适用范围

业务关联规则是宜搭表单设置里的旧式/低频跨表联动能力。用户明确提到以下意图时使用本技能:

  • "业务关联规则"、"表单事件里的公式执行"
  • "高级函数"、"INSERT"、"UPDATE"、"DELETE"、"UPSERT"
  • "要在表单设置里配 upsert/update/delete/insert"
  • 明确不想用集成自动化,而要用公式函数做跨表增删改

配置入口

在表单设计器里进入:

text
表单设置 → 表单事件 → 公式执行 → 添加业务关联规则

业务关联规则弹窗包含三个事件输入框:

事件触发时机
单据提交新增记录提交成功后
单据删除删除记录成功后
单据编辑编辑记录提交成功后

点击事件输入框会打开「公式执行」编辑器。配置完成后必须依次确认:公式弹窗 → 业务关联规则弹窗 → 保存表单。

关键原则:必须插入令牌

业务关联公式不是普通字段公式。普通字段公式引用字段用 #{fieldId};业务关联规则引用目标表、目标字段、当前表字段时,必须在公式编辑器左侧列表点击插入令牌。

不要直接手敲中文表单名或字段名。实际验证中,手敲下面这种文本会报非法标识符:

text
UPSERT(Upsert目标,EQ(Upsert目标.键,"x"),"",Upsert目标.键,"x")

正确方式是在编辑器中输入函数名、括号、逗号、字符串常量,然后点击左侧字段列表插入 Upsert目标、Upsert目标.键 等令牌。最终输入框看起来可能和手敲文本相似,但内部结构不同。

高级函数签名

函数格式说明
INSERTINSERT(目标表, 目标列1, 目标值1, 目标列2, 目标值2, ...)向目标表插入新实例
UPDATEUPDATE(目标表, 主条件, 子条件, 目标列1, 目标值1, ...)更新目标表中满足条件的数据
UPSERTUPSERT(目标表, 主条件, 子条件, 目标列1, 目标值1, ...)有匹配数据则更新,无匹配数据则插入
DELETEDELETE(目标表, 主条件, 子条件)删除目标表中满足条件的数据

子条件 用于定位目标表某条数据下的子表单明细。不操作子表单时必须写 "",不能省略。

UPSERT 模板

普通主表字段 upsert:

text
UPSERT(目标表, EQ(目标表.业务键, 当前表业务键), "", 目标表.业务键, 当前表业务键, 目标表.目标字段, 当前表来源字段)

库存类示例:

text
UPSERT(存货表, EQ(存货表.商品名, 商品名), "", 存货表.商品名, 商品名, 存货表.存货量, 存货表.存货量 + 进货量)

固定值探测示例:

text
UPSERT(Upsert目标, EQ(Upsert目标.键, "_openyida_upsert_probe"), "", Upsert目标.键, "_openyida_upsert_probe", Upsert目标.备注, "configured from form settings")

以上示例中的表单名和字段名只是可读展示。真实配置时,所有表单和字段引用都要从左侧列表点击插入令牌。

条件规则

  • 主条件、子条件 必须由逻辑函数构造,常见为 EQ()、AND()、OR()。
  • 除 AND()、OR() 外,逻辑函数第一个参数必须是目标表组件,例如 EQ(存货表.商品名, 商品名)。
  • 不要把当前表字段写在 EQ() 第一个参数,也不要在第一个参数里嵌套其他函数。
  • 更新普通组件时,目标列 必须是目标表普通组件。
  • 更新子表单明细时,目标列 必须是对应明细下的组件。
  • 同一个高级函数里不要同时更新普通组件和明细组件;需要拆成多条规则或多个函数。

浏览器配置步骤

  1. 确认触发表单和目标表单都在同一应用内。
  2. 用 openyida get-schema <appType> <formUuid> 查清目标字段和来源字段,避免点错。
  3. 打开触发表单设计器,进入 表单设置 → 表单事件 → 公式执行 → 添加业务关联规则。
  4. 点击要配置的事件输入框,例如 单据编辑。
  5. 在公式编辑器中只手动输入函数名、括号、逗号、字符串常量。
  6. 目标表、目标列、来源字段全部从左侧列表点击插入令牌。
  7. 每插入一个令牌后暂停并校验公式显示,避免 CodeMirror 光标错位。
  8. 点击公式弹窗「确定」。如果能回到业务关联规则弹窗,说明公式通过编辑器校验。
  9. 点击业务关联规则弹窗「确定」,最后点击表单设计器「保存」并确认保存成功。

用量限制

函数目标表类型用量限制
INSERT主表批量导入无条数限制,建议单次不超过 1000 条
INSERT子表单插入主表免费版 ≤50 条;轻享/专业/专属版 ≤500 条
UPDATE主表单次最多更新 100 条,超出会报错
UPDATE子表单免费版 ≤50 条;轻享/专业/专属版 ≤500 条
UPSERT主表单次最多 100 条,超出会报错
UPSERT子表单免费版 ≤50 条;轻享/专业/专属版 ≤500 条
DELETE主表单次最多删除 100 条
DELETE子表单轻享/专业/专属版 ≤500 条

常见错误

错误原因处理
该标识符不合法手敲了表单名/字段名从左侧列表点击插入令牌
Unexpected end of input公式未闭合或必填参数缺失检查括号、逗号、子条件
规则未触发配在错误事件或未保存表单检查 单据提交/删除/编辑 和保存结果
更新结果过多条件不够精确或超出限制收紧 主条件,必要时改用集成自动化

参考

  • 宜搭帮助中心:表单业务规则
  • 宜搭帮助中心:INSERT / UPDATE / UPSERT / DELETE 业务关联公式

© 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

Just SKILL.md in yida-skills/skills/yida-business-rule of openyida/openyida.

Open the folder on GitHubat commit 4932d0b

Compare with similar skills

Yida Business Rule 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 Business Rule compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Yida Business Rule this skillopenyida/openyida221—~768Automated safety check: PassMIT
Codex Rules Referencecode-yeongyu/oh-my-openagent70k—~269Automated safety check: PassCustom licence
Rules Distillationaffaan-m/ECC277k2 repos~2.3kAutomated safety check: PassMIT
Hookify Rulesaffaan-m/ECC276k—~1.2kAutomated safety check: NotesMIT
Hookify Rulesaffaan-m/ECC276k—~605Automated safety check: NotesMIT
Rules Distillaffaan-m/ECC276k—~1.5kAutomated safety check: PassMIT

Similar skills

  • Codex Rules Reference

    code-yeongyu/oh-my-openagent

    Explains how the Codex Rules plugin injects project instructions and file-specific rules into a session, which rule files it reads and which settings control it.

    70k GitHub stars~269 tokensUpdated today
    Agent WorkflowsAuto-check passed
  • Rules Distillation

    affaan-m/ECC

    Scans installed skills for principles that recur across them and proposes rule-file changes: append, revise, add a section, create a file or leave as covered.

    277k GitHub starsUsed in 2 repos~2.3k tokens
    Agent WorkflowsAuto-check passed
  • Hookify Rules

    affaan-m/ECC

    Create and configure hookify rules — markdown files with YAML frontmatter that match bash, file, prompt, or stop events by regex or conditions and show warn/block messages to the agent.

    276k GitHub stars~1.2k tokensUpdated yesterday
    Agent WorkflowsAuto-check: notes
  • Hookify Rules

    affaan-m/ECC

    当用户要求创建hookify规则、编写hook规则、配置hookify、添加hookify规则或需要关于hookify规则语法和模式的指导时,应使用此技能。

    276k GitHub stars~605 tokensUpdated yesterday
    Agent WorkflowsAuto-check: notes
  • Rules Distill

    affaan-m/ECC

    スキルをスキャンしてドメイン横断的な原則を抽出し、ルールに蒸留する——既存のルールファイルへの追記、修正、または新規作成

    276k GitHub stars~1.5k tokensUpdated yesterday
    Auto-check passed
  • Rules Distill

    affaan-m/ECC

    扫描技能以提取跨领域原则并将其提炼为规则——追加、修订或创建新的规则文件

    276k GitHub starsUsed in 1 repo~1.3k tokens
    Auto-check passed

More from openyida/openyida

All 59 skills in this repo
  • Yida Canvas Custom Page

    openyida/openyida

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

    221 GitHub stars~4.3k tokensUpdated yesterday
    Auto-check passed
  • Openyida Release

    openyida/openyida

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

    221 GitHub stars~520 tokensUpdated yesterday
    Auto-check passed
  • Yida Design Plan

    openyida/openyida

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

    221 GitHub stars~756 tokensUpdated yesterday
    Auto-check passed
  • Prevent stale local OpenYida custom page source from overwriting live designer edits.

    221 GitHub stars~1.2k tokensUpdated yesterday
    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.

    221 GitHub stars~1k tokensUpdated yesterday
    Auto-check passed
  • Sdd Riper One Light

    openyida/openyida

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

    221 GitHub stars~1.5k tokensUpdated yesterday
    Auto-check passed

Questions about Yida Business Rule

What does Yida Business Rule do?

宜搭表单业务关联规则与高级函数配置。用于在表单设置中配置业务关联规则,或使用 INSERT、UPDATE、DELETE、UPSERT 高级函数实现跨表增删改。适用于需要表单间数据联动的场景。. Yida Business Rule is an agent skill from openyida/openyida.

How do I install Yida Business Rule in Claude Code?

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

How do I install Yida Business Rule in Codex?

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

Can I use Yida Business Rule 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-business-rule -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-business-rule, .gemini/skills/yida-business-rule, .github/skills/yida-business-rule and .opencode/skills/yida-business-rule in your project.

What does Yida Business Rule need to run?

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

Does Yida Business Rule 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 Business Rule 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 Business Rule use?

Yida Business Rule 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 Business Rule use?

About 768 tokens (SKILL.md is roughly 3.1k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Yida Business Rule?

Skills that share tags, products or a category with Yida Business Rule: Codex Rules Reference (code-yeongyu/oh-my-openagent, 70k stars), Rules Distillation (affaan-m/ECC, 277k stars), Hookify Rules (affaan-m/ECC, 276k stars) and Hookify Rules (affaan-m/ECC, 276k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Yida Business Rule?

openyida (a GitHub organization) maintains it in openyida/openyida, which has 221 GitHub stars. The repository holds 59 skills in this directory. The repository was last updated on October 10, 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.