Hello!
I’ve just come across Airtable and was experimenting with it as an alternative to Google Sheets. My question is, if my application requires multiple databases, can string searches be performed across them?
Thanks,
B
Search Across Multiple Databases
+4You could setup multiple tables for each “database” you need to search against and then create a table that performs Lookups across the other tables and use that table as your Search table. To further assist in the searching can create the primary ID field to include all the lookup information in one line.
I.e. Tables: Names, Orders, Shipments, Search
Search Lookups: {Names} - {Orders} - {Shipments}
+4You could setup multiple tables for each “database” you need to search against and then create a table that performs Lookups across the other tables and use that table as your Search table. To further assist in the searching can create the primary ID field to include all the lookup information in one line.
I.e. Tables: Names, Orders, Shipments, Search
Search Lookups: {Names} - {Orders} - {Shipments}
Are you saying use multiple tables rather than multiple databases?
Because you can’t do a lookup from a seperate database
+4Are you saying use multiple tables rather than multiple databases?
Because you can’t do a lookup from a seperate database
Correct, use Multiple Tables and perform your Lookups into one Master Table.
+8Yes, you can search in multiple bases with an API
https://community.airtable.com/t5/development-apis/search-multiple-bases/td-p/187372
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.