# How do you Gather and display in App Notifications across different sheets chronologically in the same inline list? **URL:** \ **Category:** Ask for Help\ **Created:** [March 7, 2022, 10:09pm UTC](https://community.glideapps.com/t/how-do-you-gather-and-display-in-app-notifications-across-different-sheets-chronologically-in-the-same-inline-list/39360 "2022-03-07T22:09:37Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Butter-Bee](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/butter-bee/32/15102_2.png) [@Butter-Bee](https://community.glideapps.com/u/Butter-Bee)\ **Post date:** [March 7, 2022, 10:09pm UTC](https://community.glideapps.com/t/how-do-you-gather-and-display-in-app-notifications-across-different-sheets-chronologically-in-the-same-inline-list/39360/1 "2022-03-07T22:09:37Z")
Hey Gliders, I built an initial ‘inline list’ notification tab for users to see when someone becomes their friend, since then I’ve added additional features and corresponding notifications. NOW, I’d like to aggregate the currently disparate notifications (from friend invites, community invites, etc.) into one ‘inline list’ that is able to display them chronologically, from latest to oldest. **Has anyone done this? Or know how I might be able to approach this?** For now I’m currently using a google sheet query, =QUERY({Users!A2:E;Events!A2:E;Communities!A2:E},“SELECT \* WHERE Col1 is not null”) But not sure if this will be able to create the end result I have in mind, but I’m making a go at it…ATM. ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [March 7, 2022, 10:35pm UTC](https://community.glideapps.com/t/how-do-you-gather-and-display-in-app-notifications-across-different-sheets-chronologically-in-the-same-inline-list/39360/2 "2022-03-07T22:35:52Z")
Are you trying to combine multiple columns in GSheet into one column? ---
**Author:** ![Butter-Bee](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/butter-bee/32/15102_2.png) [@Butter-Bee](https://community.glideapps.com/u/Butter-Bee)\ **Post date:** [March 7, 2022, 10:59pm UTC](https://community.glideapps.com/t/how-do-you-gather-and-display-in-app-notifications-across-different-sheets-chronologically-in-the-same-inline-list/39360/3 "2022-03-07T22:59:09Z")
Im trying to add content from multiple sheets into one master sheet. But then display contextual data back about depending on the sheet it came from ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [March 7, 2022, 11:16pm UTC](https://community.glideapps.com/t/how-do-you-gather-and-display-in-app-notifications-across-different-sheets-chronologically-in-the-same-inline-list/39360/4 "2022-03-07T23:16:24Z")
> [@Butter-Bee](#): > > NOW, I’d like to aggregate the currently disparate notifications (from friend invites, community invites, etc.) into one ‘inline list’ In order to have one inline list it would have to be combined into one column… unless I’m missing something. Here’s what I do… I start with a helper tab that is not connected to Glide in anyway and use `=flatten` `={"Combine";flatten(Sheet1!A2:A,Sheet2!B2:B,Sheet3!E2:E)}` Then a filter formula in the destination sheet where we want to display our inline list. I target that new ‘Combine’ column in the Helper Tab. `=filter(HelperTab!A2:A,HelperTab!A2:A<>"")` I’m not 100% where to go from here but could probably get the rest done with vlookups in GSheet and an ITE column in glide… or a bunch of relations, lookups, and finally an ite column in glide. I’m curious to know how the experts would approach this because this is a fundamental part of my app. ---
**Author:** ![Butter-Bee](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/butter-bee/32/15102_2.png) [@Butter-Bee](https://community.glideapps.com/u/Butter-Bee)\ **Post date:** [March 8, 2022, 12:37am UTC](https://community.glideapps.com/t/how-do-you-gather-and-display-in-app-notifications-across-different-sheets-chronologically-in-the-same-inline-list/39360/5 "2022-03-08T00:37:53Z")
Thanks @Eric_Penn. I’m with you and would love to see an example or hear an approach for what needs to happen on the Glide end of things to get it to display well. ---
**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:** [March 8, 2022, 1:36am UTC](https://community.glideapps.com/t/how-do-you-gather-and-display-in-app-notifications-across-different-sheets-chronologically-in-the-same-inline-list/39360/6 "2022-03-08T01:36:13Z")
I would have a Master sheet with 3 columns: RowID, Title & Timestamp. Then you can leverage a stacked query formula. Please see the example Master sheet: > **[Notifications Example](https://docs.google.com/spreadsheets/d/1t_54RvPPENoGi5vEqnPpQ7NuhseMcbZNvqWGUYafKlg/edit#gid=2052587289)** > > Friends Notification > > RowID,Title,Timestamp,Type > Friends001,Friend 1,3/2/2022 8:34:06,Friends > Friends002,Friend 2,3/7/2022 8:34:06,Friends > Friends003,Friend 3,3/6/2022 8:34:06,Friends Finally, in Glide, you can sort the notification using the timestamp column, filter the list based on the email column. ---
**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:** [March 8, 2022, 3:33am UTC](https://community.glideapps.com/t/how-do-you-gather-and-display-in-app-notifications-across-different-sheets-chronologically-in-the-same-inline-list/39360/7 "2022-03-08T03:33:16Z")
> [@Butter-Bee](#): > > For now I’m currently using a google sheet query, > =QUERY({Users!A2:E;Events!A2:E;Communities!A2:E},“SELECT \* WHERE Col1 is not null”) > But not sure if this will be able to create the end result I have in mind, but I’m making a go at it…ATM. Not sure if this makes sense, but wouldn’t this be a whole lot easier if you put them all in the same table to begin with? 🤔 ---
**Author:** ![Butter-Bee](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/butter-bee/32/15102_2.png) [@Butter-Bee](https://community.glideapps.com/u/Butter-Bee)\ **Post date:** [March 8, 2022, 4:15am UTC](https://community.glideapps.com/t/how-do-you-gather-and-display-in-app-notifications-across-different-sheets-chronologically-in-the-same-inline-list/39360/8 "2022-03-08T04:15:06Z")
It would! but the content type that the notifications correspond with are vastly different. ---
**Author:** ![Butter-Bee](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/butter-bee/32/15102_2.png) [@Butter-Bee](https://community.glideapps.com/u/Butter-Bee)\ **Post date:** [March 8, 2022, 4:16am UTC](https://community.glideapps.com/t/how-do-you-gather-and-display-in-app-notifications-across-different-sheets-chronologically-in-the-same-inline-list/39360/9 "2022-03-08T04:16:55Z")
Thank you! I’ll try out this variation of the formula. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [March 9, 2022, 11:41pm UTC](https://community.glideapps.com/t/how-do-you-gather-and-display-in-app-notifications-across-different-sheets-chronologically-in-the-same-inline-list/39360/10 "2022-03-09T23:41:54Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.