Introducing scripting block

https://blog.airtable.com/content/images/2020/02/blog.png

With the new scripting block, you can reduce the time you spend on repetitive tasks and uncover deeper insights with powerful queries and custom reporting. All it takes is a a bit of JavaScript!

Our new scripting block reduces the time you spend on repetitive tasks and uncovers deeper insights about your data with powerful queries and custom reporting. Take your workflows to the next level by writing and running JavaScript directly inside Airtable.

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?

In addition to standard JavaScript functionality, the scripting block gives easy access to all the data in your base, across all your tables. It can also create and update records. There’s so much you can do with the scripting block, but we think there are a few particularly great use cases.

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

Continue reading

This post was originally published on this site