# \[Solved\] Filter / Sorting data on thunkable **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** database, dynamic-filter, sort\ **Created:** [September 28, 2020, 5:51am UTC](https://community.thunkable.com/t/solved-filter-sorting-data-on-thunkable/854742 "2020-09-28T05:51:13Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![ridmaabeysundaratc1](https://avatars.discourse-cdn.com/v4/letter/r/35a633/32.png) [@ridmaabeysundaratc1](https://community.thunkable.com/u/ridmaabeysundaratc1)\ **Post date:** [September 28, 2020, 5:51am UTC](https://community.thunkable.com/t/solved-filter-sorting-data-on-thunkable/854742/1 "2020-09-28T05:51:13Z")
Hi I have a airtable with columns PRODUCT ID, PRODUCT NAME, PRICE, NUMBER OF SALES. I import the table to data viewer on my thunkable app so it lists out the data on screen. My First question is, I need to add a button on top named “products with lower price first”. When this button is pressed i need data viewer to change in such a way so that items arrange from lowest price to highest product price in the screen. What is the best way for me to do it. My second question is, I need to add filter option. Ex : list only products with a price in between $20 - $50 Ex : list only products with a price in between $20 - $50 which have sales more than 1000 So when these filters are added i need the app to obtain data from the airtable, then extract relevant data match my filter, and dispaly it in data viewer. Please help me with my problem. Thank you! ---
**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\ **Post date:** [September 28, 2020, 8:11am UTC](https://community.thunkable.com/t/solved-filter-sorting-data-on-thunkable/854742/2 "2020-09-28T08:11:20Z")
See AirTable REST API ---
**Author:** ![ridmaabeysundaratc1](https://avatars.discourse-cdn.com/v4/letter/r/35a633/32.png) [@ridmaabeysundaratc1](https://community.thunkable.com/u/ridmaabeysundaratc1)\ **Post date:** [September 28, 2020, 8:32am UTC](https://community.thunkable.com/t/solved-filter-sorting-data-on-thunkable/854742/3 "2020-09-28T08:32:07Z")
Im still new can you please give me a descriptive answer. If you can kindly guide me i might be able to do this by my self. Thank you. ---
**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:** [September 28, 2020, 11:06am UTC](https://community.thunkable.com/t/solved-filter-sorting-data-on-thunkable/854742/4 "2020-09-28T11:06:46Z")
He did. If you search the forum for airtable rest api you’ll find your answer. You’ll have to use the api component and make calls to the airtable api with a custom query in the url This is the more efficient solution anyhow. Do all the filtering on the phone it will take up a lot of phone resources comparatively and be slower ---
**Author:** ![ridmaabeysundaratc1](https://avatars.discourse-cdn.com/v4/letter/r/35a633/32.png) [@ridmaabeysundaratc1](https://community.thunkable.com/u/ridmaabeysundaratc1)\ **Post date:** [September 29, 2020, 3:37pm UTC](https://community.thunkable.com/t/solved-filter-sorting-data-on-thunkable/854742/5 "2020-09-29T15:37:12Z")
![Thunkable](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/5/65f1037708afc0e6d7af73114a606c7798f4accd.jpeg) hi @actech and @jared , i took a look at scrAirTableResetApi in the [Thunkable](https://x.thunkable.com/projects/5d70f93f8a62b4079eedaff2/8466b1f9-a8ed-4c8a-8155-e5f3fb250bb8/blocks) i dont understand what these areas marked in red boxes mean. can you please explain what these are. ( What is mean by status = 200, what is mean by get property ? what string/text we should add there ) Thanks a lot ---
**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\ **Post date:** [September 29, 2020, 3:55pm UTC](https://community.thunkable.com/t/solved-filter-sorting-data-on-thunkable/854742/6 "2020-09-29T15:55:45Z")
[https://docs.thunkable.com/web-api](https://docs.thunkable.com/web-api) - doc for [get property] [https://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html](https://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html) - doc for [status] [https://docs.thunkable.com/objects](https://docs.thunkable.com/objects) - doc for work with objects ---
**Author:** ![ridmaabeysundaratc1](https://avatars.discourse-cdn.com/v4/letter/r/35a633/32.png) [@ridmaabeysundaratc1](https://community.thunkable.com/u/ridmaabeysundaratc1)\ **Post date:** [September 29, 2020, 6:23pm UTC](https://community.thunkable.com/t/solved-filter-sorting-data-on-thunkable/854742/7 "2020-09-29T18:23:02Z")
Thanks! this is helpful ! ---
**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\ **Post date:** [November 8, 2024, 12:23pm UTC](https://community.thunkable.com/t/solved-filter-sorting-data-on-thunkable/854742/8 "2024-11-08T12:23:41Z")