Jump to content
Sign in to follow this  
madman411

go to custom layout

Recommended Posts

Hi all

I have a database which keeps track of customers and inventory. I am trying to change it so when a staff member logs in to the database, it automatically takes them to the layout they typically work on. Such as, when "Cindy" logs in she is automatically taken to the inventory layout because she works in that department, but when "Mike" logs in he is automatically taken to the customers layout, and so on. I imagine it is a start up script you would run that is some how tied in with accounts/privileges but I have no idea where to start with a script like this.

Any ideas?

Thanks

Share this post


Link to post
Share on other sites

There are many different ways to handle this and what I'm suggesting is extremely basic.

You are correct in creating a script that will be executed at start up. What you can do is create a script that looks at the account name and then dictates where the user goes.

Example:

If[Get(AccountName) = "Michael"]

go to layout[customer]

Else If[Get(AccountName) = "Laura"]

go to layout[invoice]

ect....

Hopefully this helps.

Share this post


Link to post
Share on other sites

thanks that will work for now. is there a more advanced way of doing this? quite a few people have accounts on the database and i'm looking for an easier way of doing this so i don't have to manually update the script when i add/delete accounts.

thanks again!

Share this post


Link to post
Share on other sites

You could set a global field to the account name (which version are we really talking about here?), then get the preferred layout via a relationship from a preferences table.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.