Macros are fantastic, but they have limits (no IF/ELSE logic natively unless you write PML inside the macro).

E3D Macros are built on the Programmable Macro Language (PML), AVEVA’s proprietary coding language. Unlike standard scripting languages, PML is deeply integrated into the E3D database architecture.