Hi everyone,
I’ve built a stock management app in Glide where customers can view how many bikes they’ve sold. Right now, I can show the total number of bikes ever sold using a rollup column.
However, I’d like to display only the number of bikes sold in the current month, or example: “Bikes sold in July”.
Does anyone know the best way to achieve this in Glide?
I imagine it involves filtering the sales by date, but I’m unsure how to do that within a rollup or relation that only includes sales from the current month.
Any help or step-by-step advice would be greatly appreciated!
Thanks in advance 
If you create a relation or query that only returns data for a specific date range, then your rollup can use the relation or query instead of pointing to the entire table
1 Like
Thanks! That makes sense.
But my issue is: in the Query column, there’s no option to filter by something like “this month” dynamically. It only lets me set fixed values like “August” or “2025”.
So how can I make sure the query or relation automatically updates based on the current month, without having to manually adjust it each time?
Is there a workaround for that?
Create a math column in your User Profile table using the following formula:
Now
- Day(Now)
- Hour(Now)/24
- Minute(Now)/1440
- Second(Now)/86400
+ 1
In the above, Now should be replaced with the special “Now” value, which provides the current date & time.
You can then reference that column in your query filter.
4 Likes
