# Sort by recently updated?

**URL:** <https://community.glideapps.com/t/sort-by-recently-updated/12031>\
**Category:** Ask for Help\
**Created:** [July 6, 2020, 6:19am UTC](https://community.glideapps.com/t/sort-by-recently-updated/12031 "2020-07-06T06:19:51Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![dougburnett](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dougburnett/32/10220_2.png) [@dougburnett](https://community.glideapps.com/u/dougburnett)\
**Post date:** [July 6, 2020, 6:19am UTC](https://community.glideapps.com/t/sort-by-recently-updated/12031/1 "2020-07-06T06:19:51Z")

</div>

Hello. LOVE Glideapps. We’re staying in touch as a very extended family (300+ people). We’re sharing an update on each household for this year. I’d love to sort the data in a tab by the most recently updated one. Is that possible?

---

<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:** [July 6, 2020, 7:42am UTC](https://community.glideapps.com/t/sort-by-recently-updated/12031/2 "2020-07-06T07:42:23Z")

</div>

Hi Doug,

For that to work, you have to get a column for the timestamp of the last update. I take it you don’t have one at the moment, what’s your data structure like as of now?

---

<div class="post-metadata">

**Author:** ![dougburnett](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dougburnett/32/10220_2.png) [@dougburnett](https://community.glideapps.com/u/dougburnett)\
**Post date:** [July 6, 2020, 5:23pm UTC](https://community.glideapps.com/t/sort-by-recently-updated/12031/3 "2020-07-06T17:23:04Z")

</div>

Thank you for the reply. I don’t have a timestamp setup right now. Does that happen via a script in Google Sheets, or is that a feature inside of Glideapp?

I have a row for each Household and a column labeled 2020 Update. Anyone with the app can edit the 2020 Update with an Edit Note component. I’d love to add a timestamp in a new column when the Edit Note component is edited.

Thanks

![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/d1b8613998ba0a89b32bfb7a2a1eedaa9dd55529.png)

---

<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:** [July 6, 2020, 5:34pm UTC](https://community.glideapps.com/t/sort-by-recently-updated/12031/4 "2020-07-06T17:34:26Z")

</div>

You can do that with the date/time special value in Add, Edit, or form mode. If you are only using a notes component on a View screen, then there is no way withing Glide to track the date. You would have to do something using a script.

> **[Current date/time](https://docs.glideapps.com/all/reference/privacy-and-per-user-data/special-values/current-date-time)**
>
> Submit the current date and time

---

<div class="post-metadata">

**Author:** ![dougburnett](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dougburnett/32/10220_2.png) [@dougburnett](https://community.glideapps.com/u/dougburnett)\
**Post date:** [July 6, 2020, 5:47pm UTC](https://community.glideapps.com/t/sort-by-recently-updated/12031/5 "2020-07-06T17:47:23Z")

</div>

Thanks Jeff. I’ll look into a Google Sheet script. If not, the Form makes sense and I’ll try using that.

![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/d1b8613998ba0a89b32bfb7a2a1eedaa9dd55529.png)