Hi everyone,
I’m building out a project management dashboard using the Softr Native Database as the backend (which I’ve found great for performance!). I’m running into a crucial roadblock when it comes to reporting on filtered data within a Table block.
The Desired Functionality
When a user applies a filter (via the search bar or filter menus) to a Table block, I want to display key aggregate data—like the SUM of a numerical column or the AVERAGE of a cost field—for ONLY the records currently visible in the filtered set.
Example Use Case: I have a Table Block showing tasks. This table includes a numerical field like Estimated Hours.
-
A user filters the table by
Project Status: Completed. -
I need a display element (e.g., a simple value block or a custom card) to update instantly and show the Total Sum of Estimated Hours for only those Completed tasks.
The Airtable/Spreadsheet Comparison
In tools like Airtable, this is handled automatically via the summary bar. The aggregate functions update in real-time as the view changes.
The Softr Challenge
Currently, if I use a simple List Details or Value block, it seems to only calculate the SUM or AVERAGE based on the entire dataset, regardless of what is currently filtered and displayed in the Table Block on the front end.
Has anyone successfully found a way to replicate this “Summary on Filtered Set” functionality using the Softr Native Database?
I’m open to:
-
No-Code Solutions: Am I missing a setting in the Table Block or a way to link a Value block to the filtered output?
-
Custom Code Workarounds: Is there a standard custom JavaScript approach to read the currently visible rows in the Table block and calculate a sum/average dynamically?
-
API/Zapier: If the filtering happens client-side, is the only solution to re-query the database via an API based on the filter inputs?
Any insights, tips, or examples from users who have tackled this reporting challenge would be highly appreciated!
Thanks!