Is there any Learning material on getting values based on query of 1 or more headers of a row ? example I want to know airfares from x to y expiring by December 31st for an adult aged 25+?

Do a google search on “Google sheets query()” and “Google sheets filter()” Here is a good one on query: https://www.benlcollins.com/spreadsheets/google-sheets-query-sql/ Here is one on filter: https://sheetshelp.com/filter/filter

Thank you for your tip. However I would like to perform the query in the app which a user would pick more than 1 header column and give many related results Example: air fares from Vancouver to Shanghai economy class would give me airlines and the fares

@Clyde_Sequeira check out @Jeff_Hager 's post: [image] User-defined filter? I set up an example under “Dynamic List Filter” in https://concepts.glideapp.io/

If you still want to use query, you would need to have a sheet with a row for each user. In there would be columns that would be filled in the app by the user for their filters. Then in a new sheet you would use the query along with other google functions to dynamically build a list in a sheet tha…

Just saw @Jeff_Hager ’s concepts app. So much for my dream of becoming an expert with my comparative pea-brain. I bow to thee o wise one.

@Les_Henderson Hehe, thanks for the kind words. :rofl:

@Clyde_Sequeira So you want a query to be triggered in your SQL database when a row(s) is changed in a Sheet? Try this add-on from SeekWell. You can basically “inject” values from a table in Sheets into an SQL query, and trigger that query to run whenever a cell is changed in the Sheets table. You c…

Looking for query builders

Ask for Help

George_B November 3, 2019, 5:54pm 4

@Clyde_Sequeira check out @Jeff_Hager 's post:

Topic		Replies	Views
Tutorial - QUERY: "The most powerful function" in Google Sheets (part 1) Ask for Help	20	4280	June 21, 2020
App-wide user filter Ask for Help	10	419	June 3, 2023
Query user data on reviews form based on product sheet Ask for Help	24	1365	July 5, 2020
Can I show the same spreadsheet tab as multiple tabs in my app, but sorted, filtered or displayed differently? Ask for Help	32	4591	January 12, 2024
Creating Interactive Dashboard for Users Ask for Help	18	1870	August 17, 2020

Looking for query builders

Related topics