I currently have an app set-up that is a basic 2-view app for individuals in my company to look up different job sites based on a list view and a map view. What I would like to do is create a table that is the first view with a list of different cities our company has projects in. Then when someone clicks on a city in that table, I would want it to be basically how the app is set-up right now with both a list view and a map view, but just for job sites in that city. I wasn't sure if anyone had any ideas on how to do that. My thought was maybe putting each city's job sites in its' own tab in the Google sheet and maybe a "menu" page in the Google sheet that linked to each tab, but that didn't seem to work.
User | Count |
---|---|
43 | |
27 | |
23 | |
16 | |
12 |