Help center
Sign inTry for free

Build applications

Queries

Using the Queries module, you can create database queries to retrieve data from any web applications or data maps under your account.

Start course
Lessons
6
Level
Intermediate
Format
Self-paced
Course contents6 lessons
Course overview
  1. 01Queries Basics
  2. 02Displaying the Results of Queries
  3. 03Binding Query Results to Named Ranges
  4. 04Using Query Results in Calculations
  5. 05Decoupling Data from a Spreadsheet Using Queries
  6. 06Query Triggers

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 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 curriculum

What you’ll learn

  1. 01
    Queries BasicsIn the Queries module you can create database queries to retrieve data from applications and data maps. Queries are created using an intuitive user…
  2. 02
    Displaying the Results of QueriesBind SpreadsheetWeb query results to table or single-cell named ranges, match result dimensions, and use Select Top 1 for scalar outputs.
  3. 03
    Binding Query Results to Named RangesYou can create database queries to pull data from any web application or data map under your SpreadsheetWEB account. The resulting data from these queries…
  4. 04
    Using Query Results in CalculationsWe can split queries into two groups in terms of how they are evaluated in calculations, static queries and dynamic queries. The main difference between the…
  5. 05
    Decoupling Data from a Spreadsheet Using QueriesMove large lookup tables out of Excel, import them as SpreadsheetWeb data maps, query by input values, and bind the result back into calculations.
  6. 06
    Query TriggersBy default, queries will run when a calculate event occurs, either automatically or with the press of an action button. You might want to change this…