Hello,

I have a Portal with a few Records, each have a Field containing the Time when the Record was made. Is there a way to calculate the elapsed time without using a script? So basically, last portal row time - first portal row time... thanks

I attached example. I will be glad if this solves your question. Look, Creating_Time and Current_Time is Timestamp field, Elapsed_time-Time field.

Elapsed_Time.zip

hello, thank you for your file. what i meant to ask though was whether it is possible how to figure out the elapsed time from records displayed via a portal. it is maybe not possible without a script.

The elapsed time since when? Since the creation of the previous portal record, or since the creation of the first portal record - or what?

Also, what is the relationship that the portal is based on?

If the child side of your relationship is sorted naturally (in creation order) or in the same order as the portal, then a calculation of

Last(rel::time) - rel::time

in the parent table should work.

-Queue- ok this worked; exactly what i had in mind. thank you so much.

comment: sorry i wasnt clear. the elapsed time is based on the time field value on the first record in the portal and the last. the relationship is a joined date/time relationship. i am using this to control a certain route a security guard has to walk every day. while he walks he is scanning in rfid tags, which record date, time and rfid. this info i get every morning to import into my filemaker thingy i build. i am using the elapsed field to see with one look how long the guy took to complete the route.