Imitating a Linked List in AppSheet

tvinci
Participant V

Hello AppSheet Community

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

0 2 326
2 REPLIES 2

Steve
Participant V

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โ€ฆ

Top Labels in this Space