yida-business-rule SKILL.md skillA
yida-business-rule from openyida/openyida is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.
mdr add openyida/openyida/yida-business-rule@git:20261018.e0d7221Pins git:20261018.e0d7221 in mdr.lock. Pin the fingerprint instead.
- Audit grade
- A, 17 of 17 checks passed
- Kind
- SKILL.md skill
- Repository
- openyida/openyida
- Path
yida-skills/skills/yida-business-rule/SKILL.md- Versions recorded
- 6
- Latest version
- git:20261018.e0d7221, committed Oct 18, 2026
- First version recorded
- May 19, 2026
- Size
- 6,623 bytes
- Repository stars
- 231
- License
- MIT
宜搭表单业务关联规则与高级函数配置。用于在表单设置中配置业务关联规则，或使用 INSERT、UPDATE、DELETE、UPSERT 高级函数实现跨表增删改。适用于需要表单间数据联动的场景。.
Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.
What the file says
# yida-business-rule — 业务关联规则高级函数
## 适用范围
业务关联规则是宜搭表单设置里的旧式/低频跨表联动能力。用户明确提到以下意图时使用本技能：
- "业务关联规则"、"表单事件里的公式执行"
- "高级函数"、"INSERT"、"UPDATE"、"DELETE"、"UPSERT"
- "要在表单设置里配 upsert/update/delete/insert"
- 明确不想用集成自动化，而要用公式函数做跨表增删改
## 配置入口
在表单设计器里进入：
```text
表单设置 → 表单事件 → 公式执行 → 添加业务关联规则
```
业务关联规则弹窗包含三个事件输入框：
| 事件 | 触发时机 |
|------|---------|
| `单据提交` | 新增记录提交成功后 |
| `单据删除` | 删除记录成功后 |
| `单据编辑` | 编辑记录提交成功后 |
点击事件输入框会打开「公式执行」编辑器。配置完成后必须依次确认：公式弹窗 → 业务关联规则弹窗 → 保存表单。
## 关键原则：必须插入令牌
编写前通过 `use_skill` 加载 `yida-formula`，查看“写配置前先处理这些易错点”，共用函数和字段选择方法。业务动作保留目标表、当前数据、事件及完整规则；条件中的 `AND/EQ` 等按该动作的查询条件含义处理。通用表达式试算不执行这些写数据动作；保存回读与实际新增、修改、删除结果分别说明。
业务关联公式不是普通字段公式。普通字段公式引用字段用 `#{fieldId}`；业务关联规则引用目标表、目标字段、当前表字段时，必须在公式编辑器左侧列表点击插入令牌。
不要直接手敲中文表单名或字段名。实际验证中，手敲下面这种文本会报非法标识符：
```text
UPSERT(Upsert目标,EQ(Upsert目标.键,"x"),"",Upsert目标.键,"x")
```
正确方式是在编辑器中输入函数名、括号、逗号、字符串常量，然后点击左侧字段列表插入 `Upsert目标`、`Upsert目标.键` 等令牌。最终输入框看起来可能和手敲文本相似，但内部结构不同。
## 高级函数签名
| 函数 | 格式 | 说明 |
|------|------|------|
| `INSERT` | `INSERT(目标表, 目标列1, 目标值1, 目标列2, 目标值2, ...)` | 向目标表插入新实例 |
| `UPDATE` | `UPDATE(目标表, 主条件, 子条件, 目标列1, 目标值1, ...)` | 更新目标表中满足条件的数据 |
…Read the whole file at its exact version.
How to install
mdr add openyida/openyida/yida-business-rule@sha256:7b68eb7f03dae283The line at the top of this page pins the label git:20261018.e0d7221, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.
[](https://markdownregistry.com/a/art_5augku6v5pl3qerg)
4 badge image fetches in 30 days. What the badge shows.
Versions
The registry has recorded 6 versions of this file, between May 19, 2026 and Oct 18, 2026, about one every 30 days.
| version | committed | commit | size | audit | |
|---|---|---|---|---|---|
| git:20261018.e0d7221 latest | 2026-10-18 | e0d7221 | 6,623 B | A | view · diff |
| git:20261018.9a88d90 | 2026-10-18 | 9a88d90 | 6,622 B | A | view · diff |
| git:20260717.d0ccc71 | 2026-07-17 | d0ccc71 | 6,226 B | A | view · diff |
| git:20260702.ac3bada | 2026-07-02 | ac3bada | 6,689 B | A | view · diff |
| git:20260519.93b0f24 | 2026-05-19 | 93b0f24 | 6,817 B | A | view · diff |
| git:20260519.a27e387 | 2026-05-19 | a27e387 | 6,714 B | A | view |
Audit of the latest version
- pass: Frontmatter block present
- pass: Frontmatter declares a name
- pass: Frontmatter declares a description
- pass: Size between 200 bytes and 200 KB (6623 bytes)
- pass: No zero-width or bidi control characters
- pass: No instruction hidden inside an HTML comment
- pass: No link to an exfiltration or paste host
- pass: No credential-shaped string
- pass: No instruction to send local credentials anywhere
- pass: No text hidden with inline styles
- pass: No prompt-injection phrasing
- pass: No curl or wget piped into a shell
- pass: No recursive delete of root, home or parent
- pass: No instruction to read or print local credentials
- pass: No base64 blob over 200 characters
- pass: No link to a raw IP address
- pass: No script tag
Source
openyida/openyida · 231 stars · license MIT · pushed 2026-11-06 · branch main
API
GET https://markdownregistry.com/api/v1/artifacts/art_5augku6v5pl3qerg GET https://markdownregistry.com/api/v1/resolve?ref=openyida/openyida/yida-business-rule GET https://markdownregistry.com/api/v1/blob/7b68eb7f03dae2830a4c2091d593f2a146e52bd222c5b8016c1c1ad90471c279
Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.
Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.