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?