I would like to use a script on file open that uses the account to determine the starting layout. I want guests to get one layout, users to get another and admins to get a third. I tried get(accountname), but it returned the account name for my machine rather than the account name used to log in.

Get(accountName) returns exactly the account name used to login to the database. In any case, it probably won't help you, what you might try instead is: Get(privilegeSetName)

Cool, this is what I was looking for. I haven't tried it yet but lets see.

Genx,

I gave it a go but it I can't seem to figure know how to use Get(privilegeSetName), my code was something like,

If(Get(privilegeSetName)=accountname but Fm says there is no table.

So I am stcuk there, any help to start off.

Thank you kindly

no no no.. you said that you wanted to go to a specific layout if your user had admin priveleges, a different one, if they had other priveleges etc. etc.

So, you would use:

If[Get(PrievelegeSetName) = "Administrator]

Go To Layout[Your Layout For Admin Users]

Else If[Get(PrivelegeSetName) = "Managers"]

Go To Layout[Your Layout For Managers]

Else If[etc etc]

.

.

.

.

.

End If

Or.. by account name

If[Get(AccountName) = "Bob" ]

Go To Layout[Layout For Bob]

Else IF[Get(AccountName) = "Jen" ]

Go To Layout[Layout For Jen]

.

.

.

.

End If

Ah...so that is the part I was missing,,,cool