- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 17, 2025 09:22 AM
API for searching in multiple bases
Hi community,
My company developed an API to search multiple databases, we used Airtable for a talent pipeline for the company's recruiting team, and we found ourselves with the limit of 50,000 records (teams plan).
Instead of upgrading the plan, we developed this solution. We divide our base by years and create several bases. And with this new program, we can search through all the databases quickly and effectively.
I share screenshot
In the API, you can search multiple fields (in the example, we search through name and Linkedin link), and then, it shows in which base the API found the specific record (Of course, you can choose which fields you want to display.)
IF YOU ARE SHORT ON SPACE, YOU DO NOT NEED TO BUY A HIGHER PLAN, JUST CREATE MORE BASES
Thanks!
Lucas

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 17, 2025 09:35 AM - edited ‎Feb 17, 2025 09:37 AM
You are correct that record limits are per base. However, API limits are for the entire workspace. Same thing with automation runs — automation runs are for the entire workspace.
You can workaround the automation limits by using an external automation tool like Make, but there isn't a way to get around the API limits unless you create additional workspaces.
You can see your current workspace limits by going to your home page, then clicking on your workspace in the left margin, and then in the right margin, click on the 3 dots and choose "Workspace Settings".
Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 17, 2025 09:47 AM
Nothing to do with this solution.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 17, 2025 10:03 AM
Hey @Lucas_Ravassall!
I'm usually against splitting data into multiple bases, specially if that data is somehow related and used for data analytics. However, if you do not have such need, this is for sure interesting and I'm glad it works for you!
I see you speak Spanish also. If you ever want to have a fun Airtable discussion in Spanish, I'd be happy to get to know you (and any other Spanish speaking Airtable power users!).
Feel free to grab a slot from my calendar. Saludos!
Mike, Consultant @ Automatic Nation
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 17, 2025 10:08 AM
Thanks Mike!
