Get(RecordAccess)
Purpose 
Returns a number based on the current record’s access privileges, assigned through the Custom Record Privileges dialog box.
Format 
Get(RecordAccess)
Parameters 
None
Data type returned 
number
Originated in 
FileMaker Pro 6.0 or earlier
Description 
Returns:
 •
0 if the custom record privileges of an account’s privilege set have neither View nor Edit privileges set to yes for the current record
 •
1 if the custom record privileges of an account’s privilege set have View set to yes for the current record, or if View is set to limited and the calculation defined for limited access returns a value of true
Note  If both View and Edit are set to yes, Get(RecordAccess) returns 2
 •
2 if the custom record privileges of an account’s privilege set have Edit set to yes for the current record, or if Edit is set to limited and the calculation defined for limited access returns a value of true
Notes
 •
Get(RecordAccess) only returns information about the privileges defined for accessing records. It ignores access privileges assigned through individual layouts. To fully check access to a record, consider the return values of the Get(LayoutAccess) function and Get(RecordAccess).
 •
If you specify the context for the current calculation, this function will be evaluated based on that context; otherwise, it will be evaluated based on the context of the current window.
 •
For information on how functions evaluate differently on the host versus the client, search the FileMaker Knowledge Base available at http://help.filemaker.com.
 •
See Editing record access privileges for more details about limiting access to records.
Examples 
Returns 1 when the record access is view-only.
Related topics 
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas
Was this topic helpful? Send feedback.