AnsweredAssumed Answered

FileMaker 11 Self-Reference Global Auto-Enter fail

Question asked by JohnDuncan on Apr 7, 2010
Latest reply on May 18, 2010 by TSGal

Summary

FileMaker 11 Self-Reference Global Auto-Enter fail

Description of the issue

FileMaker Products InvolvedFileMaker Pro 11FileMaker Pro 11 Advanced Operating Systems InvolvedMacOS-X 10.5.8MacOS-X 10.6Windows XP Detailed description of the issue:A global text field with an auto-enter calculation (calculate always, calculate if all fields empty) fails to work on FileMaker 11 but works fine on FileMaker 9-10.  The field name is "FilterLocationGlob" and the auto-enter calculation is: If ( PatternCount ( Get ( CurrentPrivilegeSetName ) ; "TROY" ) > 0 ; "Troy" ; FilterLocationGlob ) In FileMaker 10 this produces the value "TROY" in the field if someone logs in with the TROY PrivilegeSet and if they log in with some other PrivilegeSet it leaves the global with its default value.  In FileMaker 11 however the VALUE of the calculation is: "If ( PatternCount ( Get ( PrivilegeSetName ) ; "BBDO" ) > 0 ; "Troy" ; FilterLocationGlob )" This shows up in the field contents in browse mode and in the data viewer.  Note that not only does it not produce the desired output but it displays a value that uses the FILEMAKER 10 designation of Get( PrivilegeSetName ) instead of Get( CurrentPrivilegeSetName ). Expected ResultThe field should show "Troy" or whatever was left in the global. Actual ResultThe field shows correctly on FileMaker 9 or 10 but shows the text of the calculation in FileMaker 11 Exact text of any error message(s) that appeared:N/A Any additional configuration information/troubleshooting that is relevant to the issue:The databases were created in FileMaker 7 and have been moved forward through 8, 8.5, 9, 10, and 11 Any workarounds that you have found:So far I have not found a workaround.  I've tried changing the global to a non-global and back.  Changing it to a numeric and back and de-hosting the databases and resetting the value of the global in single-user. 

Outcomes