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.
There are many possibilities with a button field that can run a script. Custom blocks also has many possibilities. I am working on several projects and am thinking through different workflows and different features before deciding which workflow to implement. Lots to code, lots to learn, lots of fun!