Scripts | BuiltOnAir

Forecasting & Machine Learning

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

Asset Reservations: No Double-Booking

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.

Programmatically copy images from one table to another

Posted by BuiltonAir Team

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

Link Surveys/Forms Submitted to Contacts

Posted by BuiltonAir Team

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.

Helper Functions for getting Record Information

Posted by BuiltonAir Team

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.

Batching Function

Posted by BuiltonAir Team

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.

Delete Empty Records

Posted by BuiltonAir Team

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

Matching Transaction Names to Single Select Values

Posted by BuiltonAir Team

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.