Custom Formulas
Apply spreadsheet logic to your SQL results automatically.
How it Works
You can inject spreadsheet formulas (like =IMAGE(), =VLOOKUP()) directly into your SQL query results. This is powerful for generating reports that are ready for Google Sheets or Excel.
- Create a Formula template in the LiveDB editor.
- Use
$$header_name$$to reference column values dynamically from your SQL result. - Select formulas in the "Fetch Data" toolbar.
- Click Apply to generate the new columns.
Example: Image Display
=IMAGE("$$Product_Image_URL$$")
If your data has a column named "Product_Image_URL", this formula will create a renderable image cell when exported to Google Sheets.