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!