Search Multiple Bases

[Lucas_Ravassall]

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

[Sachin_191]

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.

[Lucas_Ravassall]

Thanks for the feedback!