# 🗓️ Dynamically filter an inline list by TIMEFRAME (Parts 1 & 2)! **URL:** \ **Category:** Community Resources\ **Tags:** tutorial\ **Created:** [June 2, 2022, 6:20pm UTC](https://community.glideapps.com/t/dynamically-filter-an-inline-list-by-timeframe-parts-1-2/42671 "2022-06-02T18:20:31Z")\ **Posts on this page:** 20\ **Page:** 1
**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:** [June 2, 2022, 6:20pm UTC](https://community.glideapps.com/t/dynamically-filter-an-inline-list-by-timeframe-parts-1-2/42671/1 "2022-06-02T18:20:32Z")
# 👋 Hey fellow Gliders! In this video, learn how to dynamically filter a list of records by timeframes (day, week, month, etc.) using a Choice component, some Math columns and a Make Array column. Also features the concept of a “Work Table” to keep your data tables lean! ### 🍿 Enjoy! #### Part 1 [![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/8/28d5068b6f9bb5ce56f7485614bc352a4167f83a.jpeg "Glide: Dynamically Filter your Data by TIMEFRAMES (Part 1)") ](https://www.youtube.com/watch?v=pApLeMYHFzE) #### Part 2 [![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/0/407efc1f46f0c0d8207a5495c6473b4b0f30708b.jpeg "Glide: Dynamically Filter your Data by DATE RANGE (Part 2)") ](https://www.youtube.com/watch?v=AVSavEhdt6Y) ---
**Author:** ![Luther](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luther/32/17929_2.png) [@Luther](https://community.glideapps.com/u/Luther)\ **Post date:** [June 2, 2022, 7:02pm UTC](https://community.glideapps.com/t/dynamically-filter-an-inline-list-by-timeframe-parts-1-2/42671/2 "2022-06-02T19:02:54Z")
This is Gold Bob! Thanks for sharing 😊 ---
**Author:** ![justinjmp](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/justinjmp/32/43205_2.png) [@justinjmp](https://community.glideapps.com/u/justinjmp)\ **Post date:** [June 2, 2022, 7:14pm UTC](https://community.glideapps.com/t/dynamically-filter-an-inline-list-by-timeframe-parts-1-2/42671/3 "2022-06-02T19:14:11Z")
Amazing video! Thanks for sharing these tips and tricks! ---
**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [June 2, 2022, 7:49pm UTC](https://community.glideapps.com/t/dynamically-filter-an-inline-list-by-timeframe-parts-1-2/42671/4 "2022-06-02T19:49:52Z")
This is great. Thanks Robert. 👍 Just a thought 💭 maybe could also generate a ‘quickchart’ using the output of the filter. Need to play around to see if this is possible. ---
**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:** [June 2, 2022, 9:29pm UTC](https://community.glideapps.com/t/dynamically-filter-an-inline-list-by-timeframe-parts-1-2/42671/5 "2022-06-02T21:29:10Z")
Sure could! You could display a Glide Chart via the relation or create a quickchart via some join lists of the relation that eventually feed a construct URL column. ---
**Author:** ![Antonino\_Nolasco](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/antonino_nolasco/32/80601_2.png) [@Antonino\_Nolasco](https://community.glideapps.com/u/Antonino_Nolasco)\ **Post date:** [June 2, 2022, 10:43pm UTC](https://community.glideapps.com/t/dynamically-filter-an-inline-list-by-timeframe-parts-1-2/42671/6 "2022-06-02T22:43:23Z")
Great job Bob! But if I could select the filter about last month? I could duplicate date\_month column and add (-1) but if current month is January it doesn’t work, because math column display 202200. How can I do it? Thanks @Robert_Petitto ---
**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:** [June 2, 2022, 11:11pm UTC](https://community.glideapps.com/t/dynamically-filter-an-inline-list-by-timeframe-parts-1-2/42671/7 "2022-06-02T23:11:36Z")
Right…there are a couple options available. 1.) Write the value “Last Month” to a date time column. Use this as the basis for the filter. 2.) Do some crazier math that calculates a last month value Both are a bit complicated to explain in text. Stay tuned to part 2 of my video! ---
**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:** [June 3, 2022, 1:12am UTC](https://community.glideapps.com/t/dynamically-filter-an-inline-list-by-timeframe-parts-1-2/42671/8 "2022-06-03T01:12:19Z")
Nice use of the Make Array column there, Bob 👍 ---
**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:** [June 3, 2022, 1:18am UTC](https://community.glideapps.com/t/dynamically-filter-an-inline-list-by-timeframe-parts-1-2/42671/9 "2022-06-03T01:18:47Z")
> [@Rosewebstudio](#): > > Just a thought 💭 maybe could also generate a ‘quickchart’ using the output of the filter. Need to play around to see if this is possible. You mean like this? 😉 ---
**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:** [June 3, 2022, 1:47am UTC](https://community.glideapps.com/t/dynamically-filter-an-inline-list-by-timeframe-parts-1-2/42671/10 "2022-06-03T01:47:21Z")
> [@Darren\_Murphy](#): > > Nice use of the Make Array column there, Bob 👍 I knew you’d appreciate that 😄 ---
**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [June 3, 2022, 4:29am UTC](https://community.glideapps.com/t/dynamically-filter-an-inline-list-by-timeframe-parts-1-2/42671/11 "2022-06-03T04:29:53Z")
I knew you would come up with an example. Nice one…. 👏 ---
**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\ **Post date:** [June 3, 2022, 2:59pm UTC](https://community.glideapps.com/t/dynamically-filter-an-inline-list-by-timeframe-parts-1-2/42671/12 "2022-06-03T14:59:11Z")
It is as well great (nice work and explanation!) as proof that Glide can win a lot on making things easier (complicated!) 😉 ---
**Author:** ![Patrick\_Tardy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/patrick_tardy/32/43377_2.png) [@Patrick\_Tardy](https://community.glideapps.com/u/Patrick_Tardy)\ **Post date:** [June 8, 2022, 2:08pm UTC](https://community.glideapps.com/t/dynamically-filter-an-inline-list-by-timeframe-parts-1-2/42671/13 "2022-06-08T14:08:11Z")
Thanks for sharing that @Robert_Petitto And I also practise my English language (I am in France) Much better than Netflix 🙂 ---
**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:** [June 8, 2022, 2:17pm UTC](https://community.glideapps.com/t/dynamically-filter-an-inline-list-by-timeframe-parts-1-2/42671/14 "2022-06-08T14:17:58Z")
> [@Patrick\_Tardy](#): > > Much better than Netflix Hehe, Bobflix has always been good! ---
**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:** [June 8, 2022, 2:28pm UTC](https://community.glideapps.com/t/dynamically-filter-an-inline-list-by-timeframe-parts-1-2/42671/15 "2022-06-08T14:28:03Z")
> [@ThinhDinh](#): > > Bobflix Now there’s an app idea… ---
**Author:** ![Patrick\_Tardy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/patrick_tardy/32/43377_2.png) [@Patrick\_Tardy](https://community.glideapps.com/u/Patrick_Tardy)\ **Post date:** [June 8, 2022, 2:33pm UTC](https://community.glideapps.com/t/dynamically-filter-an-inline-list-by-timeframe-parts-1-2/42671/16 "2022-06-08T14:33:11Z")
You are already good at teasing the next episode : Dynamically filter Part 2 Can’t wait 😉 ---
**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:** [June 8, 2022, 11:40pm UTC](https://community.glideapps.com/t/dynamically-filter-an-inline-list-by-timeframe-parts-1-2/42671/17 "2022-06-08T23:40:01Z")
Series about different things in the Glide verse, recommendation for what is similar to watch (or next steps in the learning curve after the current video), categories, paywalled content? ---
**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:** [June 8, 2022, 11:41pm UTC](https://community.glideapps.com/t/dynamically-filter-an-inline-list-by-timeframe-parts-1-2/42671/18 "2022-06-08T23:41:20Z")
I don’t follow. Are these suggestions for new videos? ---
**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:** [June 8, 2022, 11:55pm UTC](https://community.glideapps.com/t/dynamically-filter-an-inline-list-by-timeframe-parts-1-2/42671/19 "2022-06-08T23:55:27Z")
No, for your Bobflix app. I was thinking if you convert your YouTube to an app Netflix-style it would have things like that. 😅 ---
**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:** [June 9, 2022, 12:26am UTC](https://community.glideapps.com/t/dynamically-filter-an-inline-list-by-timeframe-parts-1-2/42671/20 "2022-06-09T00:26:59Z")
Ahhhhh too true. Nice idea for sure…I’d have to promote a influx pretty heavily to get the same amount of exposure as YouTube tho 😵‍💫 [Next page](https://community.glideapps.com/t/dynamically-filter-an-inline-list-by-timeframe-parts-1-2/42671.md?page=2)