Airtable provides us with API documentation which tells us what URLs we must talk to from our React web app. Open your text editor and go to the App.js component. Let’s add state to our component. State is for storing data that changes, such as a ticking timer, number of clicks, or responses from API calls. The first Vue.js 2 and Laravel book! Learn by building awesome interactive web applications. An Angular module wrapping the Airtable API.
Note: at the time that this blog post was written, “Airtable Apps” were called “Airtable Blocks.” Since then, we’ve renamed Blocks to Apps, and introduced a whole new Apps Marketplace! Learn more about it here.
Code, you say?!
The scripting block is a powerful new tool, but it’s made for everyone. If you’ve ever used a macro in another application, you’ll feel right at home. The scripting block makes it simple to grab a pre-made script, modify one of our many examples, or write something from scratch.
No matter how much experience you have writing code, the scripting block is here to help. With documentation and autocomplete personalized to your base, it’s easy to see exactly how to work with your data.
And because everything is done inside Airtable, there’s no need to worry about where to put your scripts or how to keep everyone up to date. Running your latest creation is as simple as clicking a button.
So what can it do?
Streamlining repetitive, multi-step workflows. You use Airtable to plan concerts and other live events. Every time you start planning a new project, you have to manually create the same 20 tasks from a template, assign the right collaborators, and set the right due dates. Now you can write a script that does it all at the click of a button!
Data validation and formatting. You use Airtable to track Tweets for your team’s social media accounts. Anyone can submit an idea, but you need to make sure certain words and phrases aren’t used. On top of that, you want to automatically format dates and add emoji for specific words. You’ve got to read and update every single submission. Or do you? Scripting block makes it easier than ever to work with your data.
Cross-table search and reporting. You track your shop’s inventory and finances through Airtable. You have a table for expenses and payments, another for unsold stock, and a third for all the assets you own. Now you can generate all your business metrics, like net worth, revenue versus fixed costs, and more in no time flat.
Pulling in external data. You use Airtable to track and categorize images for use in presentations and brainstorming exercises. Every morning you use a service like Unsplash to search for new images, but the workflow requires lots of switching between Airtable and Unsplash. Now you can pull images directly into Airtable for review with a script! Bonus: Someone on the community forum has already written the script.
How do I get started?
Install the scripting block just like you would a new chart or page designer. Just head on over to the blocks gallery and search for ‘Scripting’.
If you’re currently on a free or plus plan, you can get a free two week trial of Pro here to try the new scripting block!
Once you’ve installed the block, you’ll be able to start editing right away. There’s documentation customized to your base right in the block, and lots of examples to get your creativity flowing. We’ve also got an amazing community forum with Airtable creators excited to lend a helping hand.
Finally, we’ve written a few scripts that we thought would be useful right out of the box. Not to mention a host of amazing scripts made and shared by the community:
• Automatically add default values for every field type
• Forecast sales by month for the next three years
• Detect scheduling conflicts
• Track where you’ve published social media content
This is just the beginning of an exciting new journey. We have all sorts of goodies planned for the future, and we can’t wait to see all the amazing things you build. If you make something you’re particularly proud of, share it on the forums or drop us a note here.
Airtable is a very cool application. It’s a spreadsheet merged with a database. And it has an API that you can use with JS.
npm init -y
- First open Airtable and click
Add a base. Select
Start from scratchand give your base a name.
- Then open the API and click your newly created base. and copy the ID of your base, which will be shown on that page.
- Visit Account and click
generate API key
npm i airtable
Now let’s create an index.js file with the following content and insert your
api key and you
Airtable Json Export
By default your base will have a table named
Table 1 which has three fields:
Attachment. This code shown above will insert a Name and a Note and return the id of that record.
In general you should never have your credentials directly in the code. Usually you inject your credentials via Environment Variables
Getting a record by its primary field
Update or Insert
You might run into situations, where you want to update a record if it exists or insert it, if it doesn’t exist. There is no built in command for this, you we’ll have to do this manually:
- get the record (by one or multiple fields)
- if the record exists: update it
- if it doesn’t exist: insert it
Let’s write a little module for this:
Interested in more content like this? Subscribe to my weekly Newsletter!