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?
=SWITCH( USEREMAIL(), "aa@bb.com",“ViewName1”, "cc@dd.com",“ViewName2”, “DefaultViewName” )
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).
User | Count |
---|---|
43 | |
30 | |
24 | |
23 | |
13 |