# Looking for query builders **URL:** \ **Category:** Ask for Help\ **Created:** [November 3, 2019, 4:13pm UTC](https://community.glideapps.com/t/looking-for-query-builders/1639 "2019-11-03T16:13:07Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Clyde\_Sequeira](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/clyde_sequeira/32/1283_2.png) [@Clyde\_Sequeira](https://community.glideapps.com/u/Clyde_Sequeira)\ **Post date:** [November 3, 2019, 4:13pm UTC](https://community.glideapps.com/t/looking-for-query-builders/1639/1 "2019-11-03T16:13:07Z")
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+? ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [November 3, 2019, 5:17pm UTC](https://community.glideapps.com/t/looking-for-query-builders/1639/2 "2019-11-03T17:17:58Z")
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/](https://www.benlcollins.com/spreadsheets/google-sheets-query-sql/) Here is one on filter: [https://sheetshelp.com/filter/filter](https://sheetshelp.com/filter/filter) ---
**Author:** ![Clyde\_Sequeira](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/clyde_sequeira/32/1283_2.png) [@Clyde\_Sequeira](https://community.glideapps.com/u/Clyde_Sequeira)\ **Post date:** [November 3, 2019, 5:41pm UTC](https://community.glideapps.com/t/looking-for-query-builders/1639/3 "2019-11-03T17:41:24Z")
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 ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [November 3, 2019, 5:54pm UTC](https://community.glideapps.com/t/looking-for-query-builders/1639/4 "2019-11-03T17:54:25Z")
@Clyde_Sequeira check out @Jeff_Hager 's post: > [@User-defined filter?](https://community.glideapps.com/t/user-defined-filter/1605/3): > > I set up an example under “Dynamic List Filter” in [https://concepts.glideapp.io/](https://concepts.glideapp.io/) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [November 3, 2019, 6:08pm UTC](https://community.glideapps.com/t/looking-for-query-builders/1639/5 "2019-11-03T18:08:33Z")
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 that you could use the relation to access. Check out the Invoice section in [https://vkjff.glideapp.io](https://vkjff.glideapp.io) . This is an older simpler version of what I’m doing now. I needed multiple billing cycles per user, so my new version is a bit more complex with an extra intermediary sheet. ---
**Author:** ![Les\_Henderson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/les_henderson/32/1142_2.png) [@Les\_Henderson](https://community.glideapps.com/u/Les_Henderson)\ **Post date:** [November 3, 2019, 6:53pm UTC](https://community.glideapps.com/t/looking-for-query-builders/1639/6 "2019-11-03T18:53:55Z")
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. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [November 3, 2019, 7:20pm UTC](https://community.glideapps.com/t/looking-for-query-builders/1639/7 "2019-11-03T19:20:26Z")
@Les_Henderson Hehe, thanks for the kind words. 🤣 ---
**Author:** ![bkane](https://avatars.discourse-cdn.com/v4/letter/b/96bed5/32.png) [@bkane](https://community.glideapps.com/u/bkane)\ **Post date:** [November 30, 2020, 2:42pm UTC](https://community.glideapps.com/t/looking-for-query-builders/1639/8 "2020-11-30T14:42:17Z")
@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](https://intercom.help/seekwell/en/articles/1512700-getting-started-sheets-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 can also send the results of the query (e.g. airfares from x to y) back to the same Sheet instantly. Check out these [docs](https://doc.seekwell.io/1b2b6abe79694c31a4f17fb14078b607) for more info.