yida-formula

Automate formula-based field calculations for YiDa forms with field references.

201|43|Updated Mar 5, 2026
One-click install
npx skills add https://github.com/openyida/openyida --skill yida-formula
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: yida-formula
Source: https://github.com/openyida/openyida/tree/main/yida-skills/skills/yida-formula
Command: npx skills add https://github.com/openyida/openyida --skill yida-formula

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

宜搭表单公式可以让非开发人员在表单字段上直接配置公式,从而实现自动计算、默认值、校验和业务关联规则,降低重复工作并减少错误。

Core Features & Use Cases

  • 字段默认值公式:在数字、文本、日期等字段上配置公式,自动填充值。
  • 字段校验与业务规则:提交时执行自定义校验与跨表业务流程触发。
  • 场景示例:通过公式计算成本、工时、日期等字段,提升表单智能化。

Quick Start

在表单字段的属性中开启公式并使用 #{fieldId} 引用实现自动计算和默认值填充。

Frequently Asked Questions about yida-formula

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate form field calculations in YiDa?

To automate form field calculations in YiDa, enable formulas in field properties and use the {#{fieldId}} reference syntax to trigger automatic calculations and default value population. This approach handles default values, field validations, and cross-field rules.

What is the syntax for field references in low-code form formulas?

Field references in low-code form formulas require the {#{fieldId}} syntax. Formulas must also use uppercase function names and English punctuation to properly execute default values, validations, and cross-field business rules.

Can I set default values for date and text fields using business rules?

Yes, you can set default values for date, text, and number fields using business rules. By configuring formulas directly on these fields, the form auto-populates values, reducing manual data entry and ensuring consistency.

How do I add field validation to a form before submission?

You add field validation to a form by applying custom validation formulas to the target fields. These formulas execute during submission to enforce business rules and ensure data accuracy before the form is accepted.

What are the limitations of using formulas for cross-field calculations?

Limitations of using formulas for cross-field calculations include strict syntax requirements: functions must be uppercase, punctuation must be English, and field references must use the {#{fieldId}} format, which may require precise adherence to avoid errors.