Hide some records depending on username

[flyf]

We keep inventory for a bunch of different labs. Some of what they are working on needs to be hidden from the general public. I created a checkbox field named hide that I wanted to write a script so that when the generic username is signed on, will not be able to see those records that are checked yes in hide. I wrote a script that does the omit but my problem is what if they show all records or do a new find, then they will see those records again. Is there a way to hide checked records based on username only? Thanks.

[mr_vodka]

Do an advanced search for +Record +Level +Access

You will come across examples. Basically, you can use a confidential flag to have the users with access see the records using priv set settings.

[JesseSFR]

There are a couple ways to do this. The first of which is the most secure:

1. Create a new privilege set in accounts and privileges and assign it to your generic user.

2. Edit the Records Permissions for the table in question so that they can only be viewed if the checkbox is not checked.

Another way to do this would be to create a customer menu for your application and override the show all records. It would basically run show all records and then constrain to just the items no marked hide.

You would also need an on mode enter script trigger which fires when entering browse mode. This would do the same exact constrain as the show all command. This would have to be placed on the layout that is being used to view the records in question. This basically fixes your find mode problem.

[flyf]

Great. I tried it out and it works to enter a calculation in the privilege field. Now the records are hidden but it comes up saying no access in all the fields for the hidden records. Is there any way to hide those so they don't show up? I also tried the on mode enter script trigger but I don't know how to only make it for 1 user instead of all users or what kind of script to enter since it is associated with a specific script. Sorry, this would be my first time using a script trigger. I appreciate all the suggestions from everyone.