I have a dashboard I donโt want to display unless the USEREMAIL role is โAdministratorโ but once the user cancels out of the starting view screen, the screen reverts to the Dashboard even though the user is not specified as an Administrator in the Users table. Iโm using the following expression:
LOOKUP(USEREMAIL(),โUsersโ,โEmailโ,โRoleโ)=โAdministratorโ
Three things:
LOOKUP(USEREMAIL(),โUsersโ,โEmailโ,โRoleโ)=โAdministratorโ
should instead be โAdministratorโ=LOOKUP(USEREMAIL(),โUsersโ,โEmailโ,โRoleโ)
to ensure it evaluates as FALSE in the event the LOOKUP() returns a blank value.
A viewโs Show if only affects its display in the main menu and along the navigation bar at the bottom of the screen. It does not hide a view that has been presented to the user.
The appโs starting view should not be a form view specifically because the user can cancel out of it and thereโs no way to reliably or safely control the view at which the user lands after cancelling.
Got it. Unfortunately, client has requested only the form to be accessed by their sales reps.
Hi Steven, Iโve setup another detail view vs. a form view as you mentioned above to display for users who are not Administrators but the screen still defaults to the Administratorโs Dashboard on the starting view - this is the starting view expression: Is there a better way to do this altogether?
Have you tested the expression with different email addresses to confirm youโre getting the results you expect?
Yes
If users whose [Role]
is not Administrator are landing at the dash_administrator view, Iโd say thereโs a bug somewhere. Probably best to contact support@appsheet.com directly.
User | Count |
---|---|
32 | |
25 | |
23 | |
22 | |
15 |