# Workaround for getting last value from query of big table

**URL:** <https://community.glideapps.com/t/workaround-for-getting-last-value-from-query-of-big-table/75355>\
**Category:** Ask for Help\
**Created:** [August 1, 2024, 2:39pm UTC](https://community.glideapps.com/t/workaround-for-getting-last-value-from-query-of-big-table/75355 "2024-08-01T14:39:06Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rien\_Dumore](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rien_dumore/32/79283_2.png) [@Rien\_Dumore](https://community.glideapps.com/u/Rien_Dumore)\
**Post date:** [August 1, 2024, 2:39pm UTC](https://community.glideapps.com/t/workaround-for-getting-last-value-from-query-of-big-table/75355/1 "2024-08-01T14:39:06Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [August 1, 2024, 5:24pm UTC](https://community.glideapps.com/t/workaround-for-getting-last-value-from-query-of-big-table/75355/2 "2024-08-01T17:24:28Z")

</div>

A simpler option is to sort the query in reverse order. Then you can use Single Value-\>First.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [August 1, 2024, 11:56pm UTC](https://community.glideapps.com/t/workaround-for-getting-last-value-from-query-of-big-table/75355/3 "2024-08-01T23:56:23Z")

</div>

That’s genius.

---

<div class="post-metadata">

**Author:** ![Rien\_Dumore](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rien_dumore/32/79283_2.png) [@Rien\_Dumore](https://community.glideapps.com/u/Rien_Dumore)\
**Post date:** [August 14, 2024, 8:20pm UTC](https://community.glideapps.com/t/workaround-for-getting-last-value-from-query-of-big-table/75355/4 "2024-08-14T20:20:15Z")

</div>

Even better, thanks 🙂

---

<div class="post-metadata">

**Author:** ![Mikaeldorval](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mikaeldorval/32/67405_2.png) [@Mikaeldorval](https://community.glideapps.com/u/Mikaeldorval)\
**Post date:** [August 15, 2024, 3:38am UTC](https://community.glideapps.com/t/workaround-for-getting-last-value-from-query-of-big-table/75355/5 "2024-08-15T03:38:39Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [August 15, 2024, 3:42am UTC](https://community.glideapps.com/t/workaround-for-getting-last-value-from-query-of-big-table/75355/6 "2024-08-15T03:42:32Z")

</div>

I haven’t tested it with very large tables, but I don’t see why it wouldn’t work.