command

Smartsheet Append Scorecard Row

Appends a dated KPI snapshot row to the scorecard sheet, preserving formula columns. The one write that does NOT route through the approval bus.

CommandDirect bounded write — outside the approval busWRITE_MODE-throttled

Overview

Triggered by KPI ScorecardKPI ScorecardQueryv0.1.0Workflow #9 — the L10 cross-system scorecard: 7 KPIs (cash, AR, AP, pipeline, open SO/PO, NWC) with target/status. Optio...Ownervisionary-engineeringSchemaMapView docs with publish: true — sent by ScorecardService — KPI scorecard workflowScorecardService — KPI scorecard workflowServicev0.1.0Workflow #9 — the L10 scorecard: 7 KPIs assembled from QBO, Fishbowl and ClaritySoft, with an optional bounded publish (...Publishesaccounting-read, inventory-read +3Subscribeskpi-scorecardOwnervisionary-engineeringMapRepoView docs, not by an applier. Bounded (appends one row, never edits formulas) and throttled by the same WRITE_MODE switch as everything else, but it bypasses propose→approve→apply. The pre-showtime audit flags this as the one CQRS-purity exception to either route through the bus or explicitly except in the rule engine (ADR §5’s auto-approve list is the natural home).

Architecture diagram