Separate section access data

[Anonymous]

Hi

I have bellow section access:

I have 3 different users

User1: can see the hospital names a1..a5

User2: can see the hospital names b1..b5

And admin that can see all the hospital names

I want to normalize  my section access that no need to repeat user1 or user 2, in fact user 1 just use one row.

How can i make excel file?

I would appreciate if anyone could help me

[marcus_sommer]

Maybe you could group your hospitals in an extra field "hospital group" with the values of a (includes a1..a5) and b (includes b1..b5).

- Marcus

[Gysbert_Wassenaar]

Create tables in Section Application like

SECTION Application;

UserHospitalAccess:

LOAD * INLINE [

USERNAME, hospital name

user1, a1

user1, a2

...etc

user1, a5

user2, b1

user2, b2

...etc

];

UserSheetAccess:

LOAD * INLINE [

USERNAME, sheet1, sheet2, sheet3

user1, 1,1,1

user2, 1,1,1

user3, 1,1,1

];

Make sure that all the fields in the Section Access table are in UPPERCASE. So USERNAME instead of Username. USERNAME also has to be in uppercase in the other tables otherwise you can't use these tables to reduce the data in the document for the users.

[stabben23 · Accepted solution]

Hi,

you can add the all togheter in one row With ex ';' separated, then use subfield in Your LOAD script.

ACCESS	Username	Userkey	Hospitalname
ADMIN	admin	*	*
USER	User1	a1;a2;a3;a4;a5	a1;a2;a3;a4;a5

LOAD

upper(subfield(Userkey,';')) as Userkey

[Anonymous]

Hi thanks for replying

can you give me an example of excel and coding section?

[Anonymous]

Hi thanks for replying