Skip to main content

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

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.

 

 

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.

 

 


Thanks for the feedback!

This is a problem we consistently have and the ability to search multiple databases would improve the utility of our airtable dramatically! I encourage development of this. 

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

34899i3B1543FE5A3D1E76.png

 

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

is this something you’re still working on? looking for a solution to search across all bases

We are desperate for this solution. Did you ever commercialize it, or found an alternative solution?

We are desperate for this solution. Did you ever commercialize it, or found an alternative solution?

 

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

34899i3B1543FE5A3D1E76.png

 

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

is this something you’re still working on? looking for a solution to search across all bases

Hello. Yes, I am selling it as a software solution product, it only takes 2 weeks to do the discovery and sprint 0 session + product delivery

Hey ​@boppa!

You can probably handle this just by using n8n forms, and n8n’s Airtable integration. As you can self-host n8n this would be super cheap to maintain :D  

More on n8n and other automation tools here.

Feel free to reach out if you need any help setting this up!

Mike, Consultant @ Automatic Nation

Reply


Terms & Conditions