Does anyone know of a script that will forward specific users (referenced by the entry of their password) to specific layouts? I know you can assign specific layouts that can be viewed only by certain users, but it does not include forwarding based on the enttry of a password.

I'm running FMP 6.

Supposing that you have a (text) field that houses the user's password, then it's just a matter of if statements.

If [userspass = "gorilla"]

Goto layout [water]

If [userspass = "monkey"]

Goto layout [earth]

Else

Goto layout [fire]

End If

Or something to that effect. Since you don't want certain users to view certain layouts, make sure that the layout(s) doesn't show up in the layout menu (under the layout setup).

Where does the password get entered? There is no way to access the password entered during authentication (for obvious security reasons).

If you are using FMP 7 then set up the accounts and privileges correctly, one for each user. Then use the Get(AccountName) function to display layouts on a by-user basis. Even better (and less work in the long run) assign each user to a privilege set, and display the layout based on the Get(PrivilegeSet) result.

That sounds like a great idea. But where do I initiate this function? Aren't functions only for calculation fields?

Tom