🗓️ Dynamically filter an inline list by TIMEFRAME (Parts 1 & 2)!

Community Resources
1

:wave: 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!

:popcorn: Enjoy!

Part 1

Part 2

23 Likes
2

This is Gold Bob!
Thanks for sharing :blush:

1 Like
3

Amazing video! Thanks for sharing these tips and tricks!

1 Like
4

This is great. Thanks Robert. :+1:

Just a thought :thought_balloon: maybe could also generate a ‘quickchart’ using the output of the filter. Need to play around to see if this is possible.

1 Like
5

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.

2 Likes
6

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

7

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!

1 Like
8

Nice use of the Make Array column there, Bob :+1:

9

You mean like this? :wink:

3 Likes
10

I knew you’d appreciate that :smile:

1 Like
11

I knew you would come up with an example. Nice one…. :clap:

12

It is as well great (nice work and explanation!) as proof that Glide can win a lot on making things easier (complicated!) :wink:

13

Thanks for sharing that @Robert_Petitto
And I also practise my English language (I am in France)
Much better than Netflix :slight_smile:

2 Likes
14

Hehe, Bobflix has always been good!

5 Likes
15

Now there’s an app idea…

3 Likes
16

You are already good at teasing the next episode : Dynamically filter Part 2
Can’t wait :wink:

3 Likes
17

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?

18

I don’t follow. Are these suggestions for new videos?

19

No, for your Bobflix app. I was thinking if you convert your YouTube to an app Netflix-style it would have things like that. :sweat_smile:

20

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 :face_with_spiral_eyes:

1 Like