# How to calculate a user's timestamp to compare the last visit to the newsfeed when the newsfeed is upadated?
**URL:** https://community.glideapps.com/t/how-to-calculate-a-users-timestamp-to-compare-the-last-visit-to-the-newsfeed-when-the-newsfeed-is-upadated/76208
**Category:** Ask for Help
**Created:** [September 7, 2024, 2:22pm UTC](https://community.glideapps.com/t/how-to-calculate-a-users-timestamp-to-compare-the-last-visit-to-the-newsfeed-when-the-newsfeed-is-upadated/76208 "2024-09-07T14:22:32Z")
**Posts on this page:** 11
**Page:** 1
### Author:  [@Dimitri\_Kostis](https://community.glideapps.com/u/Dimitri_Kostis)
#### Post date: [September 7, 2024, 2:22pm UTC](https://community.glideapps.com/t/how-to-calculate-a-users-timestamp-to-compare-the-last-visit-to-the-newsfeed-when-the-newsfeed-is-upadated/76208/1 "2024-09-07T14:22:32Z")
I want to do what the shame thing as the boy of the screenshot but i dont know how,
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [September 7, 2024, 3:02pm UTC](https://community.glideapps.com/t/how-to-calculate-a-users-timestamp-to-compare-the-last-visit-to-the-newsfeed-when-the-newsfeed-is-upadated/76208/2 "2024-09-07T15:02:15Z")
You’re right. You have to calculate timestamps. You have to compare a user specific timestamp to the last posts timestamp. That user specific time stamp needs to be recorded upon the user actually doing something, like clicking on that thread or entering into a detail screen. Then you create an if then else column in the database that shows either the most recent message or a notification that there are new messages and display that as the description for that collection.
---
### Author:  [@Dimitri\_Kostis](https://community.glideapps.com/u/Dimitri_Kostis)
#### Post date: [September 7, 2024, 3:05pm UTC](https://community.glideapps.com/t/how-to-calculate-a-users-timestamp-to-compare-the-last-visit-to-the-newsfeed-when-the-newsfeed-is-upadated/76208/4 "2024-09-07T15:05:30Z")
Man you are my hero!
I have a tap open right now with 10 videos made by you to find a solution about this… what a legend!!!
Can you suggest one of your videos to doing that??? \<3
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [September 7, 2024, 3:38pm UTC](https://community.glideapps.com/t/how-to-calculate-a-users-timestamp-to-compare-the-last-visit-to-the-newsfeed-when-the-newsfeed-is-upadated/76208/5 "2024-09-07T15:38:56Z")
Hm. Not sure if I have one that showcases this. Let me check.
---
### Author:  [@Dimitri\_Kostis](https://community.glideapps.com/u/Dimitri_Kostis)
#### Post date: [September 7, 2024, 4:58pm UTC](https://community.glideapps.com/t/how-to-calculate-a-users-timestamp-to-compare-the-last-visit-to-the-newsfeed-when-the-newsfeed-is-upadated/76208/6 "2024-09-07T16:58:17Z")
at least a video with the closest example that was very helpful 🙂
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [September 7, 2024, 5:15pm UTC](https://community.glideapps.com/t/how-to-calculate-a-users-timestamp-to-compare-the-last-visit-to-the-newsfeed-when-the-newsfeed-is-upadated/76208/7 "2024-09-07T17:15:21Z")
I can create one later today. I’m away from my computer at the moment.
---
### Author:  [@Dimitri\_Kostis](https://community.glideapps.com/u/Dimitri_Kostis)
#### Post date: [September 7, 2024, 5:28pm UTC](https://community.glideapps.com/t/how-to-calculate-a-users-timestamp-to-compare-the-last-visit-to-the-newsfeed-when-the-newsfeed-is-upadated/76208/8 "2024-09-07T17:28:31Z")
wow… that’s fantastic!!! thanks a lots bro \<3
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [September 7, 2024, 8:26pm UTC](https://community.glideapps.com/t/how-to-calculate-a-users-timestamp-to-compare-the-last-visit-to-the-newsfeed-when-the-newsfeed-is-upadated/76208/9 "2024-09-07T20:26:16Z")
As promised:
https://www.loom.com/embed/7642c923b16b4ce2ac22598857ee6b04
---
### Author:  [@Dimitri\_Kostis](https://community.glideapps.com/u/Dimitri_Kostis)
#### Post date: [September 8, 2024, 10:52pm UTC](https://community.glideapps.com/t/how-to-calculate-a-users-timestamp-to-compare-the-last-visit-to-the-newsfeed-when-the-newsfeed-is-upadated/76208/10 "2024-09-08T22:52:13Z")
Sorry for the late reply…
Since I’m a few weeks into “no code” it took me a few hours to find the way and I finally did it, thanks to you Legend!!!
now i am ready to open the app in few months…
YOU ARE GOD!!! THANK YOU!!!
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [September 9, 2024, 12:26am UTC](https://community.glideapps.com/t/how-to-calculate-a-users-timestamp-to-compare-the-last-visit-to-the-newsfeed-when-the-newsfeed-is-upadated/76208/11 "2024-09-09T00:26:27Z")
Happy to help!
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [September 16, 2024, 12:26am UTC](https://community.glideapps.com/t/how-to-calculate-a-users-timestamp-to-compare-the-last-visit-to-the-newsfeed-when-the-newsfeed-is-upadated/76208/12 "2024-09-16T00:26:28Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.