Code snippets for Script actions in Airtable Automations

Functions.js

// Utility functions for Airtable Automations

/**
 * @param {string} url
 * @param {Base} [forBase=base]
 */
function getTableFromURL(url, forBase) {
    let root = forBase ? forBase : base
    let found = url.match(/^https?:\/\/airtable.com\/(?<tableID>[^\/]+)/)
    return root.getTable(found.groups.tableID)
}

/**
 * @param {string} id
 * @param {Table} inTable
 */
async function getRecordByID(id, inTable) {
    let records = await inTable.selectRecordsAsync()
    return records.getRecord(id)
}

Snippets.js

// Code snippets for Airtable Automations

// Update record fields, by default only when they have no value yet
const update = {}
const fields = [
  {name: '__name__', value: '__value__'},
  {name: '__name__', value: '__value__', always: true}
]

fields.forEach(f => {
    if (f.always || !record.getCellValue(f.name)) update[f.name] = f.value
})

if (Object.keys(update).length) await table.updateRecordAsync(record.id, update)