Is there a way to show the user how many records are being portrayed in a list given the current filters? That would be amazing 
Thanks so much in advance!
1 Like
Just to be sure - are you talking about inline filters? So the record count would update when the user changed a filter value on the page? Something like ā27 matching recordsā?
And if so, what would you want it to display if the number of matching records exceeded the number of records per page? Show the number on the current page, or show the total number including pages not displayed?
Hey David,
Yes, exactly. Ideally, it shows the total amount of results in a list given the current inline filters, so that if no filters were set, the total amount of records is displayed. If the number of matching records exceeded the records per page, I would want to still show the total of all available records beyond the records currently portrayed.
Any way this is possible?
PS: Sorry for the late answer, I didnāt see the notification.
1 Like
I would also absolutely love this!
3 Likes
OK I thought some more about this.
Likely possible: custom code that shows the number of matching records from inline filters on the current page of results.
Likely not possible: display of the total number of matching records from inline filters including multiple pages of results.
Definitely impossible: display of the total number of records in the Airtable table
I believe these impossibilities are due to the fact that Airtableās API provides a cursor to enumerate a table, but doesnāt provide a total.
I think that these limitations mean itās not worth the effort to make this custom code, but Iād be curious to know what others think.
Interesting footnote: When Google Sheets is the data source, it is possible to get the total record count.
3 Likes
Aah dammit, thatās a pity! It would be really great UX to have such a function for large databases to show users what they are looking at. Thanks so much for looking into it, David!
2 Likes
Would love this as well. Could someone from Softr make a note of this as a feature request? 
2 Likes
@Fizzle we have noted this in our end. With Airtable API limitations we are currently not able to show the total number of resultsā¦ We are in talks with Airtable API to see if they can add this feature.
4 Likes
Just upvoting this - keep the pressure up on airtable! One of the more common requests from users.
2 Likes
+1
2 Likes
+1 here too
2 Likes
+1000
1 Like
The reason we are not able to do it is a bit related to datasourcesā¦ e.g. Airtable is not enabling us to get the total number of records from a table.
Is there no workaround at all on Softrās side? For instance, via the āSee Moreā button or so to count how often it is clickable and then multiplying by records per view?
Itās not exactly a workaround, but something weāve done with Airtable is to create a separate table with summary statistics describing the original table. It can calculate numbers such as the total count of records, and counts for a few subcategories (eg location=France), the maximum timestamp among the records, etc. In Softr, these summary statistics get displayed in a āSummary cards blockā that appears above the table.
Setting it up was somewhat tricky, involving linking records between the original table and the summary table. Here is an intro: All You Need to Know about Airtableās Rollup Feature (in 2024) - Bannerbear
And in the future, with a SQL backend this kind of thing should be possible. Another reason to look forward to Softr supporting SQL data sources.