Jun 17, 2024 06:48 AM - edited Jul 16, 2024 11:48 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.)
What do you think if we commercialize the API? Do you think it is a recurring problem for airtable users?
Thanks!
Lucas
Jun 17, 2024 09:47 PM
Hey Lucas,
Your API sounds like a fantastic solution for managing large datasets in Airtable without upgrading the plan. By dividing the base by years and creating multiple bases, you've cleverly bypassed the 50,000 record limit, Many Airtable users face similar constraints, especially those in recruiting, project management, and other data-intensive fields. The ability to search across multiple bases and customize search fields adds significant value.
Jun 18, 2024 06:11 AM
Thanks for the feedback!