2 Replies Latest reply: Jan 23, 2014 12:24 PM by Ajay Krishnan Prabhakaran RSS

    Section Access

      Is it possible to assign two values to the same user. I have a field with values [ value1, value2, value3.... value 10]

      I want user1 to access value2,value3,value5 and user2 to have access to value2, value6 and user3 to have access to value1 etc. IS this possible??

        • Re: Section Access
          Carlos Reyes

          Yes, you have to create a record for each combination of user and value in the Section Access table. Something like the next:

           

          [Section Access]:

          LOAD * INLINE [

          ACCESS, NTNAME, FIELD1

          USER, USER1, VALUE2

          USER, USER1, VALUE3

          USER, USER1, VALUE5

          USER, USER2, VALUE2

          USER, USER2, VALUE6

          USER, USER3, VALUE1

          ];

          • Re: Section Access

            Hey Anitha,

            If the table in your Data Model already has the relationship you mentioned built in then its possible. For example if the table looks like this:

            UserField

            User1

            value2
            User1value3
            User1value5
            User2value2
            User2value6
            User3value1

             

            So it all depends on how that values are related in your Data Model tables.

            Hope it helps

            Thanks

            AJ