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 |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |