You can create database queries to pull data from any web application or data map under your SpreadsheetWEB account. The resulting data from these queries can be bound to named ranges from your workbook to be used in runtime calculations.

The dimensions of the outcome of a query will be the determining factor in choosing what type of a named range can be tied to it. The system always assumes that a query will return multiple rows of data. As a result, you can’t bind those results to a single named range. In this case, the only options you will get in the bound to named range field is going to be table named ranges. To enforce single cell output and bind a query to a single named range, you must select a single column to work with, and also pick 1 for the Select Top X Rows option for the query results. This way, the system will ignore any subsequent values and use that single result in the calculations.

When using table named ranges, make sure that your named range consists of at least as many columns and rows as the resulting query, or the excess rows and columns will be cut off from the results displayed in the UI.