Reference > Functions reference > Get functions > Get(RecordAccess)
 

Get(RecordAccess)

Returns a number representing 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.

See Editing record access privileges for more details about limiting access to records.

Example 1 

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