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

expressions
(Account Team) #1

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?

(Levent KULAÇOĞLU) #2

@Account_Team

=SWITCH( USEREMAIL(), "aa@bb.com",“ViewName1”, "cc@dd.com",“ViewName2”, “DefaultViewName” )

(Account Team) #3

Thank so much

(Bellave Jayaram) #4

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,…)

(Aleksi Alkio) #5

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