[Solved] Filter / Sorting data on thunkable

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!

See AirTable REST API


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.

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

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

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

Thanks! this is helpful !

1 Like