Ok first this is the set up:
1 table base
7 separate table tabs with individual table names
Using react and the npm airtable package
I am making a call in the api to retrieve 1 record by its ID.
const base = new Airtable({ apiKey: Key }).base(id);
const table = base(‘table name’);
const recordId = 'recordidfromairtable';
table.find(recordId, function(err, record) {
if (err) {
console.error(err);
return;
}
console.log('Retrieved', record.id);
});
This works and returns the record. However it seems if you change the table name you are searching on as long as it is a valid table name it still returns the record even if it sits in a different table.
Now whilst this is a functionality we are looking for i.e. a search on all tables in a base. This doesn’t feel like this should be working. i.e. if the table name doesn’t contain the recordId then it should fail but it still returns the record regardless of the table you are searching?
After reading various documentation searching all tables does not seem to be functionality that exists currently so I am surprised this is working.
Anyone have any thoughts suggestions or should I report it as a bug?