Workaround for getting last value from query of big table

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

Even better, thanks :slight_smile:

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.