AX1305

Refresh variables

Refresh variables can be used to prompt the user to specify certain values before refreshing the file. You can configure the file so that these values impact the data refresh in some way, such as to filter the data coming into an Axiom query.

The refresh variables feature is an important feature for both file designers and end users. Refresh variables provide an easy-to-use and standardized way to allow users to filter the data coming into a file.

Refresh variables are defined on a sheet in the file, using a RefreshVariables data source. Each row in the data source defines a variable representing a value that you want the user to input or select. Several different variable types are available to handle different kinds of values, from free-input text or numbers, to selecting values from defined lists or designated table columns.

Refresh variables can be used in two different environments:

• In standard Axiom files where users are viewing the file as a spreadsheet in the Desktop Client (Excel Client or Windows Client). The refresh variables can be triggered to display when the file is initially opened, and/or when the user manually refreshes the file.

• In form-enabled files where users are viewing the file as an Axiom form. The refresh variables display when the user clicks the Filters button in the Web Client Task Bar. If the Axiom form is open within the Desktop Client, then the refresh variables are available in the Filters task pane.