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 2)
We saw in this post that buttons can be used to execute a script against a specific record.
[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).
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:
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]Converting scores to ratings
In this post, we’re going to look at how you can convert a score to a rating (using the Airtable “rating” field).
[Read more]createRecord vs. createRecords (part 2)
In this post we looked at how to create records in a base using the createRecord method - one record at a time. Airtable also gives us a way to create multiple records in one go using the createRecords method.
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]