ACAW study materials
ACAW study resources

ACAW: Macros and Application Building

ACAW · Work through your exam, one topic at a time.

All guide sections

Macros and Application Building

Macros extend workflows. Three types: Standard (a reusable tool with input/output anchors), Batch (iterates over grouped records, one group per run), and Iterative (loops until a condition is met). The Macro Input and Macro Output tools define the interface; Control Parameter passes configuration. Standard macros appear on the tool palette after saving as .yxmc.

Batch macro traps: the Control Parameter must be wired to the tool that changes per group, and the macro runs once per unique value of the grouping field. Iterative macros require an Iteration Output anchor to feed the next loop and a condition (e.g., max iterations or a stop flag). A common question asks why a batch macro returns the same result for every group - the answer is that a filter or control parameter is not connected, so the macro ignores the group value.

Interface tools (for apps) include Text Box, Drop Down, List Box, Check Box, File Browse, and Action tools that connect interface elements to workflow tools. The Interface Designer sets tab order and output modes.

Rule of thumb: test a macro by running it standalone with sample data before embedding it in a larger workflow.

Worked example: process 12 monthly files with one batch macro. Group by filename, pass the filename via Control Parameter to a Dynamic Input tool; the macro runs 12 times, once per file.