# \[Solved\] Spreadsheet query

**URL:** <https://community.thunkable.com/t/solved-spreadsheet-query/286894>\
**Category:** Questions about Thunkable X\
**Tags:** solved\
**Created:** [October 24, 2019, 2:08pm UTC](https://community.thunkable.com/t/solved-spreadsheet-query/286894 "2019-10-24T14:08:49Z")\
**Posts on this page:** 1\
**Showing post:** 10

<div class="post-metadata">

**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\
**Post date:** [April 10, 2020, 7:58pm UTC](https://community.thunkable.com/t/solved-spreadsheet-query/286894/10 "2020-04-10T19:58:16Z")

</div>

Hi @Michael_Rogulla,

I accomplished this task today using the Airtable API.

using the URL located in teh CURL,

 ![Screen Shot 2020-04-10 at 3.43.45 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/9/b9afd2bedf0433fee7516347af38aadb2a76fb83.png) ![Screen Shot 2020-04-10 at 3.43.41 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/8/c807dba472de28f1170f64e5c402f676a3f492fa.png)

i add those into the property designer

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/a/ba8d944ade9258033ae620c3e9bb1b28416b8d10.jpeg)

i use the URL up the question mark  
I add a parameter of filterByFormula and use the quickchart formula to filter by an email

then for the header put Authorization as the property and the value is “Bearer YOURKEYHERE”

i checked the response with this  
 ![Screen Shot 2020-04-10 at 3.43.07 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/0/503ae1c1d4d730a909d6c958eb936581f03d9928.png)

i will be addin gthis feature into my app. let airtable do the fitltering. save performance on the app/phone

the next step is to add that parameter in dynamically using the text join block and in my case the userID blcok. I also want to add a second filteryBy parameter like name = ‘email’ & cell2 = ‘SomethingElse’

---

_[View the full topic](https://community.thunkable.com/t/solved-spreadsheet-query/286894)._
