App views only displaying based on a selected input

[aglass]

Hello everyone,

I need our app users to first select a company location, and depending on the location selected the the tables relating to that location would display in the Main Nav.

For example I have 3 locations, and two sets of tables for each of the 3 locations. When one location is selected, I only want the two tables relating to that location showing in the App nav bar.

I’ve also included an image of the app nav as is along with the google sheet I’m working off to better provide an idea how it is currently set up (which may not at all be correct).

Thanks!

[Steve]

You’ll need to capture the user’s store choice and save it. Then you can reference the saved value in the Show if expression of your view configuration to only display the view of the selected store. Alternatively, you could create a slice that only includes the selected store, then have a single view that references the slice.

To capture the user’s store choice, the easiest method is to use User Settings:

help.appsheet.com

User Settings: The Essentials

Give users more control to customize app behavior.

[aglass]

Thanks for the tip! does either method you suggested put less of a strain on the app to provide a smoother user experience?

Also after the user selects a store choice, he/she can change that choice to view another store if need be, correct?

[Steve]

aglass:

does either method you suggested put less of a strain on the app to provide a smoother user experience?

I don’t understand.

aglass:

Also after the user selects a store choice, he/she can change that choice to view another store if need be, correct?

Technically, that’s up to you and the design you choose, but there’s no technical reason to deny the user the ability to change their choice.

[aglass]

My first question was just related to best practices. I wanted to know if one method is considered better than the other or offers any significant advantages

As for the user selecting a different store, that’s what I was hoping!

I’m having difficulty setting up the expression however. I’ve set the option in user setting however the expression is returning an error. See image below

Also After I enabled that store user setting to be viewed, I could not locate it anywhere in the app.

[Steve]

aglass:

My first question was just related to best practices. I wanted to know if one method is considered better than the other or offers any significant advantages

Ah, right! User Settings is the easiest to setup, but the least flexible, and likely to be a less-friendly user experience. It might be a good way to get something working quickly, then you could move to a better approach later.

Instead:

USERSETTING("Store") = "Maplewood"

Note quotes rather than brackets.

aglass:

Also After I enabled that store user setting to be viewed, I could not locate it anywhere in the app.

It’s in the app’s main menu:

[aglass]

I tried adjusting the expression, but now I’m receiving a different error.

Thanks for pointing me in the right direction for where to locate the user settings within the app! Is there a way to add this specific user setting as a primary view? Ultimately I’d like for that to be the only icon upon opening up the app.

[Steve]

Opps! This:

is because I overlooked this:

Your expression should instead be:

IN("Maplewod", USERSETTINGS("Store"))

I would question, though, why Store is of type EnumList rather than just Enum. Do you intend for the user to choose multiple stores simultaneously?

See also:

help.appsheet.com

IN()

Is item in list?

help.appsheet.com

USERSETTINGS()

Specified user setting value

[aglass]

I changed the type to Enum (you are correct that I’d only want to select one). I also changed “Store” to “Location” within the user settings to match it with our company vocabulary. I tried the expression you gave and it appeared to work at first. However when I saved it and went back into to the app and tried selecting one of our three locations, this error occurred.

Then Is there a way to add this specific user setting as a primary view? Ultimately I’d like for the location selection to be the only icon upon opening up the app

[LeventK · Accepted solution]

@aglass
Try with this:

IN(“Maplewod”, LIST(USERSETTINGS(“Store”)))

[aglass]

Thanks Levent,

It looks like your formula worked with the Enum setting. However the App preview screen is blank for some reason so I can’t tell if the desired effect has been achieved???

App preview|690x434

[aglass]

I restarted my computer and the app preview has come back. Moreover the formula you provided is exactly works perfectly!

[aglass]

Now Is there a way to add this specific user setting as a primary view? Ultimately I’d like for the location selection to be the only icon upon opening up the app. And I’d like for it to always be accessible from the primary view

[LeventK]

Yes it’s possible for sure.

[aglass]

How can I set the app up so that the user setting is located in the primary view?

[Steve]

The expression I provided was appropriate for a column of type EnumList, not for a column of type Enum. With an Enum column, your original express was correct:

("Maplewod" = USERSETTINGS("Location"))

aglass:

Then Is there a way to add this specific user setting as a primary view? Ultimately I’d like for the location selection to be the only icon upon opening up the app

One problem at a time.