# Show comments in a list **URL:** \ **Category:** Ask for Help\ **Created:** [April 10, 2021, 6:31pm UTC](https://community.glideapps.com/t/show-comments-in-a-list/25398 "2021-04-10T18:31:05Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![MemBo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/membo/32/24362_2.png) [@MemBo](https://community.glideapps.com/u/MemBo)\ **Post date:** [April 10, 2021, 6:31pm UTC](https://community.glideapps.com/t/show-comments-in-a-list/25398/1 "2021-04-10T18:31:05Z")
Hi I try to allow a lot of interaction in my app. So people can post their ideas and other can comment. As this is done in different sections, it is difficult for user to keep track what is going on where. So I added a list on the start screen to who the four newest entires. I tried to do the same with the comments. It is nice to see a list of the comments in my google sheet - but I cannot use it to create a list with the entries. Any idea how I could solve that? Thanks Boris ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 10, 2021, 9:47pm UTC](https://community.glideapps.com/t/show-comments-in-a-list/25398/2 "2021-04-10T21:47:28Z")
The comments component is set to display all comments of a particular topic that you define. As long as you use the same topic, the comments should appear on every screen. ---
**Author:** ![MemBo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/membo/32/24362_2.png) [@MemBo](https://community.glideapps.com/u/MemBo)\ **Post date:** [April 11, 2021, 1:21pm UTC](https://community.glideapps.com/t/show-comments-in-a-list/25398/3 "2021-04-11T13:21:02Z")
Thank @Robert_Petitto I try to list all comments in a separate list. Glide lists the comments in a separate spreadsheet. But I can not use these entries to create a list or to further work with them. If you have people posting stuff and other comment on it, then one always has to go back to the original post. That is why I wanted to have a separate list to show the newest comments in order to point people to these posts and further contribute ---
**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:** [April 11, 2021, 1:35pm UTC](https://community.glideapps.com/t/show-comments-in-a-list/25398/4 "2021-04-11T13:35:09Z")
> [@MemBo](#): > > I try to list all comments in a separate list. Glide lists the comments in a separate spreadsheet. But I can not use these entries to create a list or to further work with them. No, but you can make a read-only copy of the `App: Comments` sheet and use that in your app. ---
**Author:** ![MemBo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/membo/32/24362_2.png) [@MemBo](https://community.glideapps.com/u/MemBo)\ **Post date:** [April 11, 2021, 1:40pm UTC](https://community.glideapps.com/t/show-comments-in-a-list/25398/5 "2021-04-11T13:40:33Z")
That sounds like a plan. How do I do that in order that it stays dynamic and lists all entries? ---
**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:** [April 11, 2021, 1:44pm UTC](https://community.glideapps.com/t/show-comments-in-a-list/25398/6 "2021-04-11T13:44:43Z")
You can use an arrayformula. Something like this: ```auto =ARRAYFORMULA(IF('App: Comments'!A1:F="","",'App: Comments'!A1:F)) ``` ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 11, 2021, 3:49pm UTC](https://community.glideapps.com/t/show-comments-in-a-list/25398/7 "2021-04-11T15:49:05Z")
You’d have to use an array formula to bring those comment rows into a new sheet that Glide can view within the app. Perfectly possible but will eat into your row quota ---
**Author:** ![MemBo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/membo/32/24362_2.png) [@MemBo](https://community.glideapps.com/u/MemBo)\ **Post date:** [April 12, 2021, 7:52am UTC](https://community.glideapps.com/t/show-comments-in-a-list/25398/8 "2021-04-12T07:52:36Z")
the row quota is not a problem - but I wonder how I can link the comments back to the original entries? And what is the advantage of the array formula to an ordinary reference to the cell? ---
**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:** [April 12, 2021, 7:58am UTC](https://community.glideapps.com/t/show-comments-in-a-list/25398/9 "2021-04-12T07:58:07Z")
The advantage of an arrayformula is that it automatically expands as new rows are added to the source sheet. If you were using direct cell references, you’d have to add a new formula row in the target sheet every time a new comment is added. ---
**Author:** ![MemBo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/membo/32/24362_2.png) [@MemBo](https://community.glideapps.com/u/MemBo)\ **Post date:** [April 12, 2021, 7:59am UTC](https://community.glideapps.com/t/show-comments-in-a-list/25398/10 "2021-04-12T07:59:55Z")
Great, that helps. Thanks @Darren_Murphy do you have an idea how I can link the comments back to the original entries? ---
**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:** [April 12, 2021, 8:11am UTC](https://community.glideapps.com/t/show-comments-in-a-list/25398/11 "2021-04-12T08:11:24Z")
You can link by the Topic. But it kind of depends what you are trying to with them. You can display these as an inline list and filter and sort them however you want. But if you’re wanting to use these as a drop in replacement for the actual comments component, that won’t work. ---
**Author:** ![MemBo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/membo/32/24362_2.png) [@MemBo](https://community.glideapps.com/u/MemBo)\ **Post date:** [April 12, 2021, 10:05am UTC](https://community.glideapps.com/t/show-comments-in-a-list/25398/12 "2021-04-12T10:05:50Z")
> [@Darren\_Murphy](#): > > `=ARRAYFORMULA(IF('App: Comments'!A1:F="","",'App: Comments'!A1:F))` > [@Darren\_Murphy](#): > > You can link by the Topic. works perfect! Thanks again. Another question: The app: comment Table lists the username of the one commenting. Where can I assess this information? all my user have to login via email-address. I have a table to save all this info. But it does not record the Username there. Any idea? ---
**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:** [April 12, 2021, 10:23am UTC](https://community.glideapps.com/t/show-comments-in-a-list/25398/13 "2021-04-12T10:23:04Z")
> [@MemBo](#): > > The app: comment Table lists the username of the one commenting. Where can I assess this information? all my user have to login via email-address. I have a table to save all this info. But it does not record the Username there. Any idea? As far as I’m aware, it would use whichever column you defined for Name in your [User Profiles](https://docs.glideapps.com/all/reference/security-and-per-user-data/user-profiles) configuration ---
**Author:** ![MemBo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/membo/32/24362_2.png) [@MemBo](https://community.glideapps.com/u/MemBo)\ **Post date:** [April 12, 2021, 11:16am UTC](https://community.glideapps.com/t/show-comments-in-a-list/25398/14 "2021-04-12T11:16:33Z")
ok, thanks