Sorry, in the starting view I want the to dis...

Account_Team
Participant II

Sorry, in the starting view I want the to display different view for different users. Could you help me with the expression.? What or how should I write?

0 4 392
4 REPLIES 4

@Account_Team

=SWITCH( USEREMAIL(), "aa@bb.com",โ€œViewName1โ€, "cc@dd.com",โ€œViewName2โ€, โ€œDefaultViewNameโ€ )

Account_Team
Participant II

Thank so much

If you have a lot of different users, it is best to classify them by role (Table with 2 columns, Email and Role) and then use a formula to change the view. Something like IFS(Lookup(USEREMAIL(),RoleTable,Email, Role)=โ€œRole1โ€,View1,โ€ฆ)

If you use the view name directly in this โ€œuser tableโ€, you could read it like LOOKUP(USEREMAIL(),Table,Email,ViewName).

Top Labels in this Space