# Filtered counts not working with external collections!

**URL:** <https://forum.adalo.com/t/filtered-counts-not-working-with-external-collections/13635>\
**Category:** Get Help\
**Created:** [June 10, 2021, 8:29pm UTC](https://forum.adalo.com/t/filtered-counts-not-working-with-external-collections/13635 "2021-06-10T20:29:18Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![claireconza](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/claireconza/32/7124_2.png) [@claireconza](https://forum.adalo.com/u/claireconza)\
**Post date:** [June 10, 2021, 8:29pm UTC](https://forum.adalo.com/t/filtered-counts-not-working-with-external-collections/13635/1 "2021-06-10T20:29:18Z")

</div>

Hi

Has anyone had issues with filtered counts not working with external collections?

The ‘all count’ works and shows 96 but when I apply a filter it shows zero when it should be 14.

It doesn’t matter whether the filter is based on magictext or a hardcoded text filter (with or without quotes around the filter term), it still returns zero.

Any ideas?

Thanks

Claire

 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/5/59cc94c1b00f3d6bf315b91d2059e821008ff6fa.jpeg)  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/d/dada8ac7b47ec177dcfc2cde550ddc62c9d7fa36.jpeg)  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/7/7c8cf441c1a801b3b13f7b3117a606c2389c98b4.jpeg)  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/4/42c50b1effa30f08c643cc13cfd521dfcd7adc16.png)  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/b/b88d23d3ca7eeb7c81a62d84ee38379519bfc669.png)

---

<div class="post-metadata">

**Author:** ![JL\_LJ](https://avatars.discourse-cdn.com/v4/letter/j/f08c70/32.png) [@JL\_LJ](https://forum.adalo.com/u/JL_LJ)\
**Post date:** [June 11, 2021, 12:31am UTC](https://forum.adalo.com/t/filtered-counts-not-working-with-external-collections/13635/2 "2021-06-11T00:31:18Z")

</div>

Hi,  
The filter does not work since you are using Airtable, so you are not applying in this case the “FilterByFormula” condition, this is an Adalo/Airtable limitation.

---

<div class="post-metadata">

**Author:** ![claireconza](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/claireconza/32/7124_2.png) [@claireconza](https://forum.adalo.com/u/claireconza)\
**Post date:** [June 11, 2021, 12:47am UTC](https://forum.adalo.com/t/filtered-counts-not-working-with-external-collections/13635/3 "2021-06-11T00:47:08Z")

</div>

Thanks JL\_LJ

is there a way I can use filterbyformula to arrive at the correct count? Not sure how to go about doing this - is it even possible?

Thanks

Claire

---

<div class="post-metadata">

**Author:** ![AddyEdwin](https://avatars.discourse-cdn.com/v4/letter/a/f0a364/32.png) [@AddyEdwin](https://forum.adalo.com/u/AddyEdwin)\
**Post date:** [June 11, 2021, 2:52am UTC](https://forum.adalo.com/t/filtered-counts-not-working-with-external-collections/13635/4 "2021-06-11T02:52:00Z")

</div>

I don’t think it’s possible either. I’ve tried doing it with my AIrtable collections, but coudn’t find a way yet.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/system/32/40401_2.png) [@system](https://forum.adalo.com/u/system)\
**Post date:** [June 21, 2021, 2:52am UTC](https://forum.adalo.com/t/filtered-counts-not-working-with-external-collections/13635/5 "2021-06-21T02:52:47Z")

</div>

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.