2 Replies Latest reply on Dec 3, 2016 9:50 AM by JackRodges

    Using Account Name when there are multiple users logged on



      Using Account Name when there are multiple users logged on


      I'd like to have a Welcome layout that is individualized to user, using Get(AccountName) in a calculation that yields the user's first name.

      If multiple users are simultaneously using the database (that I host on my workstation using regular FileMaker Pro), can the database running on the clients separately keep track of Account Name, so the correct user name is shown on client computers simultaneously?

      I suppose this is true, but it is confusing.  If so, the software running on each client has this autonomy from the hosting computer - a resulting field of a given record can hold different values at the same time on the client computers, even though there is only one host.  Is this correct?

      Thanks.  Joel

        • 1. Re: Using Account Name when there are multiple users logged on

          Welcome to the concept of edit locking, unstored calculations and fields with global storage.

          If you click into a field on a given record, Filemaker "locks" that record against edits by other users. If they attempt to modify a field in the database, they get an error message telling them that they cannot edit the record until you commit the record to release it.

          Global fields and certain unstored calculations, however display values unique to each user. If you modify a value in a global field, only you will see that change and the value in the global field reverts back to it's original value when you close the file. The only way to make a permanent change to value in a global field is to make the change on the host computer.

          An unstored calculation field that uses a get function that checks for settings, such as the account name that are specific to a given client will act just like a global field, each user will see the value in this field consistent with the settings on their computer. Get ( LayoutName ) or get ( ActiveFieldName ) to name just two examples evaluate in the same manner.

          • 2. Re: Using Account Name when there are multiple users logged on

            Learn and use this principle: Test your idea and accept the result. Never assume something works the way you think it should.


            For instance, you could have 5 people open the same record, find record id 12, and try to change a field's value. FileMaker will show you how it works.


            You will also discover that these 5 people can pull data from the same record simultaneously such as the cost of a product for new records.


            Happy scripting...