After limiting a users access to certain records, some show as <No Access> . How do I hide these from the users view, so the database appears more organised.
"Show all records" showes unaccessible records, so customize the menu (need FM Advanced) to finding something, and set the script as onLayoutLoad trigger.
As user19752 said, make a script!!
Simply perform a find for the records with the account name.
As I understand it, any find you perform will automatically omit any records that are <no Access>. This can be scripted to take place when the file is first opened. With this one change, the only way a user can encounter <no Access> records is if they use one of the other Records menu actions such as show all records.
If you have FileMaker Advanced, you can create a custom menu that substitutes your scripts for the Show all, show omitted only options that avoid these steps!
I don't have Filemaker Advanced.
Do you have a example of the steps I would require to script.
To expand on the issue we have a customer database and were only certain users see certain customers which has been created in privilege set. So each user get some customers that display as no access.
What happens when you tag all the elements in the record with Hide Object when Get(RecordAccess)=0 via the Inspector?
Steven H. Blackwell
Platinum Member Emeritus, FileMaker Business Alliance
Say that you have a field named __pkPrimaryKey in your table that auto-enters a serial number or UUID. Defined that way, this field always has data and is never empty. The following script then finds all records, but when using limted access privilege sets where record level access control expressions block "view" access to certain records, those "no access" records will be excluded by this script:
Go to layout ["yourTable" (Yourtable) ]
Enter FInd MOde [pause: no ]
Set Field [YourTable::__pkPrimaryKey ; "*" ]Set Error Capture [on]
Perform Find [ ]
Retrieving data ...