How to show how many items I'm viewing

NCD
Silver 2
Silver 2

I am making an inventory app, and would like to know how many items I have/ viewing when I'm filtering how can I do this?

0 3 80
3 REPLIES 3

Aurelien
Google Developer Expert
Google Developer Expert

Hi @NCD 

 

This is not possible directly, unless using a workaround with a filter using a slice.

NCD
Silver 2
Silver 2

@Aurelien 

Thank you.

I would like to give it a try, how exactly would I filter this?

Aurelien
Google Developer Expert
Google Developer Expert

You can try this:

https://www.appsheet.com/templates/How-to-search-with-a-Slice--Dashboard?appGuidString=7e3e1bed-6576...

or this (same idea)

https://www.appsheet.com/templates/Allow-the-user-to-filter-a-view-based-on-a-form?appGuidString=912...

 

Based on these mechanisms, you will need to create a virtual column that will count the number of items that match your conditions.

The expression will be:

 

COUNT(yourSliceFilterName[yourKeyColumn])

 

For reference:

https://help.appsheet.com/en/articles/2347641-count

 

Top Labels in this Space