I have a layout that has many tab panels. We are using Filemaker 12. There is one tab panel that only a couple people should have access to, I thought i could assign a script to OnTabSwitch, so if you were a member of a certain privilege set you'd get a message and be redirected back to the tab you were on.

 

I get the message to come up but it won't Go To Object, I'm somewhat frustrated, it seems like it should be rather simple.

 

The script is attached, I have  a few extra steps because I have been messing with this issue for a while today.

 

Any help would be GREATLY appreciated! Thanks

 

The idea here is to cancel the triggering event by exiting the script with a false result, for example:

Allow User Abort[Off]
If [ GetValue ( Get(TriggerTargetTabPanel) ; 2 ) = "MyRestrictedPanel" and Get(AccountPrivilegeSetName) ≠ "AllowedPersonnel" ]
 Show Custom Dialog [...]
 Exit Script [Result: 0]
End If

This will result in user remaining on the current tab panel when the two conditions above are true.

 

 

IMPORTANT:

This is purely a cosmetic device. There is no real security in anything that's set up using layout measures. Always use accounts and privileges to make sure users cannot access data they are not supposed to see or modify.

[…]
If [ Get(TriggerTargetTabPanel) = "MyRestrictedPanel" and Get(AccountPrivilegeSetName) ≠ "AllowedPersonnel" ]

 

Just to confuse matters a bit:  

 

Get ( TriggerTargetTabPanel ) returns a list with the index number and the object name (if any) of the target tab, so UIM, the above expression should read:

If [ GetValue ( Get( TriggerTargetTabPanel ) ; 2 ) = objectName … etc. ]

http://fmhelp.filemaker.com/fmphelp_12/en/html/func_ref2.32.86.html#1053326

@eos: you're absolutely right. I have edited my previous answer. Thanks for the catch.

I meant to thank you for your help, it worked! I had the first part right it was the Exit Script [Result: 0] that I missed! Ugggh!

 

It's the little things!