Find based on Get (AccountName)

[JohnnyZ]

I have a Project Management solution that has one engineer assigned to each project. The engineer's name is the Account Name, and is also stored in a text field in the Projects table.

Could there be a way to set up a relationship to display only records that have the current user Account Name in the engineer name field? A global calculation field seems to always get the account name that starts the application, not current user logged on. Any insight will be greatly appreciated!

[seanc]

Can't believe no one answered this yet!

You can definitely do this, no problem.

I have a table (called storage) in my system, which only has one record in it, and a few fields that I use "globally" across all my tables. I find this works much better than having global fields, especially for IWP.

One of the fields is a calc field called currentAccount, which I have set to "Proper ( Get (AccountName))".

At the top of every layout in my system is a merge field which shows the current user logged in, and I've also used it on my initial layout to generate a portal showing a list of buttons which can switch to the layouts each user is allowed to access. This way, anyone in the company can access the database via active directory authentication, and I can control where they can go via the structure of the database.

Loving that AD authentication

So yes, you can do exactly what you've asked this way - and it works brilliantly! You could use finds or GTRR script steps... anything you like.

Cheers,

Sean.

[JohnnyZ]

Thank you! That is what I need to know. I really like the idea of just the authorized user's buttons in the portal!