FIlter Data in Google sheet

Discuss
,
#1

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

#2

then use gviz method of calling data from google sheet

Refer for more here

Credit to @TimAi2

1 Like
#3

But how to do this query in filter drop down ?

#4

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

#5

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=

#6

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.