Problem with Complex Section access implementation . Help Needed !!

[shekhar_analyti]

Hi All ,

Attached is sample qvw and data .

Here is my requirement .

1) Each Store has its manager and manager's employee ID .

   So if a manager of particular country logins into application then he/she should have access of "Store Manager" sheet with his data        only

2) Country head should have access to All the sheet but data of only its county and all the stores under his country .

3) Sales Manager should have access to Sales sheet

4) Hr Manager should have access to HR sheet only

Note : USERID is Mnager Name and Password is employee ID of manager .

I tried but It did not work properly with below code

[oscar_ortiz]

You should have a look at this post Basics for complex authorization from hic‌.

Good luck

Oscar

[shekhar_analyti]

stalwar1‌

Need your help Bhai !!

[jmvilaplanap]

Hi,

I think that the easiest way is hide the tabrow for all users and design a menu with buttons that will be hide or not depending the section access.

For example you can create a table with user groups and then with the function "Only" create a condition to show each button.

Regards

[shekhar_analyti]

antoniotiman‌

[antoniotiman]

Hi,

You change in script

from Store To STORE

and From Country To COUNTRY.

And I also suggest You to add ADMIN User.

See Attachment (partially changed).

Regards,

Antonio

[antoniotiman]

And in Document Property -> Open

[antoniotiman]

It is a bit complex, as You haven't Upper Values in the Field STORE e COUNTRY.

See Attachment.

[shekhar_analyti]

Hi Antonio ,

It seems that something not working correctly . Please find detailed screenshot .

Thanks & Regards

Shekar

[antoniotiman]

HI,

Ypu wrote

Upper(Pick(Match(Left(Store,2),'De','GB','In','Ru'),'German','United Kingdom','India','Russia')) as COUNTRY

and STORE for Keriv Bojo is *

Can I get Emp_ID ?