iaud-formula

Name: iaud-formula
Availability: InStock
Author: aud-dev-team

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

Ready to run

npx skills add https://github.com/AUD-DEV-TEAM/i-AUD-Developer-Kit --skill iaud-formula

💬 Prompt for ChatGPT / Claude Chat▼

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.