# Unread comments of a post

**URL:** <https://community.glideapps.com/t/unread-comments-of-a-post/29566>\
**Category:** Ask for Help\
**Created:** [July 26, 2021, 2:38pm UTC](https://community.glideapps.com/t/unread-comments-of-a-post/29566 "2021-07-26T14:38:37Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sidney\_Kunst](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sidney_kunst/32/603_2.png) [@Sidney\_Kunst](https://community.glideapps.com/u/Sidney_Kunst)\
**Post date:** [July 26, 2021, 2:38pm UTC](https://community.glideapps.com/t/unread-comments-of-a-post/29566/1 "2021-07-26T14:38:37Z")

</div>

Does anyone have a way to show unread comments. On top, or in a inline list…

So you have a post like News where you can add a comment with the comment component.

But comments are logged in an invisible table.

How can you show in which news-item a visitor has unread comments?! (while using a **glide table** for the news items)

---

<div class="post-metadata">

**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\
**Post date:** [July 26, 2021, 7:11pm UTC](https://community.glideapps.com/t/unread-comments-of-a-post/29566/2 "2021-07-26T19:11:00Z")

</div>

Hola @Sidney_Kunst

Would this help?

 ![Screen Shot 2021-07-26 at 2.10.25 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/2/e2d2518958ea31bf062b4f308bab9e8a771eeb91.png)

---

<div class="post-metadata">

**Author:** ![Sidney\_Kunst](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sidney_kunst/32/603_2.png) [@Sidney\_Kunst](https://community.glideapps.com/u/Sidney_Kunst)\
**Post date:** [July 26, 2021, 8:43pm UTC](https://community.glideapps.com/t/unread-comments-of-a-post/29566/3 "2021-07-26T20:43:38Z")

</div>

No, these are the posts. Here want to show an “unread” notice on the posts.

 ![Screenshot_20210726-223801_Chrome](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/5/f5e3761263a57229d56f6cdac518ae8aa5332fbd.jpeg)

When you open it, it shows a screen with comments.

 ![Screenshot_20210726-223933_Chrome](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/1/41714a21b5eec4a3f21ed1c5f48960d4152b4436.jpeg)

The problem is I used a glide table for the posts. I can’t relate this to the invisible log in the spreadsheet.

I guess i have to rebuild the glide table to a spreadsheet table. Because I cant convert or duplicate the table 🙁

With a spreadsheet table a can lookup the invisible comments log and build the function. I just hoped someone did it with glidetables

---

<div class="post-metadata">

**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\
**Post date:** [July 26, 2021, 9:15pm UTC](https://community.glideapps.com/t/unread-comments-of-a-post/29566/4 "2021-07-26T21:15:04Z")

</div>

if you want to have a “Not Read” tag or something, take a look at this [post](https://community.glideapps.com/t/actions/18026/8). So you have an idea on how to do it.

---

<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 26, 2021, 11:49pm UTC](https://community.glideapps.com/t/unread-comments-of-a-post/29566/5 "2021-07-26T23:49:33Z")

</div>

I’m leaving my idea here to see if it helps. You don’t necessarily need to convert this to Google Sheets.

Your comments are writing to the App: Comments sheet. To make it visible to Glide, use an Arrayformula like.

```auto
={'App: Comments'!A:Z}

```

This will copy the data to another sheet and make it a table in Glide, of course this comes at the expense of a lot more rows.

Next, assuming your comment has a relation to the post by the post’s row ID, create a multiple relation from the Post sheet to the Comments sheet, return the latest timestamp of comments.

In the inline list of your post, add an action that sets the “current timestamp” to a user-specific column whenever your users views a post.

If the “last visit” is before the latest comment timestamp then that post can be marked as “with unread comments” or something along those lines.

---

<div class="post-metadata">

**Author:** ![Sidney\_Kunst](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sidney_kunst/32/603_2.png) [@Sidney\_Kunst](https://community.glideapps.com/u/Sidney_Kunst)\
**Post date:** [July 27, 2021, 8:37am UTC](https://community.glideapps.com/t/unread-comments-of-a-post/29566/6 "2021-07-27T08:37:20Z")

</div>

Yeah, I thought of some flow like this, so no glide table’s sollution 😛 I’m going to duplicate the table to a google table. After that I can do a lookup inside google sheets to the comments tab.

Too bad I can’t copy all the computed columns of the glide table to the google sheet (in glide) 😭
