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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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