How to get the count of filtered records using AppSheet’s built-in table filter?

AppSheet AppSheet Q&A
1

Hello AppSheet Community,

I’m trying to find a way to get the count of records displayed after applying a filter using AppSheet’s built-in table filter button (the one in Table View).

For example, when I apply a filter (e.g., Type = “FANTOME, FABRIQUE”), AppSheet filters the table dynamically, but I don’t see an option to retrieve and display the number of records returned by this filter.

I made a custom filter view where users can filter data from specified fields, giving them more flexibility. In this view, I was able to add a count of the records returned. However, I now want to combine my custom filtering system with AppSheet’s built-in filter button so that:

  • The count updates to reflect both the built-in filter and my custom filter.
  • The total sum of records returned from both filtering methods is displayed.

My Questions:

  1. Is there a way to access the filtered count after applying a filter via the built-in filter button?
  2. How can I cascade my custom filter system with AppSheet’s built-in filter so they work together?
  3. Is there any workaround to sum up the total number of records returned by both filters?

Any insights or suggestions would be greatly appreciated! Thanks in advance.

Best regards.

2

  1. Nope.

  2. Not possible.

  3. Nope.

3 Likes
3

Thank you for taking the time to respond. Much appreciated!

1 Like
4

Actually.. if you have e.g. a virtual column with an expresion “The total count:”, you group the table view with this column and you select “Count” with the "Group Aggregate, it will show the count after both of these filters.

2 Likes
5

Wow, AleksiAlkio, you are an absolute genius! ? :fire:

This solution worked like a charm, and I can’t believe how simple yet incredibly effective it is! You just dropped a brilliant hack that solves the problem perfectly.

Massive thank you for your insight and creativity! :raising_hands:

2 Likes
6

Actually.. it’s not a hack, just a simple solution :slightly_smiling_face:

4 Likes