Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
LauraMorris
Contributor III
Contributor III

Different opening sheet for different users

I want to  have the app open on a different sheet for different user groups. I know I can set which sheet it opens with by using a bookmark but this is the same for all users.

Labels (1)
1 Solution

Accepted Solutions
Hania
Creator
Creator

Hii

You can create the sheet group :

here I have create inline table in section access for Different department  and assign the department to different user  and then create the sheet group  as.

Table_name:
Load * Inline [
DEPT,GroupSheet
IT,100100
FINANCE,010010
ALL,111111
SALES,001001 ];

after that you need to  set sheet condition as mid(GroupSheet,1,1)  assign it to user you want.

here mid(GroupSheet,1,1) second parameter is your sheet number

View solution in original post

2 Replies
Chanty4u
MVP
MVP

Hania
Creator
Creator

Hii

You can create the sheet group :

here I have create inline table in section access for Different department  and assign the department to different user  and then create the sheet group  as.

Table_name:
Load * Inline [
DEPT,GroupSheet
IT,100100
FINANCE,010010
ALL,111111
SALES,001001 ];

after that you need to  set sheet condition as mid(GroupSheet,1,1)  assign it to user you want.

here mid(GroupSheet,1,1) second parameter is your sheet number