FIlter Data in Google sheet

Hi, I have check lot in Search topics but not able to find any idea hence raised a query. I have a app in that data is shown from Google sheet as mention in below for example, now i want to insert a new screen in which filter dropdown should be there on City option if i select one city name in dropdown then name and number need to appear of that city… Pls suggest and share some ideas…

image

then use gviz method of calling data from google sheet

Refer for more here

Credit to @TimAi2

1 Like

But how to do this query in filter drop down ?

you will have the city names in your hand… put it in the elements…

when user selected the city make web url to run query and show the result

try this:

blocks

In your google spreadsheet link you should delete after /edit?usp=sharing

and put this part:
gviz/tq?tqx=out:csv&sheet=name_of_your_worksheet&tq=