We have 80+ iPads using the FileMakerGo app.

 

I've created a table that includes three different layouts.

All layouts include the field Employee Name.

Employee name = Get(AccountName)

 

I've also created a Privilege Set for users that limits the records they see to records created by their user name.

Custom Record Privileges -> View -> Specify Calculation -> EmployeeName=Get(AccountName)

 

Now the user is only able to see data created by their user account and all other documents still show but they have <No Access> in all editable fields.

 

I want users to only have to scroll through their own, viewable, documents.

In order to do this I believe I have to write a script.

This script should only pull up documents created by the current user.

 

I've spent hours trying to get this done with little progress. 

 

Any suggestions?

 

Val

Actually, any Find done, such as primary_key > 0, will return only the records the user has permissions to view.  The other records are automatically eliminated from the resulting found set.

 

Steven