2 Replies Latest reply on Dec 29, 2014 10:13 AM by schamblee

    commit records



      commit records


      I have several users working as remote clients from filemaker server.  My problem is when a user does not click out of a field it prevents other users from accessing or modifying the record or some scripts.  is there a way to automate the "click off field" if the first user leaves there desk and is still in an active field? this is a large data base with many users. 

        • 1. Re: commit records

          That's a tricky one.  You could use an OnTimerScript Script step in a script to run when the record is open for editing (if you have to enter a layout to do this, even better).  This would commit the record at a certain interval.  The problem then becomes, how long, and then what?

          How long do you want to wait?  Do you want the record commited without validation, or reverted?  Do you want to pop up a window, give the user a certain amount of time then commit/revert record?  Do you want to let them know it happened when they get back?

          • 2. Re: commit records

            Server also has a disconnect when idle, which I would recommend using, as Steve stated above I would also use an OnTimerScript trigger that commits records at a set time.