Airscript Learn to use Airtable scripts

Generating tasks for projects

If you work on projects, there’s a strong likelihood that you will do similar projects again and again. For example, a software development project will often follow the cycle of:

[Read more]

Using buttons (part 1)

We saw in a previous post that scripts can accept some input from the user. Airtable has a number of input records and one of these is the input.record method, which allows the user to pick a record and run the script against this record (with some element of the record data being used in the script).

[Read more]

Setting attachments from URLs

Airtable’s attachment field is useful in lots of different scenarios and the ability to upload lots of different file types makes Airtable a great library tool for pretty much anything. But…the process of getting your files into Airtable can sometime be a bit slow - get the file on your computer, find the record in Airtable, drag the file onto the attachment field of the record, then repeat.

[Read more]

Calculating percentiles

A recent post on the Airtable community forum asked about calculating the kth percentile of a set of data. This is not easy to do in Airtable using formulas, linked records and lookups but is a perfect use case for an Airtable script. So, here we go:

[Read more]

Using 'filter'

The Javascript filter method is great for iterating through your records and finding those that meet a certain criteria. In this post we’ll retrieve a set of records from Airtable, enter a search term and return the records that contain this term. Here’s our data set - a simple list of email addresses:

[Read more]

Adding it all up

We’ve looked previously at a technique to sum data from your Airtable base. This post looks at another adding up technique - summing data by some attribute of the data. Here’s our scenario:

[Read more]

Get help with your Airtable bases

You might not have the time or the in-house resource to bring your Airtable environment up to scratch. Or maybe you want to learn Airtable scripting but you’ve got a pressing deadline that you just need to hit.

[Read more]