Forum Discussion

TylerParker's avatar
TylerParker
Qrew Assistant Captain
8 years ago

How to construct a formula to calculate time from one record to the next

Let's say I have 2 records, both with fields that hold a time of day. They each represent the time at which a delivery van stopped at one location and then the next. Is there a way to have another fie...
APIs and custom code
App builders
Ask about Quickbase functionality
TylerParker's avatar
TylerParker
Qrew Assistant Captain
8 years ago
Matthew,

Our stops are automatically recorded by a device that is plugged into the engine, transmits that data to a server, and then imported into our QuickBase through an API call at the end of the day. So every record is going to be present at once. The stops are numbered, so perhaps option #1 could work if based off that order. I'm also interested in hearing more about option #2 if you have the time, because it sounds like a good way to keep routes separate. Thanks!
MCFNeil's avatar
MCFNeil
Qrew Captain
8 years ago
Native option: If you want to make a mess of summary fields and lookup fields... You could make stacking summary/lookup fields (my worst nightmare).

Stop 1,  (minimum stop time for the Route)
>then send as a look up
Route - Stop 1,
>Then Stack
Stop 2 (minimum stop that is greater than "Route - Stop 1"
> Then send as a lookup
>Repeat for x number of possible stops.

Thats just the beginning:

Now you need to calculate the previous stop on the same record.
It would be a huge mess of conditional evaluations.... 
if stop 2, then use stop 1 to stop 2, 
if stop 3, then use stop 2 to stop 3,
x repeats.