宜搭表单公式编写规范，包含 60+ 内置函数速查、语法规则和常见场景示例。适用于编写表单字段公式、校验规则和计算逻辑时。
$ npx skills add openyida/openyida --skill yida-formula -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install openyida/openyida yida-formula --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/openyida/openyida.git skills-src && mkdir -p .claude/skills && cp -r skills-src/yida-skills/skills/yida-formula .claude/skills/yida-formula && rm -rf skills-srcUse ~/.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/
Install the "yida-formula" agent skill from https://github.com/openyida/openyida/tree/main/yida-skills/skills/yida-formula into .claude/skills/yida-formula/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "yida-formula", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/openyida/openyida/tree/main/yida-skills/skills/yida-formulaType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add openyida/openyida --skill yida-formula -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install openyida/openyida yida-formula --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/openyida/openyida.git skills-src && mkdir -p .agents/skills && cp -r skills-src/yida-skills/skills/yida-formula .agents/skills/yida-formula && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "yida-formula" agent skill from https://github.com/openyida/openyida/tree/main/yida-skills/skills/yida-formula into .agents/skills/yida-formula/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "yida-formula", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add openyida/openyida --skill yida-formula -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install openyida/openyida yida-formula --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/openyida/openyida.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/yida-skills/skills/yida-formula .cursor/skills/yida-formula && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "yida-formula" agent skill from https://github.com/openyida/openyida/tree/main/yida-skills/skills/yida-formula into .cursor/skills/yida-formula/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "yida-formula", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/openyida/openyida.git --path yida-skills/skills/yida-formula--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add openyida/openyida --skill yida-formula -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install openyida/openyida yida-formula --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/openyida/openyida.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/yida-skills/skills/yida-formula .gemini/skills/yida-formula && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "yida-formula" agent skill from https://github.com/openyida/openyida/tree/main/yida-skills/skills/yida-formula into .gemini/skills/yida-formula/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "yida-formula", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install openyida/openyida yida-formulaInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add openyida/openyida --skill yida-formula -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/openyida/openyida.git skills-src && mkdir -p .github/skills && cp -r skills-src/yida-skills/skills/yida-formula .github/skills/yida-formula && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "yida-formula" agent skill from https://github.com/openyida/openyida/tree/main/yida-skills/skills/yida-formula into .github/skills/yida-formula/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "yida-formula", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add openyida/openyida --skill yida-formula -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install openyida/openyida yida-formula --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/openyida/openyida.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/yida-skills/skills/yida-formula .opencode/skills/yida-formula && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "yida-formula" agent skill from https://github.com/openyida/openyida/tree/main/yida-skills/skills/yida-formula into .opencode/skills/yida-formula/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "yida-formula", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
yida-formula宜搭表单公式编写规范，包含 60+ 内置函数速查、语法规则和常见场景示例。适用于编写表单字段公式、校验规则和计算逻辑时。
Yida Formula is an agent skill from openyida/openyida. 宜搭表单公式编写规范，包含 60+ 内置函数速查、语法规则和常见场景示例。适用于编写表单字段公式、校验规则和计算逻辑时。
Its SKILL.md is about 2.7k 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`).
The repository describes itself as: Your own personal YiDA AI assistant! The licence is MIT.
3 steps, taken from the first numbered list in SKILL.md.
Read from SKILL.md and the folder at commit 3dd4693. It shows what the files ask for, not the result of running them.
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.
No scripts in the folder and no shell commands in SKILL.md (its code samples are json).
From the folder's file list and the shell code blocks in SKILL.md.
No URLs in SKILL.md.
From URLs in SKILL.md, links to its own repository left out.
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Yida Formula loads about 2.7k tokens when it runs, and up to ~3.6k if it reads all its reference files. Until then it costs about 18 tokens; SKILL.md has 566 words of instructions outside code blocks.
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.
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.
The full file from openyida/openyida at commit 3dd4693, republished under its MIT licence (© openyida). 566 words, ~2,720 tokens.
.claude/skills/yida-formula/SKILL.md (or your agent's skills folder). This skill also uses 1 other file; get the full folder from GitHub.正向触发（以下场景必须使用本技能）：
宜搭公式可以：
完整函数列表参见
../../references/formula-functions.md
官方示例中心的公式类示例基本落在普通表单或流程表单 schema 中，而不是自定义页面。遇到“日期转换、流水号、登录人、主管、相隔时间、求和”等能力时，默认先配置字段公式或字段联动；只有公式无法表达、且需要跨表提交后动作时，再用提交后编排能力实现。
宜搭没有独立的"公式字段"组件。公式是配置在普通字段（NumberField、TextField、DateField、EmployeeField 等）的属性上的：
| 配置位置 | 说明 | 典型场景 |
|---|---|---|
| 字段的「默认值」→「公式」 | 字段打开时自动计算并填入值 | 总金额 = 单价 × 数量 |
| 字段的「校验」→「自定义校验」 | 提交时校验字段值是否合法 | 结束日期必须晚于开始日期 |
| 表单设置 → 表单事件 → 公式执行 → 添加业务关联规则 | 提交后触发跨表数据操作 | 不属于字段公式 |
通过 openyida create-form 的 create 或 update 模式，可以直接在字段上配置公式。
公式中引用其他字段时，使用 #{fieldId} 格式（不是直接写 fieldId）：
# ✅ 正确：用 #{} 包裹 fieldId
ROUND(#{numberField_abc} * #{numberField_xyz}, 2)
# ❌ 错误：直接写 fieldId
ROUND(numberField_abc * numberField_xyz, 2)需要同时设置以下三个属性：
| 属性 | 值 | 说明 |
|---|---|---|
valueType | "formula" | 声明该字段值由公式计算 |
complexValue | {"complexType":"formula","formula":"<公式字符串>"} | 公式配置对象 |
formula | "<公式字符串>" | 与 complexValue.formula 相同的公式字符串 |
[
{
"type": "NumberField",
"label": "总金额",
"behavior": "READONLY",
"valueType": "formula",
"complexValue": {
"complexType": "formula",
"formula": "ROUND(#{numberField_price} * #{numberField_qty}, 2)"
},
"formula": "ROUND(#{numberField_price} * #{numberField_qty}, 2)"
}
][
{
"action": "update",
"label": "总金额",
"changes": {
"valueType": "formula",
"complexValue": {
"complexType": "formula",
"formula": "ROUND(#{numberField_price} * #{numberField_qty}, 2)"
},
"formula": "ROUND(#{numberField_price} * #{numberField_qty}, 2)"
}
}
]公式中引用的 fieldId（如 numberField_abc123）必须是表单中真实存在的字段 ID，不能猜测。正确工作流程：
Step 1: create 模式创建基础字段（不含公式）
↓
Step 2: openyida get-schema 获取各字段的真实 fieldId
↓
Step 3: create 或 update 模式添加/更新带公式的字段，引用真实 #{fieldId}SUM、IF、CONCATENATE，不能写成 sum、if()、逗号 ,、引号 ""，不能用中文符号"优秀"、"已完成"+（加）、-（减）、*（乘）、/（除）>=、<=、>、<、==、!=，必须改用 GE()、LE()、GT()、LT()、EQ()、NE() 函数公式中引用表单字段时，使用 #{fieldId} 格式（必须用 #{} 包裹）：
# 引用主表字段（用 #{} 包裹 fieldId）
#{textField_abc123}
# 引用子表（TableField）内的字段
#{tableField_xxx.numberField_yyy}
# 引用当前登录用户（无需字段 ID）
USER()
# 引用当前时间（无需字段 ID）
NOW()
TODAY()如何获取 fieldId：使用
openyida get-schema <appType> <formUuid>获取表单 Schema，其中每个字段的fieldId属性即为字段 ID。
公式结果只能赋值给同类型的组件：
| 公式/来源类型 | 可赋值的目标组件 |
|---|---|
| 文本函数结果 | 单行文本、多行文本 |
| 数值计算结果 | 数值、单行文本、多行文本 |
| 日期函数结果 | 日期 |
| 人员函数结果 | 成员 |
| 单选/下拉单选 | 单选、下拉单选 |
| 复选/下拉复选 | 复选、下拉复选 |
业务关联规则、高级函数、INSERT/UPDATE/DELETE/UPSERT 不属于字段公式。本技能只处理普通字段公式、默认值公式和自定义校验公式。
完整函数参数说明见
../../references/formula-functions.md
| 函数 | 用途 | 示例 |
|---|---|---|
CONCATENATE(text1, text2, ...) | 拼接多个文本 | CONCATENATE(#{textField_firstName}, #{textField_lastName}) |
LEFT(text, n) | 取左侧 n 个字符 | LEFT(#{textField_code}, 4) |
RIGHT(text, n) | 取右侧 n 个字符 | RIGHT(#{textField_idCard}, 4) |
MID(text, start, n) | 取中间字符 | MID(#{textField_code}, 3, 4) |
LEN(text) | 获取字符串长度 | LEN(#{textField_content}) |
TRIM(text) | 去除首尾空格 | TRIM(#{textField_name}) |
UPPER(text) | 转大写 | UPPER(#{textField_code}) |
LOWER(text) | 转小写 | LOWER(#{textField_email}) |
REPLACE(text, start, n, newText) | 替换指定位置字符 | REPLACE(#{textField_phone}, 4, 4, "****") |
TEXT(value, format) | 数值格式化为文本 | TEXT(#{numberField_amount}, "0.00") |
VALUE(text) | 文本转数字 | VALUE(#{textField_numStr}) |
UUID() | 生成唯一字符串 | UUID() |
RMBFORMAT(number) | 格式化为人民币 | RMBFORMAT(#{numberField_amount}) |
SPLIT(text, delimiter) | 按分隔符分割为数组 | SPLIT(#{textField_tags}, ",") |
ARRAYGET(array, index) | 取数组第 n 个元素 | ARRAYGET(SPLIT(#{textField_tags}, ","), 1) |
| 函数 | 用途 | 示例 |
|---|---|---|
TODAY() | 今天日期 | TODAY() |
NOW() | 当前时间 | NOW() |
YEAR(date) | 取年份 | YEAR(#{dateField_birthday}) |
MONTH(date) | 取月份 | MONTH(#{dateField_birthday}) |
DAY(date) | 取天数 | DAY(#{dateField_birthday}) |
DAYS(date1, date2) | 两日期相差天数 | DAYS(#{dateField_end}, #{dateField_start}) |
DATEDELTA(date, n) | 日期加减 n 天 | DATEDELTA(#{dateField_start}, 30) |
NETWORKDAYS(start, end) | 计算工作日天数 | NETWORKDAYS(#{dateField_start}, #{dateField_end}) |
TIMESTAMP(dateObj) | 日期对象转时间戳 | TIMESTAMP(TODAY()) |
DATE(timestamp) | 时间戳转日期对象 | DATE(#{numberField_ts}) |
CASCADEDATEINTERVAL(field) | 日期区间天数 | CASCADEDATEINTERVAL(#{cascadeDateField_range}) |
| 函数 | 用途 | 示例 |
|---|---|---|
IF(cond, trueVal, falseVal) | 条件判断 | IF(GE(#{numberField_score}, 90), "优秀", "良好") |
AND(cond1, cond2, ...) | 多条件同时成立 | AND(GE(#{numberField_age}, 18), LE(#{numberField_age}, 60)) |
OR(cond1, cond2, ...) | 任一条件成立 | OR(EQ(#{radioField_status}, "完成"), EQ(#{radioField_status}, "关闭")) |
NOT(cond) | 条件取反 | NOT(ISEMPTY(#{textField_name})) |
EQ(val1, val2) | 判断相等 | EQ(#{radioField_type}, "A类") |
NE(val1, val2) | 判断不等 | NE(#{radioField_status}, "已取消") |
GT(val1, val2) | 大于 | GT(#{numberField_amount}, 10000) |
GE(val1, val2) | 大于等于 | GE(#{numberField_score}, 60) |
LT(val1, val2) | 小于 | LT(#{numberField_stock}, 10) |
LE(val1, val2) | 小于等于 | LE(#{numberField_age}, 18) |
ISEMPTY(field) | 判断字段是否为空 | ISEMPTY(#{textField_remark}) |
TIMECOMPARE(date1, date2) | 比较日期大小 | TIMECOMPARE(#{dateField_end}, #{dateField_start}) |
| 函数 | 用途 | 示例 |
|---|---|---|
SUM(n1, n2, ...) | 求和 | SUM(#{tableField_items.numberField_amount}) |
AVERAGE(n1, n2, ...) | 平均值 | AVERAGE(#{numberField_q1}, #{numberField_q2}, #{numberField_q3}) |
MAX(n1, n2, ...) | 最大值 | MAX(#{numberField_a}, #{numberField_b}) |
MIN(n1, n2, ...) | 最小值 | MIN(#{numberField_a}, #{numberField_b}) |
ROUND(n, digits) | 四舍五入 | ROUND(#{numberField_price} * #{numberField_qty}, 2) |
INT(n) | 向下取整 | INT(#{numberField_total} / 30) |
ABS(n) | 绝对值 | ABS(#{numberField_diff}) |
MOD(n, divisor) | 取余 | MOD(#{numberField_count}, 7) |
PRODUCT(n1, n2, ...) | 乘积 | PRODUCT(#{numberField_price}, #{numberField_qty}) |
SUMPRODUCT(arr1, arr2) | 数组对应元素相乘后求和 | SUMPRODUCT(#{tableField_items.numberField_qty}, #{tableField_items.numberField_price}) |
SQRT(n) | 平方根 | SQRT(#{numberField_area}) |
POWER(n, p) | 乘幂 | POWER(#{numberField_base}, 2) |
COUNT(field) | 统计数据总数 | COUNT(#{tableField_items}) |
| 函数 | 用途 | 示例 |
|---|---|---|
USER() | 当前登录人（赋值给成员字段） | USER() |
USER(level) | 当前登录人的第 level 级主管 | USER(1) |
GETUSERNAME() | 当前登录人昵称（赋值给文本字段） | GETUSERNAME() |
LOGINUSERWORKNO() | 当前登录人员工 ID | LOGINUSERWORKNO() |
DEPTNAME(userId) | 指定用户所在部门名称 | DEPTNAME(LOGINUSERWORKNO()) |
DIRECTOR() | 当前登录人的主管名称 | DIRECTOR() |
| 函数 | 用途 | 示例 |
|---|---|---|
UNIONSET(set1, set2) | 两集合并集 | UNIONSET(#{checkboxField_a}, #{checkboxField_b}) |
INTERSECTIONSET(set1, set2) | 两集合交集 | INTERSECTIONSET(#{checkboxField_a}, #{checkboxField_b}) |
DIFFERENCESET(set1, set2) | 两集合差集 | DIFFERENCESET(#{checkboxField_all}, #{checkboxField_selected}) |
EXIST(val, set) | 判断值是否在集合中 | EXIST(#{textField_tag}, #{checkboxField_tags}) |
| 函数 | 用途 | 示例 |
|---|---|---|
EXACT(text1, text2) | 严格比较字符串（区分大小写） | EXACT(#{textField_password}, #{textField_confirm}) |
ARRAYREPEATED(array) | 判断数组是否有重复 | ARRAYREPEATED(#{tableField_items.textField_code}) |
SUM(#{tableField_items.numberField_amount})ROUND(#{numberField_price} * #{numberField_qty}, 2)SUMPRODUCT(#{tableField_items.numberField_qty}, #{tableField_items.numberField_price})IF(GE(#{numberField_score}, 90), "A", IF(GE(#{numberField_score}, 75), "B", IF(GE(#{numberField_score}, 60), "C", "D")))IF(AND(GE(#{numberField_age}, 18), LE(#{numberField_age}, 60)), "适龄员工", "不符合条件")DAYS(#{dateField_endDate}, #{dateField_startDate})DATEDELTA(#{dateField_joinDate}, 90)INT(DAYS(TODAY(), #{dateField_joinDate}) / 365)USER()GETUSERNAME()DEPTNAME(LOGINUSERWORKNO())CONCATENATE(#{textField_name}, "(", #{textField_workNo}, ")")REPLACE(#{textField_phone}, 4, 4, "****")IF(ISEMPTY(#{textField_remark}), "无备注", #{textField_remark})UUID()NETWORKDAYS(#{dateField_startDate}, #{dateField_endDate})RMBFORMAT(#{numberField_amount})ARRAYGET(SPLIT(#{textField_tags}, ","), 1)公式中不能引用当前正在配置公式的字段本身，否则会报「表单中的公式存在循环依赖」错误。
错误示例：在 numberField_total 的公式中引用 numberField_total 自身。
隐藏字段（behavior: "HIDDEN"）默认不参与公式计算。若需要隐藏字段参与计算，必须在字段配置中开启「始终提交」选项。
日期字段的底层值是时间戳，直接用时间戳做判断条件不准确。推荐做法：
INSERT/UPDATE/DELETE/UPSERT 属于表单事件里的业务关联规则高级函数，不属于普通字段公式。遇到这类需求时切换到 yida-business-rule。
| 异常场景 | 处理方式 |
|---|---|
| 公式报"函数不存在" | 只能使用 formula-functions.md 中列出的函数，检查函数名拼写和大小写 |
| 公式报"循环依赖" | 公式中不能引用当前字段本身，检查是否存在循环引用 |
| 字段值未自动计算 | 确认字段已设置 valueType: "formula"，隐藏字段需开启「始终提交」 |
| 比较运算符报错 | 禁止使用 >=、<= 等符号，必须改用 GE()、LE() 等函数 |
| 误把高级函数写到字段公式里 | 切换到 yida-business-rule，在表单事件的业务关联规则中配置 |
| 字段 ID 引用错误 | 先用 openyida get-schema 获取真实 fieldId，公式中用 #{fieldId} 格式引用 |
本技能不读写 memory。公式配置通过 openyida create-form 命令写入宜搭平台，fieldId 等技术信息写入 .cache/ 临时文件，不依赖跨会话的 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
SKILL.md and 1 other file (references) in yida-skills/skills/yida-formula of openyida/openyida.
Open the folder on GitHubat commit 3dd4693
Yida Formula 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.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Yida Formula this skillopenyida/openyida | 220 | — | ~2.7k | Automated safety check: Pass | MIT | |
| Spreadsheet Formula Helpercomposio-community/awesome-codex-skills | 17k | — | ~328 | Automated safety check: Pass | None | |
| Runtime Formulasbaserow/baserow | 6.1k | — | ~3.5k | Automated safety check: Pass | Custom licence | |
| Formula Detanglermohitagw15856/pm-claude-skills | 1.4k | — | ~1.4k | Automated safety check: Pass | MIT | |
| Excel Formula Generatorjeremylongshore/tons-of-skills-marketplace | 2.8k | — | ~587 | Automated safety check: Pass | MIT | |
| CSV Formula Injectionyaklang/hack-skills | 2.4k | — | ~1.1k | Automated safety check: Pass | MIT |
composio-community/awesome-codex-skills
Write and debug spreadsheet formulas (Excel/Google Sheets), pivot tables, and array formulas; translate between dialects; use when users need working formulas with examples and edge-case checks.
baserow/baserow
Explain, debug, or extend Baserow runtime formulas, including FormulaField/JSONFormulaField storage, FormulaSerializerField validation, runtime formula functions, backend and frontend data…
mohitagw15856/pm-claude-skills
Untangle the spreadsheet formula nobody dares touch — decompose the seven-function nest into named readable steps, explain what it actually does (vs.
jeremylongshore/tons-of-skills-marketplace
Generate excel formula generator operations. An agent skill from jeremylongshore/tons-of-skills-marketplace.
yaklang/hack-skills
CSV/spreadsheet formula injection (DDE, Excel/LibreOffice, Google Sheets IMPORT).
LeoYeAI/openclaw-master-skills
钉钉宜搭低代码开发助手。用于创建表单和自定义页面、编写 JS 动作面板、使用 JS-API、配置数据源、设计流程自动化。适用于宜搭表单开发、JS 代码调试、API 集成等场景。
openyida/openyida
宜搭自定义页面开发规范，使用 YidaCodeCanvas 组件实现现代 React18 自定义页面。用于官网、看板、工作台、列表、详情、门户壳、可视化、hooks 交互、表单入口，以及需要门户组件、数据管理视图、成员、部门或上传组件的场景；发布层自动注入 yida/utils window 桥。
openyida/openyida
快速发布 OpenYida npm 正式版或测试版。用户说“发布正式版”“发布测试版”“发 beta”或要求按当天日期生成版本 tag 时使用；不用于宜搭应用或自定义页面发布。
openyida/openyida
Plan 模式的视觉设计分支。基于需求选择视觉方向，再结合业务页面规划维护 build-plan.json 的 visualStyle，供 CLI 派生 design.md。
openyida/openyida
Prevent stale local OpenYida custom page source from overwriting live designer edits.
openyida/openyida
Generate, update, or drift-check agent-facing CodeMaps as progressive code terrain indexes for projects, features, capabilities, functions, modules, or bug chains.
openyida/openyida
面向 GPT-5.5 等强模型和熟练用户的轻量 AI Agent Harness / checkpoint-driven coding skill。默认用户已经把任务切到基本可执行的最小混沌单元；模型自行分解、探索与推进，人类通过最终目标、最小 spec、复述、checkpoint、证据验证与回写来低干扰控盘。
宜搭表单公式编写规范，包含 60+ 内置函数速查、语法规则和常见场景示例。适用于编写表单字段公式、校验规则和计算逻辑时。. Yida Formula is an agent skill from openyida/openyida.
Run `npx skills add openyida/openyida --skill yida-formula -a claude-code`. Or copy the skill folder (yida-skills/skills/yida-formula in openyida/openyida) into .claude/skills/yida-formula in your project. Claude Code loads it when a task matches its description.
Run `npx skills add openyida/openyida --skill yida-formula -a codex`. Or copy the skill folder (yida-skills/skills/yida-formula in openyida/openyida) into .agents/skills/yida-formula in your project. Codex loads it when a task matches its description.
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add openyida/openyida --skill yida-formula -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-formula, .gemini/skills/yida-formula, .github/skills/yida-formula and .opencode/skills/yida-formula in your project.
SKILL.md names no scripts, command-line tools or credentials: Yida Formula is instructions for the agent only.
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.
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.
Yida Formula is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.
About 2.7k tokens (SKILL.md is roughly 11k 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 883 tokens, read only when the agent opens those files.
Skills that share tags, products or a category with Yida Formula: Spreadsheet Formula Helper (composio-community/awesome-codex-skills, 17k stars), Runtime Formulas (baserow/baserow, 6.1k stars), Formula Detangler (mohitagw15856/pm-claude-skills, 1.4k stars) and Excel Formula Generator (jeremylongshore/tons-of-skills-marketplace, 2.8k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
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.
