AX1727

Executing commands from KPI Panels in Axiom forms

(missing or bad snippet)(missing or bad snippet)(missing or bad snippet)(missing or bad snippet)

Using the Triggering ID to impact the form

When a user clicks on a menu item to execute a command, the ID of the current KPI is written back to the Triggering ID field of the KPI Panel component. You can reference this value to impact the command being executed (using a bracketed cell reference in the command parameters), or to impact something else in the form.

The Triggering ID only applies when using a KPISource data source in an Axiom form. It is not available when using a KPI table. The ID that is written to the Triggering ID field is from the ID column of the KPISource data source. The Triggering ID field does not display in the Form Assistant or Form Designer; it is only present in the Form Control Sheet.

For example, you may have a menu item that launches a Dialog Panel component, and you want to display the name of the current KPI in the dialog panel. The dialog panel can contain a Label component that uses a formula to reference the Triggering ID field. When the user clicks on the menu item, the Triggering ID is submitted back to the source spreadsheet (along with any other changed values in the form), and then displayed in the dialog panel.

The Triggering ID is submitted back to the form whenever a menu item is used to execute a command from the Command Library, assuming that the command triggers the regular form update process (some commands do not do this). This behavior also applies if the command is defined in the Command column instead of using a KPIMenu data source. If the menu item launches a URL or a document shortcut, the Triggering ID does not apply.