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
What are the chances those 'logs' have any unique identifier AND they are somewhat sequential in their uniqueness?

If so that would be amazing, and somewhat simple to implement.

If not, you would need some type of script to that will sort and write the previous stop values in.

A skilled programmer could do it in about 2-3 hours