Functions & Variables

Use dynamic variables to make your SQL queries and templates reusable and intelligent.

Table Variable

Why use it? To write one query that works across multiple databases or uploads without rewriting the table name.

How to use: Insert {{table}} in your SQL `FROM` clause. LiveDB automatically replaces it with the table name of the currently selected database.

SELECT * FROM {{table}} LIMIT 10

$$Header_Name$$

Header Variable

Why use it? To reference dynamic column values inside Spreadsheet Formulas (e.g., passing a URL from your SQL result into an Image function).

How to use: Wrap the exact column header from your SQL output in double dollar signs.

=IMAGE("$$image_url$$")

$$capture_from_sheet$$

Capture Data from Sheet

Why use it? To dynamically inject values from your active Glide Sheet directly into your SQL query. This enables "ultra fast" two-way synchronization where the app fetches data cell-by-cell based on your sheet selection.

Before (Hardcoded)

SELECT * FROM "{{table}}"
WHERE styleid IN
('11201462', '11201580')

After (Dynamic)

SELECT * FROM "{{table}}"
WHERE styleid IN
($$capture_from_sheet$$)

When this variable is used, the app automatically fills data from the visible Glide Sheet UI.