Please note that this feature is currently only supported in Server and Private cloud licenses.

In this course, you’ll learn how to create database queries and map their results to the underlying spreadsheet. Using Queries, you can pull data from the database of any SpreadsheetWeb application or data map through a simple drag-and-drop style interface. You can use the query results in populating any input controls like a dropdowns, display them in a chart or grid, and it use them in calculations.

 

Requirements

  • A SpreadsheetWeb account with access to the Control Panel. Currently, this feature is not supported in Trial or Public cloud accounts.
  • Your spreadsheet containing named ranges for all inputs and outputs you would like to use in the web interface of your application.
  • A web application created that has a database defined with at least one record saved under it.

 

Course Modules

This course consists of 5 modules: