I needed the last value of a big table query. This is not possible directly glide blocks you. However, if you use a joined list, then split the joined list and use the single value column on the split it works.
This is not a clean method but it works
A simpler option is to sort the query in reverse order. Then you can use Single Value->First.
3 Likes
That’s awesome!
Makes you wonder why single value → last isn’t yet available when such a simple workaround exists.
Is this a stable workaround? Even with over 25k rows?
I haven’t tested it with very large tables, but I don’t see why it wouldn’t work.