Setting timestamps script for last and current records.

[sboisvert]

I have a layout that I use to track time spent on certain projects. I have assigned 2 buttons, Start, and End that the user uses when signing out of a project. Each project has a unique Project Number assigned to it that a new record is created for it when a new task is being done to it and signed out.

For example: Project 101 is signed out for design work by Joe, a new record for Project 101 is created, Joe hits the Start button and the current Date and Time are entered into their respective fields. When Joe's finished he hits the End button and an end time and date in field is eneterd with that current info.

The problem arrises when someone does not hit the End button, say during a review. So the next time it's signed out the record previous to it does not have an end time and the clock is still running on it.

What I would like to create i a modification to the Start button that looks at the previous record for that Project number, looks at the End time and if it does not have one, put the current time in that field as well as putting that current time in the current records Start time.

I hope this is not to confusing but I have tried several things and I am having difficulty with getting the previous record info to either enter the missing data or to see that there is an end time there so just put a Start time in the current records start tie field.

Any suggestions would be most appreciated!!

Thanks!!

[IdealData]

This is a conundrum I have faced a few times. Eventually I have settled on allowing the users to declare the amount of time spent, without requiring start/end times.

[sboisvert]

Unfortunately we don't want them to do that (this way it keeps it real time Also, some people who it's assigned to are not log in in and out, that is a job that I will do for them, it just makes it easier if it's automated.

[sboisvert]

Is there a acript similar to the calculation where it goes to the Last(related Record)? Once there is there a way to get back to the current record?