When we send an update operation to Airtable, it returns all fields from the updated record, is there a way to filter those fields and return only the necessary ones in the same request, without needing to use query the record again? Like when fields...
I saw there are 2 another topics involving metadata, but I want to emphasize how much important this is to developers to improve their applications and reduce request overhead in Airtable API, that would benefit both the company and their clients (wh...
Hello there!
I was trying to create an filter that acts like this SQL:
SELECT * FROM table t
WHERE t.Status = “Pending” AND t.Name == “Robert” AND … (and so on…).
How can I translate that to Airtable Filter By Formula in the API? I just want to retur...
And for getting fields from the other table, you have to use a Lookup column, to reference the item from the other table and bring it to the ‘Main table’.
Hi @Bill_McIntyre, in order to use the similar to JOINS, you have to link in the main table you are going to select to the other table, using the ‘Link to another record’ column, once you added and linked the record to the main table, you can filter ...
So… As you didn’t read my question properly, I’m here to answer it.
Using the airtable package, airtable.js, I’d reached what I wanted using the filterByFormula inside the select() function with a custom function that concatenates the fields I want t...
