Jump to content
Sign in to follow this  
Ivan Tan

Priviledge set - limit access to certain records.

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 !

Share this post


Link to post
Share on other sites

What do you mean when you say it doesn't work. This should allow access only if both are true. Is this what you want?

Share this post


Link to post
Share on other sites

What doesn't work is there is not records shown at all despite the fact that

the record is from Science and Senior School.

i have tried and , & and +

only or works however is useless.

What is the syntax or expression??

Share this post


Link to post
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.

Share this post


Link to post
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!

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    Lee Smith 
×

Important Information

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