Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Search feature in All airtable

370 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Lucas_Ravassall
6 - Interface Innovator
6 - Interface Innovator

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

Lucas_Ravassall_0-1739812821089.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.)

IF YOU ARE SHORT ON SPACE, YOU DO NOT NEED TO BUY A HIGHER PLAN, JUST CREATE MORE BASES


Thanks!

Lucas

 
4 Replies 4
ScottWorld
18 - Pluto
18 - Pluto

@Lucas_Ravassall 

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

 

Nothing to do with this solution.

 

Mike_AutomaticN
10 - Mercury
10 - Mercury

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

Thanks Mike!