1 Reply Latest reply: Jun 26, 2017 3:15 PM by Felip Drechsler RSS

    Section Access using multiple fields

    David Pardoe

      I would like to set up section access on an app using different fields for different users. I have REGION field and an OFFICE field. Some users would be restricted to an OFFICE and others to a REGION. NB. there is a 1-M link beween regions and offices.

       

      I have set up section access using just one field with the following:

       

      Section Access;

      LOAD * INLINE [

      ACCESS,USERID,OFFICE

      ADMIN,EMEA\test,

      USER,EMEA\test_restricted,Cambridge

      ];

      Section Application;

       

      I thought the following might work but no luck. I have read on the forum a way of concatenating the fields used for section access but that seems like  a more complicated way of introduced quite sophisticated access restrictions. I don't need the extra complications and was hoping for an easier way?

       

      Section Access;

      LOAD * INLINE [

      ACCESS,USERID,OFFICE, REGION

      ADMIN,EMEA\test,,

      USER,EMEA\test_restricted1,Cambridge,

      USER,EMEA\test_restricted2,,NorthWest

      ];

      Section Application;

        • Re: Section Access using multiple fields
          Felip Drechsler

          Hi David,

           

          I've made an example for two fields, but you could put more on your app.

          The first inline load would give me the section access I require (that could also be loaded from an Excel file for example) and then manipulate the section access with left join to make the full login for all users.

           

          Just the admin is left with visibility for all fields. To enter with the admin login,

          User: admin

          Pass: admin

           

          Felipe.