Count elapsed time in a Portal

[overrider]

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

[aaa]

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

[overrider]

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.

[comment]

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?

[-Queue-]

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.

[overrider]

-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.