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
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โฆ
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |