[Solved] Filter / Sorting data on thunkable

Questions about Thunkable
, ,
1

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!

2

See AirTable REST API

3 Likes
3

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.

4

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

1 Like
5

Thunkable
Thunkable814×668 94.9 KB

hi @actech and @jared ,
i took a look at scrAirTableResetApi in the Thunkable

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

6

https://docs.thunkable.com/web-api - doc for [get property]

https://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html - doc for [status]

https://docs.thunkable.com/objects - doc for work with objects

7

Thanks! this is helpful !

1 Like