AnsweredAssumed Answered

Limit View by value but not global variable

Question asked by DanielShanahan on Jun 5, 2015
Latest reply on Jun 8, 2015 by disabled_jackrodgers

Mac Yosemite

FileMaker Pro Advanced 13.0v5

 

I set up a privilege set to limit a user's access to records.  The user can only see records s/he created.  There's nothing really special about the calculation or the opening scripts and subscripts (which are all set to fun with Full Access).

 

My problem is that it doesn't work with a global variable.  It works when I hard code the value but that's hardly helpful.

 

See image 01_SeeOnlyMine_Security for the calculation.

 

This works-

Records can be viewed when:

InspectorID = 3

 

This does not-

Records can be viewed when:

InspectorID = GetAsNumber ( $$InspectorID )

 

Nor does this-

Records can be viewed when:

InspectorID = $$InspectorID

 

PROJECT::inspectorID is a number field.  No auto-calculations or lookups.

 

See image 02_SeeOnlyMine_LoggedIn to see the AccountPrivilegeSetName and $$inspectorID.  Even though $$inspectorID=3, "Records can be viewed when:" does not evaluate as True.

 

Any thoughts?

Outcomes