Jump to content

Priviledge set - limit access to certain records.


Ivan Tan

This topic is 7084 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Dear All,

I am using 2 fields to limit access to some records.

Dept and School

However i tried to use the limit records feature and specify

Dept="science" , this works

Dept = "Science" and School ="Snr" This doesn't work

Wonder why the calculation field does not allow 2 fields??

or maybe i am just stupid. Thanks !

Link to comment
Share on other sites

I just made a simple file to check this. Records that do not match the AND conditions show "No Access". The record that matches shows the data.

I have set the privilege set to Records Custom, Layouts View only, Value Lists View only and Scripts All executable only. In Records View is Limited by the calculation, Edit is No, Create is No, Delete is No and Field access is All.

Link to comment
Share on other sites

i think i know why, it is relationship problem because the field did not exist on the layout because it is a different database.

I use it as a database to control the Portal records, kinda like a show / hide records database as portal works by occurances something.

It's my error. Problem solved.

Thank you everyone!

Link to comment
Share on other sites

This topic is 7084 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.