Quick search facility for listing records by date/time viewed

[ozziggy]

Hi all, forgive me if this is in the wrong place. I could not easily figure out where to post, apologies in advance.

 

I was wondering if there is  a way to have a records sorted in order of  "date/time" last viewed. 
The idea being to have a list which the user can easily see records they were last dealing with and to use that list as hot links to those records. An example of this functionality is how Microsoft word gives you a quick find list of recently created documents.

 

Kindest regards 

 

Ozziggy

[rivet]

1. simple solution if it is just a single user, is to have a field called 'browse' which could be a timestamp that is populated via layout Script Trigger OnRecordLoad.

 

2. multi users: perhaps:

- create a user table with an indexed field called history.

- create a value list call 'browse_history' from that field.

- in your main table use the Script Trigger OnRecordLoad, push the records ID to the user::history field as an array most recent ID descending .

- then when sorting your main table/list use custom sort with the 'browse_history' value list.

[ozziggy]

Hi Rivet

 

Thanks for this i will give both ideas a try but i think i am heading towards a multi user environment so the second solution may be the way to go

[ozziggy]

Oddly though my get (current hosttimestamp) dosent give my current date and time. Instead it is listing 1/01/0001 in the timestamp field on loading the record. Forgive me but i am new to Timestamps but shouldnt it be getting the current time and date of mysystem or am i being daft?

[bruceR]

It is impossible and not a good use of time to guess what you are doing.

 

I suggest you upload a simple example file showing how you are trying to use that function.

[ozziggy]

Hi Bruce. I understand and next time will prepare a file for you. I am relatively new to FM as you can no doubt tell.

 

In the meantime i am happy to report that the advice here helped tremendously and i was able to do what i wanted. I would show you a screenshot/file but i am not sure how to upload said things to this forum yet ( thats my very next task)

 

Thanks once again for taking the time to help out, much appreciated by a noob like me.

[bruceR]

The history table was the main problem you presented, and it appears that you have a solution. Good!

 

But the other part was the use of get( currentHostTimeStamp). it doesn't sound like the solution addressed that problem. Seeing how you have attempted to implement it will make it easier to understand what you're doing.

[ozziggy]

Hi Bruce

 

I was using the gettimestamp as a script that auto ran on "record load" layout script trigger. This was to give a "when the record was last viewed" field a value. I used this in a portal and was able to list the top 5 most recently viewed (sorted portal by the timestamp). I used the go to related record function so that a user could click on a record in the portal list and go to that record. Since then i have changed my ideas made the portal show records based on "last modified" time stamp so that user gets a "quick click list" of records they were most recently working on.

 

It seems to work now. 

 

Hey, could you point me in the direction of instructions on how to post screenshots and example files in the forum?