# Issue calculating counts with AirTable integration

**URL:** <https://forum.adalo.com/t/issue-calculating-counts-with-airtable-integration/5027>\
**Category:** Get Help\
**Created:** [October 19, 2020, 12:02pm UTC](https://forum.adalo.com/t/issue-calculating-counts-with-airtable-integration/5027 "2020-10-19T12:02:36Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![vishalpulikottil](https://avatars.discourse-cdn.com/v4/letter/v/b77776/32.png) [@vishalpulikottil](https://forum.adalo.com/u/vishalpulikottil)\
**Post date:** [October 19, 2020, 12:02pm UTC](https://forum.adalo.com/t/issue-calculating-counts-with-airtable-integration/5027/1 "2020-10-19T12:02:37Z")

</div>

I’ve integrated AirTable into my Adalo app as an external collection. When filtering lists, it works like a charm. I just use the filterByFormula query parameter and it does the job.

However, when trying to use Airtable data for other things (like adjusting the visibility of a component or just calculating value counts) I run into problems.

1. When I put add Magic Text on a text field and have it return a count of records, it gives me 100 instead of the 3000+ it’s supposed to show:  

2. When I add any filter that count Magic Text (any filter at all), I get zero as the result:  

Please help! Thanks!

---

<div class="post-metadata">

**Author:** ![anon78309838](https://avatars.discourse-cdn.com/v4/letter/a/b9bd4f/32.png) [@anon78309838](https://forum.adalo.com/u/anon78309838)\
**Post date:** [October 20, 2020, 7:51am UTC](https://forum.adalo.com/t/issue-calculating-counts-with-airtable-integration/5027/2 "2020-10-20T07:51:47Z")

</div>

1. Airtable API response is limited to 100 records. That is why you are seeing only 100 there.
2. Without seeing how the table is setup on Airtable I cannot tell you if that filter is accurate or not.

---

<div class="post-metadata">

**Author:** ![Londya](https://avatars.discourse-cdn.com/v4/letter/l/c5a1d2/32.png) [@Londya](https://forum.adalo.com/u/Londya)\
**Post date:** [October 21, 2020, 2:27am UTC](https://forum.adalo.com/t/issue-calculating-counts-with-airtable-integration/5027/3 "2020-10-21T02:27:40Z")

</div>

Are you guys planning to see if this limit can be increased??

---

<div class="post-metadata">

**Author:** ![anon78309838](https://avatars.discourse-cdn.com/v4/letter/a/b9bd4f/32.png) [@anon78309838](https://forum.adalo.com/u/anon78309838)\
**Post date:** [October 21, 2020, 9:46am UTC](https://forum.adalo.com/t/issue-calculating-counts-with-airtable-integration/5027/4 "2020-10-21T09:46:36Z")

</div>

This limit is imposed by Airtable and not from us.

---

<div class="post-metadata">

**Author:** ![Londya](https://avatars.discourse-cdn.com/v4/letter/l/c5a1d2/32.png) [@Londya](https://forum.adalo.com/u/Londya)\
**Post date:** [October 23, 2020, 10:25pm UTC](https://forum.adalo.com/t/issue-calculating-counts-with-airtable-integration/5027/5 "2020-10-23T22:25:22Z")

</div>

Hi Colin,

Thanks for replying. I contacted Adalo via email 2 days ago about a payment issue and I have not heard back from anyone. However, I saw someone opened my email this morning, but did not respond. Can you please help me??

Londya

---

<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:** [November 2, 2020, 10:25pm UTC](https://forum.adalo.com/t/issue-calculating-counts-with-airtable-integration/5027/6 "2020-11-02T22:25:24Z")

</div>

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