Record-Level Access Control
IntermediateUse calculations to restrict which records individual users can view, edit, or delete.
What you'll learn
- How record-level access calculations work
- Using Get(AccountName) to filter by user
- Setting separate view, edit, and delete calculations
- Performance considerations for record-level security
FileMaker can restrict data access at the individual record level using calculations. A record-level security calculation returns 1 (allow) or 0 (deny) for view, edit, and delete operations -- evaluated against every record for every user. This is the mechanism behind "show each user only their own records."
1/4
1
Where to configure record-level access
In File > Manage > Security, edit a privilege set. Under the Tables section, click the dropdown for a table and choose "limited" for View, Edit, or Delete. This opens the calculation editor where you write the condition that must be true for access to be granted.
Sign in to track your progress and pick up where you left off.
Sign in to FM Dojo