Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Hi, I’m having problem to create new record with a link to another record. An “422” error occurred when trying to create record on "appfIRESxNQnQ5D05:prodej" : Value “recl8c3CDNQECQCyR” contains duplicate value. Each record ID must appear only once I...
Since Zapier already has the ability to show base table and view info I was wondering if there could be (is?) an option to query metadata from the api. It would enable me to automate some checks and create Zapier-like ease of use.
Hello! We just released updates to the API that allow filtering which records are returned using a formula, limiting which fields are returned, and sorting on multiple fields. You can read more on our blog or in the API documentation.
Anyone able to give us a quick run-down of how to code a Slack Bot that can answer queries against an Airtable dataset? Specifically, we’re looking to build a bot that can define terms; a glossary using Airtable for look-ups. But that said, I’m sure ...
Hi, I’m using the Node library to access the API. As I understand it, when the value in a field is a reference to another table, the only thing that’s returned is the ID of row in that table. So, if I have a Books table and an Authors table and use s...
I’m using the Airtable API to pull down data from a View that is filtered by “now” filters. I have a calculated field which returns how many days it has been since that record was created (to return “everything that was created yesterday”) as well as...
If I PUT a record without including every field, those missing fields are emptied losing the data that they held. Is there a way to PATCH a record by only supplying the modified fields ensuring the rest are untouched?
Is there a way to use the filterByFormula URL parameter to retrieve rows based on the value of a link column? I can look up text and numeric values, but it looks like link columns are an array. I’ve tried: AND(Column_Name=[recordID]) AND(Column_Nam...
It was referencing the Api for the ‘Favorite Movies’ demo database. To test and learn the api, I was trying to retrieve data from the table Movies and only bring back a description of the movie The Godfather. I tried various codes using the method ‘Q...
I’m attempting to find a list of specific records that also meet other criteria, such as a date—however nothing is returned. AND( IS_BEFORE({Start Date},TODAY()), OR(RECORD_ID()=‘recyZ1f0RSR1rTr3Z’,RECORD_ID()=‘recIFWsWuTPjAkxhg’)) Is it possible to ...
