Starting View

Hello,

I have two views “My Jobs” and “Loads”. How can I do for the app to start with “My Jobs” if the user is a driver and “Loads” if the user is a supervisor.

Thanks in advance for your help!

If you check under UX>Options you find a setting for just that thing
CloudApp

1 Like

Hi @MultiTech_Visions thanks for your response. I’m aware of this setting but I can not find the right expression to make it work. :confounded:

1 Like

I assume you’ve got a Users table, and in that table you’ve got two things:

  1. a column holding the email that the user will use to log in; and
  2. a column holding the role of the user.

If these conditions are true, then there’s two good ways to handle this:

  1. LOOKUP(USEREMAIL(), Users, User_Email, User_Role); or
  2. Create a slice on the users table, with a condition that matches the USEREMAIL() = [User_Email], call it Current_User - from here you can always easily call any information from the current user’s record: any(Current_User[Any_Column])

Either way you can now call data from the specific user’s record and make determinations with it.

Switch(any(current_user[User_Role]),
  "Driver", "My Jobs", 
  "Supervisor", "Loads", 
  "Some fallback/default view"
)

or

If(
  any(current_user[User_Role]) = "Driver", "My Jobs", 
If(
  any(current_user[User_Role]) = "Supervisor", "Loads", 
"Some fallback/default view"
))

or

IFS(
  any(current_user[User_Role]) = "Driver", "My Jobs", 
      any(current_user[User_Role]) = "Supervisor", "Loads"
)

To use the LOOKUP() instead of the Current_User (Slice) just replace the any(current_user[User_Role]) portion of any of the formulas above

IFS(
   LOOKUP(USEREMAIL(), Users, User_Email, User_Role) = "Driver", "My Jobs", 
       LOOKUP(USEREMAIL(), Users, User_Email, User_Role) = "Supervisor", "Loads"
)
3 Likes

It worked!! thanks a lot for that. :smiley:

1 Like

You’re welcome :nerd_face:

I am working on the exact same thing here.
However I am not returning the starting screen with the view I am trying to associate.
Here are 2 expressions: (Note that User_Role is User_Team for my app)
Switch(any(current_user[User_Team]),
“Admin”, “Repair Needed”,
“Red”, “Takedown Ready: Red Team”,
“Customer Map”
)

If(
any(current_user[User_Team]) = “Admin”, “Repair Needed”,
If(
any(current_user[User_Team]) = “Red”, “Takedown Ready: Red Team”,
“Customer Map”
))

Solving my own problem here:
the “:” in the View name created an issue.
Delete the Colon form the views title fixes the issue.