1 Reply Latest reply on Aug 8, 2012 2:43 PM by philmodjunk

    showing last 15 records visited

    RachelJacobsen

      Title

      showing last 15 records visited

      Post

      Is there a way to show the last 15 records visited?

        • 1. Re: showing last 15 records visited
          philmodjunk

          If you do some scripting. Yes.

          Add a TimeStamp field: LastVisited.

          Use the OnRecordLoad trigger to perform this script:

          Set Field [ Yourtable::LastVisited ; Get ( CurrentTimeStamp ) ]

          Sort your records in descending order by LastVisited and the top 15 records will be the 15 most recently visited. A 15 row portal sorted in the same manner could also display such a list.

          The above works for a single user database or a Multi-user database where you want to see a list of most recently visited by all users.

          In a multi-user database where you might want to track the 15 most recently visted by the current user, a different approach could be used that stores the primary keys of each record visited in a global variable.