This video explains an interesting way to create a Query in Google Sheets that’s very applicable to Tiller. It’s not “about” Tiller specifically but it can be used in Tiller to create a very flexible Query of your Transactions data.
Description from YouTube:
You can build a parameter table in Google Sheets that allows the user to choose criteria, columns in order and a sort order with the QUERY function. The criteria can match text, logical values, look for entries after a start date or above a number or check if it contains certain text. Plus impressively you can choose which columns you want to be returned and the order in which you want them returned, as well as which column you want things sorted by.
It takes a little one-time setup but the instructions are clear.
Thank you for sharing this. I ran the video through ChatGPT to get a summary for those who are interested.
Here is a summary of the video “QUERY builder in Google Sheets” by David Bellam:
Key Points (with timestamps)
(00:00): Demonstrates how Google Sheets can dynamically filter and display data based on user inputs (e.g., date filters, checkbox for “paid”, columns to display).
(01:42): Introduces the QUERY function in Google Sheets, highlighting it as the most powerful function available, accepting data, SQL-like query, and optional headers.
(02:53): Shows how to use SELECT, WHERE, and ORDER BY clauses within the query to filter and sort specific columns (e.g., filter by gender, sort by quantity).
(04:18): Begins building a dynamic query tool that responds to user selections—moves the query string to a cell and constructs it with formulas referencing user-defined filters.
(06:30): Explains how to concatenate query conditions using IF and & to selectively build SQL conditions based on input cells, including handling strings with quotes.
(07:54): Covers numeric comparisons (e.g., quantity > 15,000), clarifying that no quotes are needed for numbers and showing the formula for greater-than filtering.
(09:16): Provides detailed handling for date filtering, emphasizing formatting with TEXT(date, "yyyy-mm-dd") for proper SQL syntax in QUERY.
(10:49): Demonstrates filtering using TRUE/FALSE checkboxes and shows how WHERE H = TRUE can be used without quotes.
(11:39): Uses TEXTJOIN(" AND ", TRUE, ...) to combine all active filter clauses into a complete dynamic query string that updates the table.
(12:54): Finalizes the tool with column ordering, column selection using TRANSPOSE, and sorting options using ORDER BY and dynamic column selection.
This tutorial builds a customizable query builder tool in Google Sheets that allows users to:
Filter by text, numbers, dates, checkboxes
Select which columns to show
Sort results
Easily update the query by changing cell inputs—ideal for dashboards and reporting.
Pretty much, I subscribe to a service that is a plugin for YouTube and if I am looking at the video I can click the chatGPT option (they let you pick your LLM, but I have a ChatGPT subscription)
Key Points (with timestamps)