Development & APIs

Hey everyone, we at krautreporter are integrating the Airtable API to send some data for further manual processing to Airtable. I wonder how I as a developer can be notified about any planned changes to the Airtable API. As of today the API is AFAIU not versioned. So are you guys at Airtable planning to never remove anything or change any existing behaviour or what are the midterm plans on this topic? Sincerely Gregory

Hi all, I have played a bit with the Scripting block and I am amazed at its potential! Though I am stuck following a recent idea to enhance our base capability. We are managing real estate opportunities and we’d like to create a tool that matches all our client needs with our land portfolio characteristics. Let me explain, I have a table for owners’ requests (CANDIDATES) and another for land characteristics (LAND). I have several other tables with the characteristics by type (identical to the owners’ requests) to identify possible matches between the two. In my CANDIDATES table, I can look up all the LAND for each characteristic in different fields. Now what I’d like is to produce a report or table identifying the unique lands which have all the characteristics of the owners’ requests and that for each Candidate. Any ideas? Thanks a lot Ludovic

There are more fields being returned than in my View through the API. Any suggestions on what could be the issue? Regards, Ruchika

Hi community! We’re so tremendously thrilled to announce that our scripting block has officially launched! With scripting block, you can edit, write, and run short scripts that allow you to enhance and extend your workflows—all within Airtable. In practice, that means you can reduce time spent on repetitive tasks and uncover deeper insights with advanced queries and custom reporting. You can call on external APIs to enrich your records. You can generate new records with the click of a button! There’s tons of use cases, so we’ve put together a showcase of examples written by both our team and the community to help spark inspiration. But in this post, we really want to celebrate the incredible members of our community who put the scripting block through its paces during the beta period. Without feedback and support from @Bill.French, @Openside, @JonathanBowen, @Ronen_Babayoff, @Jeremy_Oglesby, @Russell_Bishop1, @Ju

I’ve been playing with the scripting block a little and it’s definitely a major step in the right direction - well done! However, my first thought after running Hello World was how do I trigger a particular script from an event (say updating of a particular field in a table)? Also thinking about how to run scripts periodically - say a daily update or alert process? Having said that I am of a mind to write a blog post about it - is that allowed on a beta feature?

Hi everyone, just wanted to post a quick thank you note for everyone that participated in the beta and provided feedback that helped make the block better! We’ve just turned on the block for everyone. Check out our post on ProductHunt: https://www.producthunt.com/posts/airtable-scripting-block We highlighted some of the amazing scripts you’ve all shared on the forums :slightly_smiling_face: cc @openside @Bill.French @Jeremy_Oglesby Thank you!

Hi, I’m using Filter By Formula to find records based on Last Modified Date; As per Codepen Airtable URL encoder I get the following syntax; (IS_AFTER(%7BLast+Modified+Date%7D%2C+%222%2F23%2F2020%22)+%3E%3D+0) While syntactically this works fine, the results I get are not correct. I get dates before the given date too. Any suggestions? Regards, Ruchika

Hi, When I access a table-view through an API, fields that don’t have any values are not returned for that record in the API. Is this expected behavior? Regards, Ruchika

Hi Airtable Community! We just wrapped up our first challenge (stay tuned for the winners!) and can’t wait to see what you do with the next! For today’s challenge, we’d love to see how scripting block can help make one of our templates even better. From podcast editorial calendar management to home remodeling to Esports tournament planning, there are hundreds of templates in our gallery, and we have a hunch that at least a few of them could be even more powerful with a script! Things will work the same as last time: Choose a template from our template gallery and create a script for it! Bonus points if your s

I have a patch operation for ~4000 rows of data that enriches airtable data with data from an external source. I minority of rows (233) are raising a 422 permission denied error. The actual error message is: {“error”:{“type”:“INVALID_PERMISSIONS”,“message”:“You are not permitted to perform this operation”}} When I look at the payload of the patch, I don’t see anything exceptional or strange compared to the rows that patch successfully. So I examine the airtable rows that are being patched, and don’t see anything exceptional there either when comparing the success vs failure rows. Does this ring a bell with anyone else? Anything I should look for to fix the bug? I’m out of ideas.

Even the initial template of the hello world isn’t working for me now. The input field displays, but it doesn’t return after hitting ‘Next’, the await input.textAsync() doesn’t ever return.

Hello! A very belated happy new year, and thank you for participating in the custom blocks beta! We’re excited to share the newest updates to the SDK, CLI and documentation. One thing before we dive in: we’re looking to feature YOU when we announce custom blocks to the world. As one of our early custom block developers, we’d love to extend an opportunity to highlight a block you built. Please fill out this form by March 9 to be considered. All selected block developers will receive $1,000 worth of Airtable credits! Blocks SDK updates :mouse: We’ve updated Cursor with several new features: the ability to set the current table and view with setActiveTable() and setActiveView() , and the ability to watch and read the currently selected field ids with

Doing some simple substring removal and getting different results from the block than in JS Bin. let renderName = "MX_Topo-Chico-Agua_Mineral-Water_600ml_PET_6x"; let secondaryQuantity = "6x"; // scripting block generates an UNEXPECTED output: "MXTopo-Chico-Agua_Mineral-Water_600ml_PET" output.text( removeSubString(renderName,secondaryQuantity) ); // JS Bin, however, outputs as EXPECTED: "MX_Topo-Chico-Agua_Mineral-Water_600ml_PET_" // console.log( removeSubString(renderName,secondaryQuantity) ); function removeSubString(str,substr) { return str.replace(substr,""); } Oddly, making use of a character (rather than “”) yields proper results. renderName.replace(secondaryQuantity,"1") => "MX_Topo-Chico-Agua_Mineral-Water_600ml_PET_1"

If everyone used a similar schema for base/table schemas, it might help with tool integrations in the future. Here is my initial take: Script: Meta Definition Show and tell Something very often requested is the ability to extract the meta informat

Hello Airtable Community! We’re inspired by the example scripts you’ve started to build in the scripting beta, and we’d love to see more of them! To that end, we’ll be hosting a series of challenges over the course of the beta - with fun prizes ready for the creators of the best scripts :tada: First up: Script Remix Challenge. Remix one of our sample scripts to share with the community, submit it, and we’ll highlight and reward the best of the bunch. You may have noticed that we provide a few examples directly in the scripting block. They’re a great starting place- but we know you can use them as a foundation to create something even cooler. Maybe it’s applying the basic concept to a specific use case! Maybe it’s adding more features or functionality! Interpret ‘remix’ as creatively as you like Here’s what you need to know: Create a base with your custom remixed script in the scripting block

Since the script doesn’t support a {cast:true} feature, I had to create my own function. I figure this is a pretty common use case so easier for all to use similar formula: gist.github.com https://gist.github.com/on2air/97ee258d88490daa31af55940867b385 On2Air: Common Functions /***** * Title: Common Functions for Scripting * License: MIT * Author: Openside (Team behind On2Air products and BuiltOnAir community) * Sites: * https://openside.com - Openside Consulting Services * https://openside.com/#products - On2Air Products * https://builtonair.com - All things Airtable Community

Hi, I’m just getting started with the scripting block, trying a few examples out. When I hit the “copy” button on an example and try to paste the code into the editor window, I can’t find the expected “paste” menu. CNTRL V works, however. I’m using Chrome on Windows 10.

AirTable team: I’m not finding enough info in the documentation to know quite how to link records. I have a Contacts table and an Organisations table in my base. I want to find an organisation and link the a contact to it. I’m guessing the way to do this is to firstly find the record ID of the organisation (through iterating through the result of myOrganisationsTable.selectRecordsAsync() ) and use this to set the corresponding field in my contacts table? Do I need to do the same thing the other way round too - so add the contact ID to the Contacts field in my Organisations table? Some code examples along these lines would be good…

Hey, Would love to have a notification component, similar to the black ‘Undoing last action’ and ‘Record moved to trash’ notification you get in the primary Airtable UI. One that slides in and disappears automatically. Cheers, Ronen Superblocks.at

Running an example script from the Scripting block docs inside the Airtable Electron app (on Windows) generates an error. Running the same script in a browser view of Airtable (in my case: Firefox) works as expected.

I am working on an Alexa skill that executes a GET from an Airtable base where the record contains a field whose field type is Attachment. The GET in the Alexa skill assigns whatever is passed from Airtable to a variable. I don’t have a means of displaying the Alexa variable to see the contents. From the API documentation, I understand an attachment field will pass a field ID, the URL of the object and the file name of the object. Could someone provide an example of what is passed from the API using the following example: AudioField=api_response.records.0.fields.AirtableAudioFile; After execution, what is the contents of AudioField? Audiofield = ‘xxxxyyyyzzzz’ Thanks in advance for your reply!

There’s been a few recent posts about using fetch() in the new scripting block. Here’s another question/use case that’s not currently working for me. My office uses Airtable for, among other things, tracking course videos through the editing process. Videos are hosted on Vimeo and one task we do is pull in the latest runtime. This can be done easiest through Vimeo’s oEmbed API which includes a “duration” field that provides the length of a video in seconds. The problem: our videos are private and accessible through (able to be embedded on) a small whitelist of domains. Using the “old” API, this worked as I could set the referrer to our domain (the code was written in NodeJS and called the https.get() method). I’ve tried adding “airtable.com” and “api.airtable.

Hey, I’ve been looking on all the sample blocks, but couldn’t find an example of how to use the watch / unwatch functionality in a fine grained matter. Specifically, do I need to call unwatch to cleanup after I call watch and if yes, use react useEffect to do that? I don’t want to call useWatchable, because then I have to store a copy of the watchable key value in useState and compare new watchable value to current value in state and it seems like overkill. My use case involves tracking the cursor.activeViewId. Thanks, Ronen

Hey everyone! Trying to figure how to to get data from MongoDB to Airtable. Out of all the connectors/automators, Parabola seems to be the one to do the trick. However, on the final “API Export” step I am running into difficulties. I am non-CS, so maybe I am missing something super silly :grinning_face_with_sweat: Parabola asks for the following: Request Type API Endpoint URL Body Max Requests per minutes Authentication Type Bearer Token Here’s what I did: Opened the Airtable API page for the corresponding base. Copied the Endpoint URL from the top of the cURL interface Copied the snippet of code starting after "fields": into the Body { "User ID": "{id}", "First Name": "{first}", "Last Name": "{last}", "Email": "{email}", "Business ID": [ "{business}" ] } I

In my data science work, I often need to find outliers. There are many ways to do this and one might think it can be done reliably using a simple filter - e.g., Show me anything that falls outside this range. This assumes (a) you know the correct range of outliers, and (b) the context for the range is never likely to change. In practice, your data will prove you wrong about these assumptions time and time-again. In cases where transaction flow is small, a quick scan will usually suffice to see if your data passes the sniff-test. But when you have many thousands of records and dozens of fields to consider, you might want to audit your data with powerful statistical analysis. Ideally, you need a process that can learn based on all of the data available and apply its rules consistently, even when you’re not in the room. To that end, here’s a script block that uses the