Getting Started

Hello WorldYour first action script — from a one-line alert to a small form that answers back.

Core Concepts

Modal Restart GuideUse sp_api_modal_restart to redraw a dialog, move a wizard to its next step, or hand over to another action.App Settings ConfigurationKeep configuration out of your code — the api_settings table and the two procedures that read and write it.Parameter Passing Between ActionsFour ways to get a value from one place to the next — within a dialog, across a restart, into another action, and across sessions.

Example Applications

Pizza Time AppA complete order form in one action script — a picker, a choice of sizes, a switch, validation and a summary.Multi-Step Pizza OrderingThe pizza order as a three-step wizard, with Back buttons and state carried from step to step.Car Management AppFrom an empty database to a working app — two tables, two cards and three buttons, all in T-SQL.Number GameA guess-the-number game that shows how to keep a value hidden from the browser between runs.Email Sending ExampleSend email from an action script with sp_api_email — plain text, HTML, copies and attachments.

Data Visualization

Creating ChartsTurn a query into a bar, line or pie chart with sp_api_modal_chart — and make the chart clickable.Sales Dashboard ExampleKey figures, a chart and a grouped, totalled table in one dialog — with a period filter that redraws everything.Table Schema ViewerA global action that shows the columns of whatever card you are on — a small tool that uses context variables and SQL Server's own metadata.