Filter starting view

AppSheet AppSheet Q&A
1

I have 2 dashboard, one for employees and another for managers. I am having trouble with the formula for the starting view.

Dashboard for managers is named Dashboard

Dashboard for employees is named Dashboard employee

I have a user table name “Users” that has username(useremail()) and a yes/no for employee. I would like to have any user with the employee tag as true to open “Dashboard employee” and anyone marked as manager to open “Dashboard” I have tried some or and if expressions but I am not sure what I should use. I tried this but I am not sure where to specifiy which dashboard they should get

LOOKUP(USEREMAIL(),“users”, “email”, “Manager”),

LOOKUP(USEREMAIL(),“users”, “email”, “Employee”)

Thank you in advance.

1 Like
2

The starting view only applies the very first time the user ever uses the app on a device; it does not take effect each time the app is opened. Do you understand that?

3

I did not, is there a way to do what I am looking for?

4

I figured it out, I made all the dashboard on the menu and then I did a show/hide based on another field I added. It worked. Thank you so much for your prompt response.

1 Like
5

Perfect! Well done!