Skip to main content

Search in Multiple Bases

Lucas_Ravassall
Forum|alt.badge.img+6

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

    L
    C
    2 people like this
    • L
      Lynch_Lab
    • C
      Cover

    4 replies

    Sachin_191
    Forum|alt.badge.img+9
    • Sachin_191
    • Participating Frequently
    • 93 replies
    • June 18, 2024

    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.

     

     

    Sachin karma - Automation consultant Growwstasks Automation Solutions https://www.growwstacks.com
    Lucas_Ravassall
    1 person likes this
    • Lucas_Ravassall
      Lucas_Ravassall
    Lucas_Ravassall
    Forum|alt.badge.img+6
    • Lucas_Ravassall
    • Author
    • Known Participant
    • 12 replies
    • June 18, 2024
    Sachin_191 wrote:

    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!

    L
    Forum|alt.badge.img+1
    • Lynch_Lab
    • New Participant
    • 1 reply
    • March 14, 2025

    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. 

    C
    Forum|alt.badge.img+2
    • Cover
    • New Participant
    • 3 replies
    • March 31, 2025
    Lucas_Ravassall wrote:

    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

    Reply


    Most helpful members this week

    Terms & Conditions