The inspiration for this script was the many posts that I saw where people wanted to setup default values when they create new records. In that way, it is similar to one of the scripts that has already been shared.

However, I believe that there is no one right way of doing things, and I had ideas for a different workflow. This script fills in blank cells in a table based on a template record. It also requires no configuration of the script, and no changes to the existing table/field definitions.

This script has the ability to make bulk updates to a lot of records very quickly, and it has several quirks and limitations. I only received access to the Scripting block when it was made public on Friday, so I didn’t have much time to get up to speed. I have many improvements in the works, but they will all take time to implement, and I need to sleep.

Here is the base on the Airtable universe.

Here is the gist.

Here is a link to the walkthrough.