Hide records of other users on login

[kathrynfw]

Looking for a way to make it so that each of my users sees only their own records when logging in. As it is now, when users add a record, all other users can see it.

Is there a way to do that?

[comment]

  On 7/8/2016 at 2:01 PM, kathrynfw said:

Is there a way to do that?

Expand  

Sure. But first you must have a way to identify the record "owner". If you haven't already done so, add a CreatedBy text field to your table and make it auto-enter Creation[Account Name]. Then adjust your users' privilege set so that they can view records in this table only when:

CreatedBy = Get ( AccountName )

Note that any find performed in the table will automatically omit records to which the current user has no access. You can also use custom menus to prevent users from calling Show All Records. Note that this is a purely cosmetic measure: even if they do, they will only get a bunch of records with << No Access>> plastered over them.

[kathrynfw]

Ok, I did that, but when I open up under other usernames, I still see the files, even though Createdby is properly attributed. Is there a script to set that? Sorry to be so dense. Finding my way with this.

 

Edited July 9, 2016 by kathrynfw

[comment]

  On 7/9/2016 at 4:41 PM, kathrynfw said:

Ok, I did that, but when I open up under other usernames, I still see the files, even though Createdby is properly attributed.

Expand  

Does this work for you?

UserRecordsOnly.fp7

[kathrynfw]

Oh! I don't know. It will not open for me. Is it because I have FMP14?

 

[comment]

Open it (or rather convert it) using File > Open… from the menu.

[kathrynfw]

Thank you! I got it open, and I see your scripts. I will have to play with it to see if I can figure out how to set it up. Thanks so much!

 

 

[bruceR]

And here's another example.

Contacts LTD.fmp12

[Wickerman]

I have a similar question -- I have a database of Students who will each have a record set up an administrator along with an Account they use to access the database.   Would the best approach be to set up a field in the Students table called "LOGIN ID" and use that as for the boolean test allowing access to only that record?   (Keeping that field accessible only to the admin). --  Or is there another cleverer technique for this?