skills.rest
AUD-DEV-TEAM
AUD-DEV-TEAMCOMMUNITY
Explore all skills by this author →
GitHub

iaud-formula

Define and evaluate UI formulas for i-AUD controls with arithmetic and logical functions.

3|1|Updated Jun 12, 2025
Search Tags:#ui#calculation#formula#grid#iaud#textbox
One-click install
npx skills add https://github.com/AUD-DEV-TEAM/i-AUD-Developer-Kit --skill iaud-formula
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: iaud-formula
Source: https://github.com/AUD-DEV-TEAM/i-AUD-Developer-Kit/tree/main/.claude/skills/iaud-formula
Command: npx skills add https://github.com/AUD-DEV-TEAM/i-AUD-Developer-Kit --skill iaud-formula

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

i-AUD 계산수식(FormulaManager)은 텍스트박스, 라벨, 데이터그리드 등의 컨트롤에 수식을 설정하여 값을 자동 연산하는 시스템이다. 수식 내 다른 컨트롤을 참조하면 해당 컨트롤의 값 변경 시 자동으로 재연산된다.

Core Features & Use Cases

  • 컨트롤 간 참조를 통해 실시간 계산을 구현합니다(e.g., :txtPrice, :txtQty와 같은 참조를 사용).
  • 다양한 함수 세트(IIF/CASE, AND/OR, 수학 연산, 문자열/날짜 변환 등)를 활용해 비즈니스 로직을 UI에서 직접 구현할 수 있습니다.
  • 데이터그리드 및 텍스트박스/레이블의 수식을 통해 총계, 비율, 조건부 메시지 등 동적 피드백을 제공합니다.

Quick Start

Create a simple formula to multiply :txtPrice and :txtQty and assign it to the target control's Formula.

Frequently Asked Questions about iaud-formula

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

FAQPage Schema
How do I calculate dynamic form totals automatically when input values change in a UI?▼

Define UI formulas on TextBox or Label controls that reference each other, such as multiplying :txtPrice and :txtQty, to trigger real-time automatic re-calculation whenever a referenced input value changes.

What functions are available for building UI formulas for text and grid controls?▼

UI formulas support a rich syntax including arithmetic operations, logical operators like AND/OR, conditional functions like IIF and CASE, and data-type conversion functions for strings and dates to build complex logic.

Can I use JavaScript mode for UI calculations instead of standard formula expressions?▼

Yes, the formula system supports both standard expression mode for typical arithmetic and logical operations, and JavaScript mode for scenarios requiring more advanced programmatic logic in UI calculations.

How do I apply conditional messaging or derived metrics inside a DataGrid?▼

You can apply formulas directly to DataGrid controls to compute grid-based derived metrics and display conditional messages, using references to other controls to automate value calculations dynamically.

Do I need external dependencies or libraries to evaluate real-time UI formulas?▼

No, the formula system operates directly within the i-AUD environment to evaluate UI formulas across TextBox, Label, and DataGrid controls without requiring any external dependencies or libraries.

Why does my UI formula not recalculate when I update a referenced TextBox value?▼

UI formulas recalculate automatically when referenced controls change, so ensure the target control's Formula property correctly uses the colon syntax like :txtPrice to establish the proper reference link for re-evaluation.

Related Skills

Explore More Data & Analytics Skills→
linuxdevellinuxdevel
27

avalonia-controls-data-display

Render and interact with collection data in Avalonia UI controls.

Community
Intermediate
ajayatwal1105-emersonajayatwal1105-emerson

data-export

Export marketing metrics, contacts, campaigns, and performance snapshots to BigQuery, Google Sheets, or Supabase.

Community
Advanced
AUD-DEV-TEAMAUD-DEV-TEAM
3

iaud-sql-guide

Define i-AUD DataSource SQL with parameter binding and dynamic scripting.

Community
Intermediate
readtheskillreadtheskill
3

coingecko-api

Fetch real-time cryptocurrency prices, OHLC data, and on-chain analytics via the CoinGecko GOAT plugin.

Official
Intermediate