Glide: Dynamically Filter your Data by TIMEFRAMES (Part 1)

🚀 Creating your very own no code app with Glide is easy—get started today: https://glide.grsm.io/robert 👉 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! 💎Grab a copy of this app by becoming a Glide VIP member! https://www.youtube.com/channel/UCO9Yiy4Hi8vBzsJmsjgu-mQ/join 👔 Hire me to build your Glide app: https://glide.grsm.io/glideexpert 00:00 - Intro 00:42 - Create a "Work Table" 03:13 - Create User Specific Text Column that will store the selection 03:46 - Insert a Choice Component 04:05 - Add a table with a list of Timeframe Options 05:16 - Determine "Now" in the Work Table 06:11 - Explaining why I craft a numeric date value using a Math Column 07:06 - Creating a "Year" value 07:53 - Creating a "Month" value 09:08 - Creating a "Week" value 09:52 - Creating a "Day" value 10:58 - Creating the numeric date values in the Work Table 12:13 - Determining an "All Dates" value 13:49 - Add a "Make Array" column to combine all timeframes into an array 14:38 - Relate Time frame Selection to the Time Frames Array 15:27 - Create an Inline List sourced from the Timeframe Relation 16:03 - Oops! Fixing "This Month" logic by recalculating the "date_week" date value 17:44 - Summarize the timeframe by adding rollup columns 19:10 - Display the Summaries in a Basic Table 19:50 - RECAP!