3 Replies Latest reply on Feb 9, 2016 3:59 PM by macwombat

    How to Deactivate a cursor?


      I have a layout, that is opened daily by many of our employees. On it, there are fields to enter time worked against charge-numbers (in hours).


      What is happening is, if one employee opens the layout, clicks into a field, then enters hours, but never closes the layout, and never clicks out of the field, the cursor is left sitting there. Sometimes they will even just move the layout to the back, and bring up another application in front, working away for hours. Meanwhile, someone else needs to open the layout, and enter some time for themselves on the same account/date field. But they are locked out and get the FM message that someone else is editing the record.

      Is there a way to move the cursor out, to where there is no blinking cursor anywhere on the layout? Possibly using the timer function? Say after 2 minutes or so?


      Is this possible? Id love for it to go to the same state the layout is in when you open it for the first time- no field selected, just first record (this layout is based on a list view by the way.

        • 1. Re: How to Deactivate a cursor?

          Hi.  Yes you can set an On Timer script - see the help file info here: Install OnTimer Script

          The script would commit the record.  Then a new user can edit it.


          Question though - do you really want different users to be setting data on the same record?  Would it be a better solution for each user who is entering hours on the job to enter those on a new related record?  Just a thought.


          HTH.  Chris

          • 2. Re: How to Deactivate a cursor?

            This is a highly unusual solution. It really isn't the same record, but it's the same field, on the same row. I have a set of filtered table occurrences, and filtered single field portals so that when an record is created, it happens in another table. The layout is based on a List View of Accounts, so all of them are listed. Then out next to each account, is an entry field for each day of the week. But these are based on the Hours table, that match on account id, employee id (logged into the solution), and the date that they are sitting on. It's kind of elaborate (to me anyway). I didn't come up with it. But except for this one annoyance, it works pretty well.


            It's set up so that when you choose your name from a list of employees in a pop-up, that selection sets a global field to your own id (based on your login account). Then the day is done similarly...and account. You only see your own time, when you choose yourself.


            I also set up a button that can only be seen by the logged in user that "Submits" the time. All this does is set a field in Hours to a 1. It lets the approver know who is finished with their time or not.


            This description may not seem adequate of what it does, but suffice it to say that I can't enter time for someone else. However, I can block another person from using the same field at the same time.

            It's kinda weird, but really has the look and feel of an excel spreadsheet.


            Thanks for the tip. I will give it a try.

            • 3. Re: How to Deactivate a cursor?

              Ah - ok.  So even though the hours are being set into a separate record because that record is on a related table being viewed through a portal, the parent record on which the user is sitting also gets locked to other users while they are on it.  Use the on timer script method.  On the layout in layout setup, set a script trigger OnRecordLoad, that runs the On Timer Script.