AIRTABLE SCRIPTS

A Library of Community Generated Code for the Scripts Block

Forecasting & Machine Learning

by Bill French

The script is designed to utilize historical data to forecast dates in relation to projected sales.

View

Asset Reservations: No Double-Booking

by Kamille Parks

This script allows you to schedule a new asset reservation in a form-like interface by setting a date range, then selecting from a list of assets which are un-reserved for that time period.

View

Programmatically copy images from one table to another

by Joel Lewenstein

This script will copy images from one Table to another Table.

View

Link Surveys/Forms Submitted to Contacts

by Jeremy Oglesby

This script will automatically establish links between submitted forms and existing contacts. In addition, this particular version also logs a survey/form submittal as an “Interaction” in the Interactions table.

View

Helper Functions for getting Record Information

by Kuovonne

These two helper functions are designed to make future access to cell values more accessible to other parts of a script by turning cell values into object properties.

View

Batching Function

by Jeremy Oglesby

This function returns either an integer equal to the number of records that were processed by the function (this is the case for the ‘Update’ and ‘Delete’ paths), or an array of the recordId’s of the new records created by the function.

View

Delete Empty Records

by Kuovonne

This script is a utility to delete empty records from a table.

View

Matching Transaction Names to Single Select Values

by Jeremy Oglesby

This script checks all imported transactions that do not have a “Paid To?” Single Select value to see if they have already been assigned the import name to a value yet.

View

Mail Merge with Lob.com

by Bill Carovano

This script takes data from a table to perform a mail merge using the Lob.com service.

View

Setup blank cells

by Kuovonne

This script lets you quickly populate those values in blank cells, based on a template record in your table.

View