9 Replies Latest reply: Feb 23, 2011 12:03 PM by Łukasz Zajączkowski RSS

    Problem with making tab access user dependant

      Hi all,

      I am trying to limit the access to tabs based on user groups.

      I have set up a user access table, with the following fields:

       

      ACCESSUSERIDGROUP
      ADMINTESTADMINADMIN
      USERTESTALLMANAGEMENT
      USERTESTSALESSALES
      USERTESTDISTRIBUTIONDISTRIBUTION


      I have set up a second table where I have the following fields:

       

      GROUPSHEET1SHEET2SHEET3
      ADMIN111
      MANAGEMENT111
      SALES001
      DISTRIBUTION010


      -> Wherever the cell returns 1, the group should have access to the respective sheet.

      In the document settings under "opening" I have checked "Initial Data Reduction Based on Section Access".

      In the sheet properties - general if have included a condition:

       

      =

      if(sum([SHEET1]=1),0)

      But it does not give me the expected result. Independant of which log on I am using, I will always see the sheet.

      I have also tried to replace the condition by if([GROUP]='MANAGEMENT',0) but this one seems not to work either.

      Any ideas, what I am doing wrong?

      Thanks for your help,

      Adi