Skip to main content

Search in Multiple Bases

  • June 17, 2024
  • 7 replies
  • 249 views
Lucas_Ravassall
Forum|alt.badge.img+8

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

    7 replies

    Sachin_191
    Forum|alt.badge.img+12
    • Sachin_191
    • Participating Frequently
    • 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
    Lucas_Ravassall
    Forum|alt.badge.img+8
    • Lucas_Ravassall
    • Author
    • Known Participant
    • 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.

     

     


    Thanks for the feedback!

    L
    Forum|alt.badge.img+2
    • Lynch_Lab
    • New Participant
    • 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+4
    • Cover
    • New Participant
    • March 31, 2025

    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

    B
    Forum|alt.badge.img+4
    • boppa
    • Participating Frequently
    • June 17, 2025

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

    Lucas_Ravassall
    Forum|alt.badge.img+8
    • Lucas_Ravassall
    • Author
    • Known Participant
    • July 7, 2025

    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

    Mike_AutomaticN
    Forum|alt.badge.img+28

    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

    Terms & ConditionsAccessibility statement