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:
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.