Imitating a Linked List in AppSheet

Hello AppSheet Community :slight_smile:

I have made a driver/dispatcher app. I have a list of stops whose check-ins were successful. I want to create a virtual column that takes two stops and calculates the duration of time between the changeTimestamp values in the rows corresponding to those stops. So the way I conceptualize this is similar to a linked list: I want to write an expression that specifies the row before the current row, then have it interact with the current row. So I would be able to do this in C++ but I don’t know how to do it in AppSheet. Does anyone have any ideas?

Thank you.

1 Like

When I create a new row, I have a physical column that gets the record key of the previous row… Then it’s a pretty simple look up, and math…