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 these powerful use cases available:
Find and replace: find and replace all text matches for a fieldConvert URLs to attachments: upload all attachments for URLs in a fieldAdd image from Google Maps: insert an aerial view of a location from Google Maps into an attachment fieldDelete duplicates: find and remove duplicate records in a table based on two input fieldsRandomize values: fill all cells in a particular field with random valuesValidate emails: list all invalid emails for a fieldCreate junction table: create all possible combinations of linked records from two tablesCreate child linked records: for a record in a “parent” table, create “child” records in another tableImport YouTube analytics: enrich your table with metadata for your videos via the YouTube Data APICreate records for multiple templates: create tasks from a template based on project typeTable optimizer: turn long records into individual data pointsShift scheduler: assign people to shifts or events based on their recurring availabilityIt’s plug-and-play
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!
Sign up for Airtable for freeContinue reading