Macros¶
The Macro System lets you automate repetitive tasks by assembling sequences of actions that can be triggered manually or automatically.
Creating a Macro¶
Open the Macros panel from the Database menu or the Navigation Panel. Click New Macro to create a blank macro with a default name. Each macro consists of an ordered list of action steps.
Action Categories¶
Actions are grouped into categories:
| Category | Actions |
|---|---|
| Navigation & UI | OpenForm, OpenSheet, OpenQuery, OpenReport, ShowMessage, CloseDialog |
| Data Operations | SetCellValue, GoToCell, RunQuery, ApplyFilter, RemoveFilters, SortSheet |
| Import / Export | ExportCSV, PrintSheet, SaveDocument |
| Control Flow | If, Loop, SetVariable, Wait |
| Formatting | SetFormat |
Each action has its own set of parameters. For example, SetCellValue requires a cell reference and a value, while ShowMessage accepts a title, message, and icon type.
Building a Macro¶
In the macro editor, click Add Action and choose an action type. Configure its parameters in the inline form. Reorder steps by dragging them up or down in the action list.
Triggers¶
Each macro can be assigned a trigger that determines when it runs:
| Trigger | Description |
|---|---|
| Manual | Run on demand from the macro list. |
| On Sheet Open | Runs automatically when the workbook loads. |
| On Form Submit | Runs when a linked form is submitted. |
| On Cell Change | Runs when a specific cell value changes. |
| Timer (interval) | Runs repeatedly at a set interval in milliseconds. |
Running a Macro¶
Select a macro in the list and click Run, or use its assigned trigger. Macros execute their action steps sequentially. Control-flow actions like If and Loop allow conditional and repeated execution of subsequent steps.
Editing and Deleting¶
Use the macro list to rename, duplicate, or delete macros. Click a macro name to open its editor and modify its action steps or trigger settings.