Re caluclate field value after sort

[rscosworth1998]

I am very new to filemaker so if this a no brainer then I apologise in advance.

I have a database which I import data from an employee time recording system. I import employee number and a timestamp. The data doesnt contain any detail as to if they are entering or leaving the building.

I sort the data by employee number and date. I assume that the first record is when they started work. I have a getnthrecord function to get the time from the previous record. I will then subtract the second record from the first to calulate the time in work. All this works OK untill i import some more records and perform a sort.

My question is how do i recalculate after I have performed a sort.

[Ocean West]

your calculation should be un-stored, so that it will reevaluate based upon current found set and sort order.

[rscosworth1998]

Fantasic many many thanks.

[rscosworth1998]

I have a csv file which contains records containing person name, and time. A record is created each time a person enters or leaves a location. Therefor the first record is the time they enter the room. The next record is when they leave the room. They should have been in the room for 55 mins. There are four rooms that they have to goto. We dont want to record when they leave the room after 55 minutes

I am trying to create a database which will show the amount of time spent in each room.

So far I can get a portal for each person showing the entries for them against each room. I dont how to subtract record 3 from record 2 which in turn subtracts from 55 mins to show the total time. Enclosed is my very novice attempts at trying to work this out. The xls file is what i am importing.

Any help would be much appreciated

time.zip

Edited August 7, 2008 by Guest

[Raybaudi]

Enclosed is my very novice attempts at trying to work this out.

Where is it ?

[rscosworth1998]

file now enclosed. Where it says in the description peoples names please substitiute this for numbers

[rscosworth1998]

We record peoples attendance at a training session using barcode readers which we use to scan there name badge. When they attend the session we scan them in which creates a record which has there id number the barcode reader id and a timestamp. If they leave the session before the end they we scan them again. If they return they get scanned in as well. We don’t scan them out at the end of the session.

I need to generate a report that lists there names the sessions they attended and how much if any of the session they missed.

I have created a database and can see the records for each person in a portal. What i cant do is calculate the amount of time they were absent from the session.

I have enclosed my fm file and 2 files with sample data i wish to import.

Any advice would be a great help this is driving me mad.

support_request.zip

[comment]

I believe this is your third thread with the same question:

http://www.fmforums.com/forum/showtopic.php?tid/197274/

http://www.fmforums.com/forum/showtopic.php?tid/197284/

[bruceR]

file now enclosed. Where it says in the description peoples names please substitiute this for numbers

Nope, no file is enclosed.

[Raybaudi]

Yes, now there is... but attached to the first post :

[Ocean West]

three posts merged :

[rscosworth1998]

Guilty as charged. I thought i had put it in the wrong section and made a better job of writing up the requirement.

Apologies