AnsweredAssumed Answered

Get(accountname) does not work

Question asked by BobMarshall on Apr 1, 2015
Latest reply on Apr 2, 2015 by philmodjunk

Summary

Get(accountname) does not work

Product

FileMaker Pro

Version

13

Operating system version

Windows 8.1

Description of the issue

I want to control access to different parts of my database by requiring the user to enter their account name and password.
Irrespective of the account name used to login it returns "admin".

Steps to reproduce the problem

I have used included the account names in a table of users and created a field containing the formula Get(accountname) in each related table.
My account names are Admin, User, [Guest] where Admin corresponds to access level "admin" with full access to develop the database, User can add, edit and delete records, and [Guest] is read-only. While the database opens with the required access level Get(accountname) always returns the name "admin".

Expected result

Log into Filemaker as User (with the password) or [Guest] (with no password). I expect Get(Accountname) to return the account name entered at log in: User, or [Guest].

Actual result

Log into Filemaker as User (with the password) or [Guest] (with no password). Get(Accountname) returns: admin

Get%28accountname%29_problem.png

Outcomes