Hello Glide Community,
I have a work management app with two main tables: Work Orders and Categories. There’s a relation set up from the Categories table to the Work Orders table using Row IDs, which I’m using to calculate a rollup count of how many work orders are associated with each category.
Additionally, I’ve formatted the date field in the Work Orders table to show as “Month - Year” (e.g., April - 2025), and I’m using a lookup column to display this formatted date in the Categories table. So far, everything is working well.
The issue arises when I apply a default list or table layout filter (using the inlist component) to filter work orders—for example, by a specific month. The rollup count still reflects the total number of related work orders regardless of the applied filter. What I want is for the rollup count to dynamically update based on the filtered list (e.g., only show counts for filtered month/year).
Is there a way to achieve dynamic rollup counts that respond to user-applied filters in the list or table view?
Thank you in advance for your support!
Best regards,
