Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How to find records by given condition and quantity?

Topic Labels: Automations
374 3
Showing results for 
Search instead for 
Did you mean: 

I want to somehow find the number of records using a given condition and count.
Example: I have 10 records that match the condition, but I only need 5 of them, how can I get only 5.

3 Replies 3

Airtable’s interface doesn’t offer the ability to limit records, but you can limit records with the Records List app:

Thank you for support but I’m asking on the topic of automation, not an app for manual use. I mean how can get the required number of records automatically

You can’t unless you write your own custom Javascripts to do this.

If you don’t want to write Javascripts, you can also use a external automation platform like to do this as well.