Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Need your help Bhai !!
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
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
And in Document Property -> Open
It is a bit complex, as You haven't Upper Values in the Field STORE e COUNTRY.
See Attachment.
Hi Antonio ,
It seems that something not working correctly . Please find detailed screenshot .
Thanks & Regards
Shekar
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 ?