I have a list of stops with timestamps in my app.
I want to calculate the duration of time between the CURRENT stop and the stop RIGHT BEFORE IT.
In my futile attempts to accomplish this I have created a list of relevant timestamps:
Now I want to say, take the current timestamp and calculate the span of time between it and the timestamp right before it.
So if this was a programming language I would start at index 1 instead of index 0 and subtract every timestamp from the timestamp right before it. But as far as I know for loops are not implemented in AppSheet.
How should I go about this? I’ve been struggling with it for a few days.