Development & APIs

When querying the metadata api for view metadata, currently the only information included is the view id, name, and type. It would be great to get list of the filters used, and the fields referenced in the filters, similar to how we get ‘fieldIdsReferencedByFormulaText’ for the metadata of a formula field! "views": [ { "id": "viwQpsuEDqHFqegkp", "name": "Grid view", "type": "grid" } ] For context, please see how we are using the metadata api to get a high level view of the structure of our bases here

(This is a copy of my question on Stackoverflow. It’s not getting any attention there so I decided to bring it here.) First, let me start with what I want to achieve. I want to query a table in Airtable that includes data from a linked table. Airtable returns the IDs of records in linked tables so I need to do a second lookup on each of those records to get the data I want (e.g. Name). Ultimately, I want to return to the client the ID and the other fields from the linked record. Problem is, I’m failing to achieve this because of the asynchronous nature of the API and my lack of understanding. The best I’ve been able to do so far is execute a bit of code in the done() callback of their API. The problem is that this isn’t scalable because it means I’ll get myself into callback-hell. (

I’m using the API to store the created time of a record in a separate field right after creation. It duplicates the value of the original created timestamp. Sometimes the formula is different when querying the record later though. Please have a look at the screenshot. The 2 formula fields show the timestamps in detail. The first row shows that the created time now is 1 second later than it was when the value was queried when it was copied earlier… It doesn’t happen consistently though. Could it be a rounding issue?

Hi I have a field that contains attachments that were uploaded via the an airtable form. I am created an front-end that connects to this table via API. The data is all returned and I can see the data for the uploaded attachment that has filename,id,size,type,url however, the url returned does not play/download the file. The same link when opened inside the airtable works fine. Are there restrictions on accessing these files?

I am trying to understand the way to formulate either an API call that matches a filtered view on a table I have set up – a base that has date serving, name, venue name, address, zip code, time starting, time ending and cache. I have the filter by in the view of the table set to filter by a specific day and zip code to filter for the first three numbers of the zip code and of course this provides exactly the information I want. My question is, how do I translate this view into an API call so that in a table with multiple entries I receive the information that translates to this more limited scope?

Is there any way in the API to retrieve the record at a particular row number? I know I could get all the rows up to that row number using the maxRecords option of the select method, but that would obviously be quite inefficient. Thanks in advance. -Mark

The ‘4/25/2018’ records are updated with the API. The (correctly displayed) top ones are picked by hand in the browser. The linked table has a formula with a date format as primary field.

Hello, I am working on a report using the airtable api. When you click on a record to expand the record, it opens a form-like view that allows for easy editing. That expanded view has a custom url. Can I get that url via the airtable api? I want to link from my report, directly to allow users to edit that record in expanded view. Thank you,

If there are any other Ruby on Rails devs out there that could help me out, I’m trying to use the airtable-ruby gem to post data from a custom form to an airtable base. I’m new to web development, self-taught, and working alone, so I’m sure my code is a mess and I’m doing things all wrong, but I feel like I have this set up in a way that it should be working. I have as much of it stripped down to the bare bones as possible, but I still can’t figure out what’s failing. Here’s my controller: The form: The log results from submitting: My table:

Hi Really simple requirement but just can’t get my head round it (put it down to advancing years) I want a simple HTML and JavaScript page with a search field that just searches a particular field in an airtable table and returns results Anyone got an example to hand they can share? Thanks Mike

Sorry, no issue, can’t delete a post.

Is there any way to create a new record and insert it at a particular spot in the table (perhaps before or after a given row id) via the API? Thanks in advance. -Mark

Hi, I need to transfer a European time stamp to an API endpoint, and I’ve selected European in a date field type, which looks nice in the Airtable app. However, at the API endpoint I’m getting the date formatted in ISO. I used a workaround in some of my other fields using the DATETIME_FORMAT function, but since this is a field type with no formular I can’t do that. Any ideas? Thanks! Sune

Hi - I’m using Integromat to upload a file from Onedrive. The file is uploaded successfully through API call but then it’s immediately removed. Noticed from the history that the file was saved but at the same time another action was taken which removed the file. I have only one action from Integromat on Airtable which is to update the record with the record ID. Any ideas please? Thanks a lot!!

A couple of members have been kind enough to post code snippets to retrieve a base’s schema. I’ve build a small python script that can automate the process. Anyone with Javascript experience should be able to update this without too much trouble to a pure Javascript solution. The code is basically just a ‘proof of concept’ with no error checking to get people started. I hope it’s helpful. The (uncommented) source code follows; an additional post will show sample output of two schema formats (if the forum accepts it). Many thanks to Chester_McLaughlin and Kai_Curry for sharing their original Javascript code. jd P.S. I couldn’t include everything (with download links to installation files) because (as a new user) I’m limited to only two links and the code syntax seems to confuse the forum. Apologies for the omission. from Chester_McLaughlin:

Hi! I can’t undestand this error. Here is my code using JQuery and Ajax: $(document).ready(function(){ x = 1; $("button").click(function(){ $.ajax({ url: "https://api.airtable.com/v0/appHQ1ATs3SjuAC20/XXXXXX?api_key=XXXXXX", type: 'PATCH', dataType: "json", data: { "fields" : { "FIELD": VALUE } }, }); }); }); When I replace FIELD with the proper field name, and the data type of that field is a string, and replace VALUE with a string (e.g., “hola”), I can update the field through the API. But when replace FIELD with the proper name of an integer field, and replace VALUE whit a number (e.g., 1234), I get this error: PATCH https://api.airtable.com/v0/appHQ1ATs3SjuAC20/xxxxxx/?api_key=xxxxxxx 422 (Unprocessable Entity) I tried a lot of things but nothing works. Anyone can help me?

I’m writing a simple resource management application, where staffers enter for each month the percent of their time they spend on various projects. I store those allocations as "percent’ fields in an Airtable table. I collect inputs for these from a node.js web page, and want to update the allocations in the database. When I pass the values to the update() function, I see the following: error: ‘INVALID_VALUE_FOR_COLUMN’, message: ‘Field May 17 can not accept value 15’, I suspect that the system is seeing string values instead of the required number values, but don’t know how to deliver the correct format from JS. I’ve tried the value with and without quotes, and also tried submitting parseInt(value). Note: I’m also using eval() to generate the update() command, as my function handles the update field names as variables, which also seem to be a problem // build the update string var updatestr = "base(\'allocations\').update(\'" + re

I am trying to develop a Chrome Ext which would need to talk to different Airtable Bases under the same Airtable account. Hence I need to programmatically get the AppID for a table in question. Any idea about how to do that? Is there an HTTP request service for that? I need this urgently as I other people are depending on this Chrome Ext. Thanks in advance.

Hi, Does anyone know what the first parameter is for the find function. Here is my example i found from the api docs base(‘Clothes’).find(‘recHCaksbNTrZKM2g’, function(err, record) { … Many Thanks

Hi, I’m using the API to send my new Firebase entries (function) in Airtable but I’m having a problem. Some of these values are identfiants to add values from a Lookup (Allow linking to multiple records). But when adding some values can be null (it comes from checkbox) and then I have an error message like this: Value “” is not a valid record ID. Does anyone have an idea how to make Airtable understand not to consider if it’s null and just take those with a value? Exemple : function createAirtable(id) { var t1 = event.data.t1; var t2 = event.data.t2; var t3 = event.data.t3; var t4 = event.data.t4; base('Deb').create({ "Date": xxxx, "Client": [id], "Heure": xxxx, "Etat": xxxx "Description": xxxx, "Info": xxxx, **"Véhicule": [t1, t2, t3, t4]** <== id for the lookup but some values will be empty }, function(err, record) { if (err) { console.error(err); return; } }); }

How can I make a database that is ordered by timestamp. I would be using this as an API and need items to be changed based on time and I can not figure this out. I’m very new to all of this and could really use the help. Thank you

@JB_Bakst Thank you so very much for publishing the Slack Slack Command How-To and Glitch repo!!! https://blog.airtable.com/api-content-series-slack-slash-command-app/ My team has this up and running on two of our most critical bases. It’s a longstanding dream come true (as Zoelle can tell you)! A few questions though… How can we specify the fields returned within the Slack message attachments? We have 80+ fields in our base and only want to return a very small sub-set. Can this filtering be done via View? Once we have limited the fields returned, how can we specify the order in which they are returned? Right now we are seeing variance in the order of the fields returned, between attachments. You suggest pagination for navigation of 10+ returned rec

Hi, I’m new to the world of javascript and node.js – actually, I haven’t written much code for a decade, but I’m interested in building an Alexa skill which pulls data from an Airtable base. I’m stuck with this function (below or on pastebin). Everything that gets displayed on the console is what I expect, however, I can’t work out how to get the function to return the string ‘Series Title’ (I know it’s something to do with the mystery of asynchronous code). Any ideas of where I’ve gone wrong (or pointers to tutorials/examples to help get my head around this). GPDataHelper.prototype.getSermonSeries = function(date){ var err, records, weekRecord, seriesRecord; var series, seriesID, seriesTitle; var filter = 'IS_AFTER({Date}, "' + date + '")'; base('Week').select({ maxRecords: 1, view: 'Main View', filterByFormula: filter, sort: [{field: "Date"}] }).firstPage(function(err,records) { if

Hi, I use Airtable a lot as a data and project / Task management tool but at a relatively basic level. I’m not overly codey (which is perhaps why i like airtable). The base i use includes two tables, one for projects and one for task that i structure and use as expected. I have a lot of small projects and its working really well. I like the Kanban view, my brain reacts better to it. I would like some board views filtered by project, as that is a value referenced from the projects table i can’t use that as I’m aware. As this is only something i need for my larger projects i have current added a single select value for those larger projects that i assign to the relevant tasks. Work ok but it is manual and a little clunky. Any suggestions on how this could be automated or made smoother appreciated. Rob

How do I filterByFormula to exclude if a linked field is empty using CURL.