AnsweredAssumed Answered

looking at past results and edit field in order to determine a field

Question asked by Maikel on Jan 2, 2014
Latest reply on Jan 5, 2014 by Maikel

Title

looking at past results and edit field in order to determine a field

Post

     I know I have to make a calculation, but how.....

     My filemaker solution record timestamps, calculated from different fields. The main fields in this table that I need for my calculation are.


REG_TABEL
     ID
     Employee (unique character (username)

     TimeStart (Timestamp calculated on the TimeStart_time and TimeStart_date)
     TimeStart_time (Time input field)
     TimeStart_date (Date input field)

     TimeStop (Timestamp calculated on the TimeStop_time and TimeStop_date)
     TimeStop_time (Time input field)
     TimeStop_date (Date input field)

     _______

     My solution, calculate a start and stop time and the account name is an important field that the registration ID field next to the distinction from other registries. 

     Now my question;
     I want to know when a employee creating a new record of that employee already made a registration on the same day as the new entry is made and what is the last known TimeStop (Timestamp) is in time not in order of registration. From that record I want to use te TimeStop_time field and import in the field of the new record (TimeStart_time)

     I hope someone can help me with this calculation..

     Maikel

      

Outcomes