While Airtable's core feature set has enabled our customers to develop some incredibly useful bases to streamline their workflows, we often see them getting hung up on manual efforts required to perform complex tasks like data validation, creating batch records, and data deduplication.
to converting data into project reports:
to adding images from URLs:
And that’s only a few!
Well, today that changes.
Introducing: script templates
We’re thrilled to launch script templates in the Airtable Marketplace. Script templates are pre-built scripts listed in the Marketplace, ready for you to install into your base and use with just a couple clicks. At the time of the publication of this article, we've made these powerful use cases available:
- Find and replace: find and replace all text matches for a field
- Convert URLs to attachments: upload all attachments for URLs in a field
- Add image from Google Maps: insert an aerial view of a location from Google Maps into an attachment field
- Delete duplicates: find and remove duplicate records in a table based on two input fields
- Randomize values: fill all cells in a particular field with random values
- Validate emails: list all invalid emails for a field
- Create junction table: create all possible combinations of linked records from two tables
- Create child linked records: for a record in a "parent" table, create "child" records in another table
- Import YouTube analytics: enrich your table with metadata for your videos via the YouTube Data API
- Create records for multiple templates: create tasks from a template based on project type
- Table optimizer: turn long records into individual data points
- Shift scheduler: assign people to shifts or events based on their recurring availability
To install a script template, simply navigate to the "scripts" section, select the use case that best fits your need, and install it directly into a scripting app in your base. That’s it.
Scripts are a great way to add advanced functionality to your Airtable base, and with the introduction of script templates' plug-and-play functionality, it's never been easier to use them.
Wanted: savvy script authors
The power of scripts is limitless, so we're opening up the inspirational floodgates by allowing our community to submit their own innovative script templates for Airtable Marketplace listing.
Have something for consideration? Submit it here for review and our team will add it to the queue for listing. Happy scripting!