Hello, I try to figure out how to keep the number of filtered collection items in a variable so I can present this number to the user. When checking the value of the total number of filtered items it shows 3 - this is the collection list formula. [image] When I try “All jobs.total” it shows 6. T…

Ok, with the filters set up as they are on the Collection List in the page, you could do it in Javascript but it’s not currently doable in no-code. A no-code workaround you might try: apply the filters at Collection level and use a workflow to refetch the Collection on Change. It’s what we did to b…

Hi @Cichy , There are two ways you could do this: 1- you could add the filter at collection level in the “Data” menu so that the length of array on the page would include only the filtered data. In that case, you would need to add a workflow action to refetch the collection on the page whenever a u…

Hello Joyce, thank you for such a rich explanation! I am not sure if it is my use case. I have two search fields - one for position and one for location and the list is dynamically filtered once the fields are filled: [image] So as far as I understand, I can use filterbyKey if had predetermined p…

This is the example of list when search fields are filled (only 2 positions visible) [image]

Ha! Great point! You should be able to apply a similar logic with the contains formula: [Screenshot 2022-04-04 at 12.59.07] In your case, the formula might get a bit complex since you have two search fields but it should be doable :slight_smile: The idea is that you want to bind the “20 Results”…

Hello, I guess it makes sense, but I doubt I can do it … I need some kind of a loop to iterate over the whole collection and invoke “contains” on every collection item, count “Trues” and return the number? Maybe I should just share my project :slight_smile: … Is it ok to post a link to the workspac…

Sure, go for it! :slight_smile: I’ll take a look asap

Hi @Cichy ! Just had a look but got stuck because the contains formula seems to look for an exact match (for example if the user searches for “Manager”, it wouldn’t return the “HR Manager” item). I’m tapping into our dev teams knowledge to help us out :slight_smile:

Hello Joyce. It works :). I performed kinda stress testing of this solution. Mocked about 5000 records in Xano and added two filter groups on Collection level (two search fields triggering refetching on change). No filtering on backend. And to my surprise, it is working quite acceptable (like 2-3 s…

Awesome! That’s great to hear :slight_smile:

Number of filtered items

Ask us anything

RCS March 16, 2023, 9:14pm 13

Hi Joyce, do you have another workaround in mind other than a lengthy formula? My collection list has 15 filters, which will be extremely lengthy to put into a formula.

Topic		Replies	Views
Length of Filtered List via Javascript Ask us anything	6	482	July 18, 2023
What item # in a collection am I in? Ask us anything binding	14	790	December 14, 2022
How to get a number of items in a filtered data grid? How do I? filter , data-grid	2	445	November 27, 2023
Collection Length After Filtering How do I?	1	184	June 17, 2023
How do I filter when specifying a field? Ask us anything	5	521	August 16, 2022

Number of filtered items

Related topics