Overview
Scripting lets you write short scripts to reduce time spent on repetitive tasks and uncover deeper insights with advanced queries and custom reporting. A script can:
- Determine a list of duplicate records with custom logic to identify and merge duplicates
- Determine a list of records that don't satisfy a custom constraint or validation rule (e.g. each person may only have up to 3 active tasks assigned to them)
- For each record in a view, compute a value based on the other cells and write the result to an output field
- Fetch information from an API and write the result to an output field for each record (e.g. currency conversion rates)
- Prompt the user for the name of a new project, then automatically create the relevant project and task records
Getting started
To get started building a script on your own, you'll need a basic understanding of JavaScript. We recommend you use one of our example scripts as a starting point for your own script or checking out the community forum for inspiration.
We also have scripts available in the Marketplace that you can install directly into an Airtable base. If you're interested in submitting a script to be considered for inclusion in our Marketplace, read more here.
In your script, you can use anything from the JavaScript standard library, except for DOM APIs that interact with HTML on the page. The scripting extension also comes with Airtable-specific classes and methods for accessing and updating data in your base, as well as for user input and output. To learn more about what's possible, explore our API reference.
Other resources
- MDN JavaScript Guide - Get a high-level overview of fundamental JavaScript concepts.
- Codecademy Introduction to JavaScript - Learn JavaScript in this free online course with interactive lessons.
- Community forum - See what other Airtable users are doing with the scripting extension and get help writing your own scripts.
- Airscript tutorials - Learn to write Airtable scripts. An introductory resource written for people who are getting started with programming.
- Developer Policy - If submitting a script to be published on the Airtable Marketplace, be sure to review our Developer Policy.