Issue calculating counts with AirTable integration

Get Help
1

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:

    step1
    step1728×615 59.9 KB

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

    step2
    step2949×1049 73.9 KB

Please help! Thanks!

2
  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.
3

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

1 Like
4

This limit is imposed by Airtable and not from us.

5

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

6

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