LinkedIn
Twitter
I currently have a delivery app for a bottled water delivery company.
Each month has up to 3 delivery days as we deliver every 14 days.
When the driver opens the particular route view it will show them all delivery days for each customer(shown below)
When the driver presses filter today it will bring them to a new view that only shows (TODAY)'s deliveries.
I would like to make a virtual column that shows them what they delivered last time(for example on October 15th it would show them what they delivered on October 1st)
How do I make a reference to only a certain row within a table? I currently have a sort column that keeps the customers in the order they are on the route, so for instance each entry you see here for Estrella has a different number in a [Sort] column in each rowโฆ hers for the first delivery day(row 1) is 1, for the second(row 2) is 2, for the third(row 3) is 3 and the next customer would be 4,5,6 etcโฆ is there a way to reference the [Delivered] column from the row that is โ[Sort] minus 1โ ?
TIA
