Jump to content

Probably Simple...but


Gosheff

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

Recommended Posts

  • Newbies

I'd like to restrict a user to only see records that have a certain field value.

So if a user named 'jones' logs in, he would only see records where the field 'owner' has a value of 'jones'.

Seems awfully simple, but I can't quite pull it off. Could someone help me out here? Thanks!

Link to comment
Share on other sites

You can set up a limited privilege set under accounts and passwords. Select custom privileges for records and then for the various fields that you want to limit access to, select the limited option under the various menus, and enter a formula like this:

CreatedBy=Get ( AccountName )

where CreatedBy is a field with the autoenter option set to enter the User Account name.

Link to comment
Share on other sites

  • Newbies

Thanks for the reply!

I got this to partially work. I now have limited access to certain records to edit, but other records partially show with <> displayed. Anyway to have these omitted from displaying? Thanks again!

Edited by Guest
Link to comment
Share on other sites

Do a find for just the respective user's records. The ones will then disappear. Also, when doing a find on any data field, if Record Level Access is in effect, any records the user is not allowed to see that otherwise would have been included in the Find result will not be displayed.

Steven

Link to comment
Share on other sites

This topic is 6447 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.