# Choose last value in single value

**URL:** <https://community.glideapps.com/t/choose-last-value-in-single-value/14833>\
**Category:** Ask for Help\
**Created:** [August 27, 2020, 6:13pm UTC](https://community.glideapps.com/t/choose-last-value-in-single-value/14833 "2020-08-27T18:13:14Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\
**Post date:** [August 27, 2020, 6:13pm UTC](https://community.glideapps.com/t/choose-last-value-in-single-value/14833/1 "2020-08-27T18:13:15Z")

</div>

Was this always there?  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/4/44417a5782459a5a209f2ab0d36673484aee315d.png)

This could be very useful!!

---

<div class="post-metadata">

**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\
**Post date:** [August 27, 2020, 6:32pm UTC](https://community.glideapps.com/t/choose-last-value-in-single-value/14833/2 "2020-08-27T18:32:39Z")

</div>

I don’t think so!

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [August 27, 2020, 7:12pm UTC](https://community.glideapps.com/t/choose-last-value-in-single-value/14833/3 "2020-08-27T19:12:26Z")

</div>

I feel like it’s new, or I just discovered it as well. I don’t use Single Value very often. Works great with relations though.

Proposed it’s use here:

> [@Available for copy: Newest form choice, progress bars & joined texts concept](https://community.glideapps.com/t/available-for-copy-newest-form-choice-progress-bars-joined-texts-concept/14799/7):
>
> Quick answer, create a template of user email and timestamp. Create a self relation to the data in the sheet using user email. Then create a single value column to get last email timestamp value. Finally use an if then column to compare template to single value. If it matches, it’s the last row. Or you can incorporate rollup to get max date instead of single value from the relation. Then create a template of email and rollup and check if it matches the current row. Finally filter by if th…

---

<div class="post-metadata">

**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\
**Post date:** [August 27, 2020, 7:31pm UTC](https://community.glideapps.com/t/choose-last-value-in-single-value/14833/4 "2020-08-27T19:31:29Z")

</div>

That’s a perfect use case!