3 Replies Latest reply on Mar 28, 2014 3:01 PM by philmodjunk

    record modification, (identify current user on FMserver network)

    R12GS

      Title

      record modification, (identify current user on FMserver network)

      Post

           There are several conditions where I would like to be able to see

           - who is on the system and what databases they have open

           - time they logged on

           - time they made their last record modification

           - what record they are in possession of

           I realize you can see some of this on the FMServer, but I want to see it on an FMPro client.

           Just posting the thread for discussion because it would be very useful.  Sometimes I hear my guys having a hard time on the phone, and I'd like to look at the record they are working on, assess if I can offer some outside help.  Also get an idea which ones are entering data and which might just be surfing the web.  (as I'm doing now of course ;-)

        • 1. Re: record modification, (identify current user on FMserver network)
          philmodjunk

               Sounds like something could be done with a table where you have one record for each user that links via relationship to the main table where the user might be editing records. Script triggers could update a match field in that record to link it to the record they most recently edited--where fields in that main table records can record such data as the date/time the record was last modified and by whom.

               There is also a get function, get ( RecordOpenState ) that will tell you if a record is currently open for editing or not.

          • 2. Re: record modification, (identify current user on FMserver network)
            R12GS

                 Interesting ideas.

                 I suppose get ( RecordOpenState ) somehow queries each record and discovers, "I CANNOT GET ANY INFO FROM THAT RECORD".    Whereas I am requesting actual data (a username) from a record that it can't open.

                 I guess I can see why this is not available.

            • 3. Re: record modification, (identify current user on FMserver network)
              philmodjunk

                   I would guess that there is a "flag" set on the record. Get ( RecordOpenState ) merely checks the status of that flag for the current record or, if used in an unstored calculation field, checks the flag of the current or related record of the table where the field is defined.

                   Thus if you have a "user" record for "John" and the OnRecordLoad trigger on say, an invoices layout, linked that record to John's user record each time he selects an invoice record, fields from invoices placed on a layout for the User table could show you which invoice is the current record on John's workstation and a calculation field defined in invoices could use this get function to tell you whether or not he currently has the record open for editing or not.

                   And a timestamp field in Invoices could tell you the date/time that he last modified the record and committed it.