Another USERSETTINGS + Security Filter Question...

[Ryan_Wagner]

Alright, I have read several posts on this but I can't seem to wrap my head around it...

I have a massive dataset that I had previously broken up into multiple apps. I wanted to try keeping it all in one Google Sheet and allowing users to select what area (city) they will need to see and edit.

I am mixed up somewhere between slices, user settings, and security filters. 

I added a "city" enumlist in the user settings, and then added the security filter:

I then made slices for each city like this:

Finally, I made map views for each city that are visible if that city is selected:

Is this approach redundant? Is there a better way? It seems like I would need to make a massive list of UX views to cover every possible combination of cities. I must be missing something obvious...

[SkrOYC]

Hi @Ryan_Wagner 

I think a little example of your data and what you need in the end would help more than what you have done, although it's good to see you pushing to solve it.

---

@Ryan_Wagner wrote:

I added a "city" enumlist in the user settings, and then added the security filter:

---

This is basically telling the system, "Ignore any row of this table if the value inside the user setting for "City" is not inside a list of values on the [City] column. If [City] is not a list, you should consider other type of expression here.

---

@Ryan_Wagner wrote:

I then made slices for each city like this:

---

This is a little bit weird, and I'm a little lost. You shouldn't need so much slices or hard-coding

---

@Ryan_Wagner wrote:

Finally, I made map views for each city that are visible if that city is selected:

---

Same as before

[Ryan_Wagner]

Hi @SkrOYC ,

I had hoped that was enough info, but here is what my table looks like:

It is a large dataset that has many cities (in the "Tags" column, which is an enumlist.) I now have multiple sheets and multiple similar apps to manage it all. I want to try using only one sheet (and one app) and allow the user to select which city to see/load when they start the app. 

I have only used "usersettings" to allow users to pick what actions should be available. I haven't done much with security filters before, so I wanted to try that, but that is where I got lost...I wasn't sure if slices and individual views came into play at that point.

Can I provide any other info?

Thanks for taking a look.

[SkrOYC · Accepted solution]

---

@Ryan_Wagner wrote:

I wasn't sure if slices and individual views came into play at that point.

---

If they can select which city the app is going to use, they don't need slices at all.
Security filters remove any other data that doesn't apply the filter and that data is downloaded to the device running the app, so slices just work on top of that already filtered data

[Ryan_Wagner]

That's what I was hoping, but I can't seem to set that up...I have a map view based on the whole table, and the security filter on the table is what I mentioned earlier:

After selecting a city in the settings, the filter doesn't do anything.

I hope I'm explaining it correctly. 

I appreciate you taking the time to help.

[Ryan_Wagner]

Wow...I am an idiot...I wasn't using the right column name. It is working now. Apologies for dragging this on. Thanks again, @SkrOYC !