Google Apps Script for the Move to Islandora Kit Mappings Helper.
This code is "bound" to a Google Sheets spreadsheet. To use it in your own Sheets application, open the Sheets "Tools" menu, and then the "Script editor" submenu. Paste the code in the Code.gs file into the script editor and save.
The code contains an onOpen()
function, which runs when the spreadsheet is opened.
Thanks to @terrywbrady for his talk at Code4lib BC 2016, which alerted me to this approach to building a simple user tool for creating MIK mappings files.
If you have any questions about this code, please open an issue.