Section Access using multiple fields

Mon, 26 Jun 2017 12:59:12 GMT

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

felipedl — Mon, 26 Jun 2017 19:15:20 GMT

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.

topic Re: Section Access using multiple fields in App Development

Section Access using multiple fields

Re: Section Access using multiple fields