The External Data Source, Table, and List Box controls allow data to be brought into a Scripting Workflow at runtime from an internal or external source, and optionally mapped to Workflow fields or variables. The process of configuring these is managed through the Datasource Wizard.
Before configuring a control offering the Datasource Wizard, ensure all the required fields to map data to/from (if required) are added to the Workflow page.
The Wizard is reached through the Advanced Options tab of the control, by clicking the Begin Configuration button at the centre of the window:
Datasource Types
While the process may differ slightly between the controls, the general process can be split by the data source type used:
Databaseallows data to be sourced from an existing database, for example an external SQL database or Scripting's database.
Field or Variable allows entries to be imported from JSON data stored within Scripting.
Web Service allows entries to be imported from a web resource.
Static List allows entries to be manually specified as label-value pairings. This type is only available for List Box controls.
Update Links
A powerful bit of functionality that is configured in the Datasource Wizard is the ability to specify Update Links. This means that when the External Data Source has completed its query, or the Table or List Box controls alters their row selection, it will then trigger another Field on the page. This can be used to trigger another control such as a Button or JavaScript - Button when the required values have been returned and mapped out to Fields, or the a selection has been made in a Table or List Box control.
One of the most common uses for Update Links is to link Tables or dynamic List Boxes together, so that the option selected in one control is then used as the filter for a subsequent control, and so forth.
