Has anyone been successful in being able to get the "Description" field from the security account information like you can with account name using the GET command?
There's no provision for programmatic access to the native description field in the Security>Edit Account dialog, I'm afraid.
Depending on what you're trying to achieve, an alternative would be to create a Users table that has a record for each account, then have a login script post the account name to a global key field to establish a relationship from which you can then retrieve additional information. Such a table can also be a useful place to store session data and user-specific preferences, so it may serve a number of purposes for you.
R J Cologon, Ph.D.
FileMaker Certified Developer
Author, FileMaker Pro 10 Bible
NightWing Enterprises, Melbourne, Australia
I suspected as much. However, to those FM product managers out there - it would make a simple filter for multiple accounts to be able to create specific account reports and such very easily. Espeically when you want to do internal apps and vary reports by departments.
I took your suggested method and created a separate user table. It just gets more involved in a few areas than using a simple a GET statement.
The same goes for the "comment/description" field for each field. This is, if I am remembering correct, only accessible in the lsit of fields in Define Database.
You're not remembering it correctly.
FieldComment ( fileName ; fieldName )
Keep in mind that it is not too difficult to duplicate Privilege Sets and name them with the department name or whatever you wanted to store in the Account Description field. You can get at the privilege set name with Get(AccountPrivilegeSetName), so this would allow you to procedd as you initially requested.
Best wishes - Alan Stirling, London UK
Have you seen the function Get ( ExtendedPrivileges ) and the third tab in Manage>Security Extended Privileges? I think that the FMI product managers have already done exactly what you requested.
If you want to set and extended privilege like 'QuarterlyInvoiceReporting' for a privilege set, you can then test if any user has the ability to run that report. I happen to find that a little bit limiting since it applies to every user in the privilege set. WIth an accounts table you can set the ability per user which is more flexible, but comes at the cost of having to do the work yourself.
-- Drew Tenenholz
Retrieving data ...